Everything was fine a few days ago but now when I try go go to most admin pages and update.php I get a massive amount of MySQL server has gone away warnings.

Here is the first of many, one for each installed module it looks like...

* user warning: MySQL server has gone away query: SELECT filename, name, type, status, throttle, schema_version FROM system WHERE type = 'module' in /myMultiSitePath/drupal6/modules/system/system.module on line 752.
* user warning: MySQL server has gone away query: INSERT INTO system (name, info, type, filename, status, throttle, bootstrap) VALUES ('admin_menu', 'a:10:{s:4:\"name\";s:19:\"Administration menu\";s:11:\"description\";s:123:\"Provides a dropdown menu to most administrative tasks and other common destinations (to users with the proper

My multi site setup:

Drupal 6.19
MySQL database 5.1.26
PHP 5.2.14
PHP memory limit 160M

Added to php.ini to try and rectify MySQL server connection problems:
max_allowed_packet = 200M
mysql.connect_timeout = 120
zend_extension="/usr/local/php-5.2.14-1/zend/ZendOptimizer.so"
max_execution_time = 0

Modules set to status "0" as per suggestions in the many posts that I have read over the past few days:

Lightbox2, Update, dblog & syslog.

Any ideas would be greatly appreciated,

Ralph

Comments

damien tournoud’s picture

damien tournoud commented
Category: bug » support

> max_execution_time = 0

Don't do that, it's a bad idea.

> mysql.connect_timeout = 120

This sounds like a bad idea too, this timeout should be short.

Your actual problem is that the MySQL *server* timeouts the connection when it has not received queries for some time. This setting (wait_timeout, in the MySQL server configuration) is set too low in your case. Set it to something more reasonable.

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysv...

Infinitee’s picture

Infinitee commented

Thanks for the reply,

I changed settings as per your suggestions and added some from another post...

max_execution_time = 400
memory_limit = 100M
max_allowed_packet = 200M
mysql.connect_timeout = 60
wait_timeout = 80000

port = 3306
skip-locking
key_buffer = 384M
table_cache = 4096
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M

innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 10M
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 180

Also, added:
mysqli.reconnect = On

After repeated reloading of admin pages I was finally able to get them to load but, I still can't run update.php.
I even tried setting all third party modules to "0" but, that did not work either.

Infinitee’s picture

Infinitee commented

Well I went to where I could use a faster connection and was able to run update.php (with errors on page) and just get the WSOD.

Any ideas out there?

dpearcefl’s picture

dpearcefl commented
Component: update system » update.module
Assigned: Infinitee » Unassigned
Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Do you still need help?

dpearcefl’s picture

dpearcefl commented
Status: Postponed (maintainer needs more info) » Active
dddave’s picture

dddave commented
Status: Active » Fixed

Obviously...

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.