Fatal error adding new context after fresh install. [#1413276]

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array ( ) in system_list() (line 165 of C:\xampp\htdocs\lilsoak\includes\module.inc).

Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT t__0.* FROM {panels_layout} t__0 WHERE (plugin = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => flexible ) in ctools_export_load_object() (line 427 of C:\xampp\htdocs\lilsoak\sites\all\modules\ctools\includes\export.inc).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 206 of C:\xampp\htdocs\lilsoak\includes\session.inc).

(Also get the same error on 7.x-3.x-beta2

Comments

Comment #1

Palantar CreditAttribution: Palantar commented 22 January 2012 at 17:20

Just as a couple extra notes:

This is an otherwise perfectly working install of drupal. Omega works fine, nodes work fine, etc etc. No other Database problems
Let me know what other info you need to help debug it

Comment #2

Palantar CreditAttribution: Palantar commented 22 January 2012 at 21:49

Debugger seems to indicate it is coming from :

$menus = menu_parent_options(menu_get_menus(), array('mlid' => 0));

in context_condition_menu.inc

Comment #3

Palantar CreditAttribution: Palantar commented 22 January 2012 at 22:06

Alrighty, after at least 4 million google searches, this turns out to be fixed by setting the mysql my.ini packet size to much larger. I went from 1 MB to 16MB and it now works.

Comment #4

Palantar CreditAttribution: Palantar commented 22 January 2012 at 22:47

Status:

Active

» Closed (cannot reproduce)

Comment #5

OldAccount CreditAttribution: OldAccount commented 6 December 2012 at 19:12

Thanks for this tip @Palantar! I just switched my local dev environment from MAMP to Mountain Lion's built in Apache with a local install of MySQL. I started getting this error whenever I tried loading any of my Contexts. Changing max_allowed_packet from 1MB to 16MB did the trick.

For anyone else that comes across this issue, be aware there are 2 instances of max_allowed_packet in the .cnf file, if you don't see your changes show up after restarting MySQL make sure you're not changing the mysqldump one. And if you're also using MySQL locally on a Mac, here's some helpful information on changing the config variables:
http://www.coolestguyplanettech.com/optimising-mysql-on-os-x-10-7-lion-w...