"Warning: MySQL server has gone away query: INSERT INTO watchdog" problem

Submitted by concheng on Fri, 06/05/2009 - 10:30
Status: 
Open
Question: 

I run into this following problem after I install activity and og module...

"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:1566570:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_menu SET data = 'a:980:{s:13:\\"adsense_click\\";a:26:{s:13:\\"page callback\\";s:22:\\"adsense_click_register\\";s:4:\\"type\\";i:4;s:15:\\"access callback\\";i:1;s:6:\\"module\\";s:13:\\"adsense_click\\";s:14:\\"load_functions\\";s:0:\\"\\";s:16:\\"to_arg_functions\\";s:0:\\"\\";s:5:\\"title\\";s:0:\\"\\";s:6:\\"weight\\";i:0;s in C:\Downloads\drupal\includes\database.mysqli.inc on line 128
"
now, every time I went into http://localhost/admin/build/modules, the error show along with this "user warning: Got a packet bigger than 'max_allowed_packet' bytes query:........"<---this go on like hundred pages

I have no idea how to do to solve this problem...I google search on web...and tried every solution I could find...including increasing both max_allowed_packet and memory_limit to 512M and 256M respectively....so I don't think I ran out of memory....so please help...I stuck on this problem for three day....O.O thank you

p.s my system is window xp sp2 with 2GB of memory.....I try to build a social network site....so I really need activity and og module...

Related Questions

Back to all questions

Ask a new question!

Responses

1. This can have something to do

Submitted by dorien on Sat, 06/06/2009 - 09:23.

This can have something to do with you server capacity. Check with your host.

Also try to disable the automatic "update" module.

2. I did disable update module already.....

Submitted by concheng on Sat, 06/06/2009 - 10:38.

I didn't host my server to any provider.....I installed drupal on my computer for testing....I have windows run on 2g of ram and amd xp 3200 system....I did set my max_allowed_packet and memory_limit to 512M and 256M respectively...I don't know what else I can do....did it have something to do with double quote inside double quote that window system may handle differently from Unix based system?

3. I don't have any experience

Submitted by dorien on Sat, 06/06/2009 - 12:08.

I don't have any experience with Windows, so I can't help you a lot with that. You might be more successful at the drupal or mysql forum.

4. same here

Submitted by xdemianx on Tue, 06/23/2009 - 16:07.

i have the same issue on my site but its a host side issue, they limited theyr Mysql query timeout so whenever a query takes more than 15 seconds to be resolved it resets the connection between mysql and drupal so for me i cant do anything about just wait a couple of months and get a better hosting. anyway you can always disable the update module by mysql or phpmyadmin at the system table.

5. I had the same problem but could fix it

Submitted by alfriend on Fri, 03/26/2010 - 07:57.

Try to clear cache using the script below

<?php
include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
drupal_flush_all_caches();
?>

Just place the script (which in my case I named it clearcache.php) in the site's root and either run it from command line using "php clearcache.php" or at your browser http://yoursite.com/clearcache.php
The reinstall the og module.

Remember to remove it or else someone might just get an ikling that you might have a clearcache script aptly name and cause performance havoc with your site.

If clearing the cache still don't work, try the update.php script to update any of your previous module upgrade.

6. MySQL server has gone away query: INSERT INTO watchdog

Submitted by dawnieando on Tue, 11/16/2010 - 11:19.

Were token starter and token actions enabled?

This occurred for me when I enabled token starter and token actions. I disabled them and it went away.