The S-Files: Acquia Drupal Stack installer Got packet bigger than max_allowed_packet bytes

Tech Support Case Studies

The S-Files are a taste of the support that you get with a subscription to Acquia Support. Our support team helps you solve technical problems relating to your Drupal sites.

The Acquia Drupal Stack installer is a major productivity booster for getting up and running in the development of your Drupal site. Sometimes, though, Drupal modules like to cache huge data packets in the database. This results in an error in your browser that says this:

Got packet bigger than ‘max_allowed_packet’ bytes

This is an indication that the data being sent between Drupal and the database is large, and exceeds the default setting.

Fortunately the fix for this is easy. In the application installation directory of the stack installer you'll find the following directory and file:

Applications/acquia-drupal on my Mac

Edit the my.ini file with whatever text editor you like, and add these lines to the end:

#Max packets
max_allowed_packet = 128M

Now stop and start the Acquia Drupal Stack using the Acquia Drupal Control Panel, and the new setting will come into effect. This should solve your max_allowed_packet problem!

Comments

Posted on by Greg Knaddison.

Great advice, especially given the unique location of configuration files in DAMP.

Is there any reason you don't change this in the default or is it just a matter of time before the next release which will include this change by default?

Posted on by Joshua Brauer.

We do have an issue in the backlog to change this. Hopefully it will be in one of the next releases.

Thanks,
Josh
Acquia Technical Assistance Center