SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

on
This is very critical error found  in MySQL. This error originate when you are dealt with huge records. There are various unanswered forum you will found when you Google that problem. The reason behind this crash is packet size. By default, MySQL configuration max_allowed_packet is set it to 16M. This settings may introduce this exception in your website..

Solution:
To resolve that problem you needs to increase max_allowed_packet variable in MySQL. Add following line in my.ini
max_allowed_packet=100M 

Save the file and restart MySQL service. Now onward you will never get that kind exception in your open source / website.

Comments

  1. VedJune 29, 2011 at 2:53 AM

    Thank you very much!

    ReplyDelete
  2. AnonymousJune 30, 2011 at 7:00 PM

    confirmed, thanks. default install does not put my.cnf on freegbsd port, was not sure if freebsd had my.cnf at /etc/my.cnf or /usr/local/etc/my.cnf so sym linked w

    ReplyDelete
  3. stradivariJuly 22, 2011 at 1:28 AM

    thank you!

    ReplyDelete
  4. AnonymousDecember 8, 2011 at 3:39 AM

    Thanks very much man

    ReplyDelete
  5. AnonymousMarch 11, 2012 at 9:01 PM

    thank you very much!!!

    ReplyDelete
  6. AnonymousApril 5, 2012 at 5:51 PM

    I change from max_allowed_packet=128M
    to max_allowed_packet=256M

    nothing change. still
    PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

    Uncaught exception thrown in session handler.

    PDOException: There is already an active transaction in _drupal_session_write() (line 206 of C:\user\....\acquia-drupal\includes\session.inc).

    what can be the reson?
    THANK YOU

    ReplyDelete
    Replies
    1. Madhav VyasApril 5, 2012 at 10:49 PM

      You should restart mysql server. Using mysql slow query log find it out which query takes too much time.

      Delete
    2. TundeApril 28, 2012 at 5:59 PM

      Thanks Madhav Vyas your tip was a big help.

      Delete
    3. AnonymousDecember 28, 2012 at 9:41 PM

      Thanks Madhav Vyas I was beginning to lose my hair on this one! thought I'd managed to corrupt data with a bad transaction. Thankfully not !

      Delete
  7. JustcallmeTomMay 17, 2012 at 8:27 PM

    Saved me a lot of hassle. Thank you!

    ReplyDelete
  8. MeetaMay 17, 2012 at 9:31 PM

    Anyone has a idea how to deal with the same error when its on sqlite n not mysql

    ReplyDelete
  9. AnonymousMay 22, 2012 at 1:37 PM

    Hola, dónde puedo encontrar el archivo max allowed packet? gracias

    ReplyDelete
  10. AnonymousJuly 20, 2012 at 12:36 PM

    thanks saved me a lot of time

    ReplyDelete
  11. UnknownAugust 11, 2012 at 11:38 AM

    How to do this on shared server and drupal

    ReplyDelete
    Replies
    1. Madhav VyasAugust 11, 2012 at 11:57 AM

      In drupal , you needs to add following link in your .htaccess file available in site root.

      php_value memory_limit 400M

      Delete
  12. simonAugust 15, 2012 at 4:16 PM

    max_allowed_packet=100M is excessif.. default is 1M so try with perhaps max_allowed_packet=12M first.

    ReplyDelete
  13. AnonymousAugust 17, 2012 at 10:06 AM

    I found the same Error in Yii: Above solution "change in my.ini
    max_allowed_packet=100M" didn't work.:(

    ReplyDelete
  14. محمد جمعهAugust 28, 2012 at 5:36 PM

    i got the same error with drupal 7 and did all the above but still the same error comes again

    i also doubled other values for cache and mysqldump but also nothing changed

    surely restarted mysql and restarted Ubuntu as well

    please help

    ReplyDelete
  15. lavidaenarmoniaSeptember 12, 2012 at 2:21 PM

    Madhav, thank you very much indeed!

    ReplyDelete
  16. Citlalli HerreraOctober 23, 2012 at 12:08 AM

    when i enabled rules ui, this appears the same problem SQLSTATE[HY000]: General error: 2006 MySQL server has gone away and i did it to increase the size, but itsnt working well i can´t get any content types and this appear the problem, help!

    ReplyDelete
    Replies
    1. Madhav VyasNovember 15, 2012 at 8:13 PM

      You may also need to increase the maximum packet size on the client, It will helps to overcome your error.

      Delete
    2. UnknownMay 24, 2014 at 1:24 PM

      Thanks

      Delete
  17. ClaudioJanuary 4, 2013 at 1:11 PM

    Thank you for sharing! Helped me to solve an issue just now!

    ReplyDelete
  18. UnknownMarch 30, 2013 at 1:02 PM

    there is no my.ini file. What can I do now?

    ReplyDelete
  19. random guyApril 21, 2013 at 12:29 PM

    I am on Fedora running xampp
    it's installed under lampp/htdocs/xampp

    i can't find my.ini

    whereis my.ini returned nothing.

    Ideas?

    ReplyDelete
  20. random guyApril 21, 2013 at 12:40 PM

    Ok I found under /lampp/etc/my.cnf
    in there there is a

    [mysqld]
    max_allowed_packet = 1M

    [mysqldump]
    quick
    max_allowed_packet = 16M



    I changed the first 1M to 16M , restarted lampp , mysql, everything and now everything is fine. Thanks!

    ReplyDelete
  21. AnonymousJuly 20, 2013 at 1:03 PM

    whoever you are, you are a life saver

    ReplyDelete
  22. AnonymousJuly 23, 2013 at 10:24 PM

    thanks Madhav Vyas!!!

    ReplyDelete
  23. AnonymousAugust 30, 2013 at 9:11 PM

    here is my error in mysql:

    PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {uc_product_classes}; Array ( ) in uc_product_class_load() (line 1515 of /www/vhtdocs/dev_twe_reseller/sites/all/modules/ubercart/uc_product/uc_product.module).

    I have chenged max_allowed_packet in my.cnf file. that also not working.
    am using linux os + drupal + mysql


    PLZ HELP ME.

    ReplyDelete
  24. AnonymousDecember 26, 2013 at 5:01 AM

    thumb up ... thx

    ReplyDelete
  25. AnonymousFebruary 13, 2014 at 3:04 AM

    Additional uncaught exception thrown while handling exception.
    Original

    PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT filename FROM {registry} WHERE name = :name AND type = :type; Array ( [:name] => views_plugin_display_default [:type] => interface ) in _registry_check_code() (line 3091 of /home/fada/public_html/mobaderoon/includes/bootstrap.inc).
    Additional

    PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT ff.* FROM {filter_format} ff WHERE (status = :db_condition_placeholder_0) ORDER BY weight ASC; Array ( [:db_condition_placeholder_0] => 1 ) in filter_formats() (line 427 of /home/fada/public_html/mobaderoon/modules/filter/filter.module).

    iam using shared hosting multisites .. one site is working and another not same core and different database

    what should i do ?

    ReplyDelete
  26. UnknownApril 2, 2014 at 5:15 PM

    Hi I'm using shared server... & CakePHP.... Can any body help me for this issue...

    ReplyDelete
  27. UnknownMay 10, 2014 at 11:16 PM

    i am suffering from same issue but only when i enter admin area please help me

    ReplyDelete
    Replies
    1. Madhav VyasMay 11, 2014 at 11:19 PM

      Can you elaborate your question please? Which admin area are you talking about?

      Delete
  28. AnonymousJune 10, 2014 at 3:30 PM

    thank you it 's working ! ! !

    ReplyDelete
  29. preetamgawadeFebruary 10, 2015 at 6:15 PM

    I am facing the same problem on my project running on bluehost servers. How can i chnage my.ini at server?

    ReplyDelete
  30. AnonymousApril 23, 2015 at 8:23 AM

    If the solution should change the parameters, so the concluding we can not work with Drupal on a free web hosting service.

    ReplyDelete
  31. MUNYEMANA GilbertMarch 4, 2016 at 8:39 PM

    Changing my.cnf worked for me . Thanks !

    ReplyDelete
  32. AnonymousFebruary 28, 2017 at 11:54 AM

    You're a life-saver. I was about to switch to Wordpress, but this gave me hope.

    ReplyDelete

Post a Comment