MySQL server has gone away, issue on drupal, drupal ecommerce kickstart gives me alot of headache since I do not first aware that the issue because of there are so many packets execution on mysql with drupal.

The full error is (or similar):

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_handler_field_node [:type] => interface ) in _registry_check_code() (line 3108 of d:\commerce_kickstart-7.x-2.9\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 d:\commerce_kickstart-7.x-2.9\modules\filter\filter.module).

I am using XAMPP, on Windows 7 64bits:

  • MySQL 5.6.14

Solutions

I have searched around and found following solution is working for me:

To change “max_allowed_packet” from “1m” to “16m” or “32m

  • Go to xampp\mysql\bin
  • Open my.ini
  • Change “max_allowed_packet” from “1m” to “16m”
  • Save my.ini
  • Now restart MySql through the XAMPP control panel.

The same solution if other application faces the error of MySQL has gone away above.


Ref: https://drupal.org/node/984112