HI all
* Warning*: Got a packet bigger than 'max_allowed_packet' bytes 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:1539805:"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_update SET data = 'a:69:{s:10:\"background\";a:25:{s:4:\"name\";s:10:\"background\";s:4:\"info\";a:5:{s:4:\"name\";s:10:\"Background\";s:7:\"version\";s:11:\"6.x-1.x-dev\";s:7:\"project\";s:10:\"background\";s:9:\"datestamp\";s:10:\"1298618869\";s:16:\"_info_file_ctime\";i:1329232033;}s:
Could you please give me solution.
Regards Selvaraj.C
On Mon, Feb 27, 2012 at 7:27 AM, Selvaraj Chnnasamy wrote:
HI all
Warning: Got a packet bigger than 'max_allowed_packet' bytes 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:1539805:"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_update SET data = 'a:69:{s:10:\"background\";a:25:{s:4:\"name\";s:10:\"background\";s:4:\"info\";a:5:{s:4:\"name\";s:10:\"Background\";s:7:\"version\";s:11:\"6.x-1.x-dev\";s:7:\"project\";s:10:\"background\";s:9:\"datestamp\";s:10:\"1298618869\";s:16:\"_info_file_ctime\";i:1329232033;}s:
Could you please give me solution.
The error message tells all. You need to increase the max_allowed_packet size in the MySQL configuration file.
Hi,
Also from what I can see Drupal is trying to do, I think that you have too many modules on your system. I can't remember exactly but I think that the update status checks both enabled and disabled modules which is why it is blowing through your max packet size.
Another thing that you could try is to not use mysql for your caching and use something like memcache which will be much faster, and not have this limit to store cached information.
Gordon.
On 28/02/2012, at 12:56 AM, Earnie Boyd wrote:
On Mon, Feb 27, 2012 at 7:27 AM, Selvaraj Chnnasamy wrote:
HI all
Warning: Got a packet bigger than 'max_allowed_packet' bytes 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:1539805:"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_update SET data = 'a:69:{s:10:\"background\";a:25:{s:4:\"name\";s:10:\"background\";s:4:\"info\";a:5:{s:4:\"name\";s:10:\"Background\";s:7:\"version\";s:11:\"6.x-1.x-dev\";s:7:\"project\";s:10:\"background\";s:9:\"datestamp\";s:10:\"1298618869\";s:16:\"_info_file_ctime\";i:1329232033;}s:
Could you please give me solution.
The error message tells all. You need to increase the max_allowed_packet size in the MySQL configuration file.
-- Earnie
-- https://sites.google.com/site/earnieboyd
[ Drupal support list | http://lists.drupal.org/ ]