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’ bytesThis 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:

Edit the my.ini file with whatever text editor you like, and add these lines to the end:
#Max packets
max_allowed_packet = 128MNow 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!
Related Content
AcquiaBlog

2010 has been an inflection point for the Acquia partner program. We are doing more business than ever with partners, including case studies with Palantir.net, Blink Reaction, and IBM Global Services.
Bryan House
It is that phase of my life! I'm just turning 30 in a month, working with Drupal for 7 years and just had my third Acquia anniversary a week ago. Time to look back and evaluate how things went, all the good and bad things; even better if the wisdom can be shared with others. This was part of my thinking when I submitted the session titled "Come for the software, stay for the community" for Drupalcon Copenhagen.
Gábor Hojtsy
It sounded like a really simple request: "Is it easy to add a search filter for 'My posts'?". In other words, add a search result facet for posts by the current (logged in) user through the Apache Solr Search Integration module APIs?
But then the wheels start turning - we want not just one blind link, but a real facet link that tells us how many results we'll get. Also, if we are filtering by 'My posts' then we probably have an equal use case for the opposite filter 'Posts not by me'. So we really need a facet block with two links and facets counts.
Peter Wolanin







Comments
Greg Knaddison
Great advice, especially
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?
Joshua Brauer
We do have an issue in the
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