Update Notifications causes SQL Server to go away
| Project: | Drupal |
| Version: | 6.x-dev |
| Component: | update.module |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
In two installations of Drupal I have been forced to disable Update Notifications because with that module enabled, my site fails with a series of "MySQL server has gone away" errors. I initially installed 6.6 and it worked fine -- but upgrading to 6.8 caused the problem and it was repeated on a new clean install on another site. I've also upgraded one site to 6.9 and have the same problem. Below are a few of the error messages:
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:86896:\"MySQL server has gone away\nquery: UPDATE cache_update SET data = 'a:13:{s:14:\\"advanced_forum\\";a:10:{s:5:\\"title\\";s:14:\\"Advanced Forum\\";s:10:\\"short_name\\";s:14:\\"advanced_forum\\";s:10:\\"dc:creator\\";s:8:\\"Michelle\\";s:11:\\"api_version\\";s:3:\\"6.x\\";s:17:\\"recommended_major\\";s:1:\\"1\\";s:16:\\"supported_majors\\";s:1:\\"1\\";s:13:\\"default_major\\";s:1:\\"1\\";s:14:\\&quo in /data/17/1/84/125/1736451/user/1875408/htdocs/includes/database.mysqli.inc on line 128
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:130:\"MySQL server has gone away\nquery: UPDATE variable SET value = 'i:1232467900;' WHERE name = 'update_last_check'\";s:5:\"%file\";s:68:\"/data/17/1/84/125/1736451/user/1875408/htdocs/includes/bootstrap.inc\";s:5:\"%line\";i:509;}', 3, '', 'http://www.misite.com/admin/build/modules', 'http://www.mysite.com/admin/build/modules', '209.12.238.114', 1232467900) in /data/17/1/84/125/1736451/user/1875408/htdocs/includes/database.mysqli.inc on line 128
If it matters, I'm running on a Network Solutions hosting package.
#1
Same problem for me. I cannot change the MYSQL config to try some tweaks, but in the last days, my site's admin pages became completely unavailable because I always had the "Warning: MySQL server has gone away query..." error page.
I disabled the "update status" module using phpmyadmin to alter the database, and the problem immediately disappeared. I think there is a problem in the way update status works...
Using latest 6.12 Drupal
#2
I'm guessing this is caused by having a very large # of contributed modules enabled on your site, which causes the serialized array of available update data to be so huge that it overflows some mysql limits to the site of a record in a DB table, etc.
Probably the solution here is to split up the cached data so that we store available release data for each project in its own cache entry, instead of putting all of them into a single array and caching that in 1 record. This is related to some of the discussion in #238950: Reduce RAM resource consumption, as well...