MySQL server has gone away

I have had this one 2 times now. And it's always the same thing: too many fields in CCK.

Too many fields means too large queries to update the cache. And then MySQL goes down with this nice error message.

How to solve this? Increase the max_allowed_packet to a bigger number in your my.cnf (linux) or my.ini (windows).

If it's not there just add it.

max_allowed_packet=32M

Problem solved!

Written on August 06, 2008 at 14:36, tagged as administration, Drupal, MySQL, server management
  • ""

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

About

drupalcoder.com is a blog on all things Drupal in specific and LAMP on OS X in general. It is maintained by Davy Van Den Bremt, a Belgian (Drupal) web developer and designer living in Ghent. The goal of this blog is to log all interesting things that have crossed the writer's path while developing Drupal sites. You can read all about Davy's professional activities on his LinkedIn profile. If you want to get in touch, use the contact form.