[support] watch dog module issue

Mon Feb 27 22:23:57 UTC 2012

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
>> &#039;max_allowed_packet&#039; bytes\nquery: UPDATE cache_update SET data =
>> &#039;a:69:{s:10:\\&quot;background\\&quot;;a:25:{s:4:\\&quot;name\\&quot;;s:10:\\&quot;background\\&quot;;s:4:\\&quot;info\\&quot;;a:5:{s:4:\\&quot;name\\&quot;;s:10:\\&quot;Background\\&quot;;s:7:\\&quot;version\\&quot;;s:11:\\&quot;6.x-1.x-dev\\&quot;;s:7:\\&quot;project\\&quot;;s:10:\\&quot;background\\&quot;;s:9:\\&quot;datestamp\\&quot;;s:10:\\&quot;1298618869\\&quot;;s:16:\\&quot;_info_file_ctime\\&quot;;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/ ]