Home » Forums » Support » Post installation

Warning: MySQL server has gone away query. A "watchdog" Issue. WHAT IS THIS??!

·
Rosamunda - March 2, 2008 - 19:09

What´s this error?
It appears randomly...!

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: LOCK TABLES cache_page WRITE</em> en la línea <em>172</em> del archivo <em>/home/planetac/public_html/includes/database.mysql.inc</em>.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em></em> en la línea <em>172</em> del archivo <em>/home/planetac/public_html/includes/database.mysql.inc</em>.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: UNLOCK TABLES</em> en la línea <em>172</em> del archivo <em>/home/planetac/public_html/includes/database.mysql.inc</em>.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&amp;#039;&amp;#039;, &amp;#039;node&amp;#039;, &amp;#039;http://www.planetaconsorcio.com/user/76/edit&amp;#039;, &amp;#039;200.122.115.187&amp;#039;, 0, &amp;#039;aea730725310fbdd67b9355d86ed6513&amp;#039;, 43293, 1204484718)</em> en la línea <em>172</em> del archivo <em>/home/planetac/public_html/includes/database.mysql.inc</em>.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: SELECT sid FROM sessions WHERE sid = &amp;#039;aea730725310fbdd67b9355d86ed6513&amp;#039;</em> en la línea <em>172</em> del archivo <em>/home/planetac/public_html/includes/database.mysql.inc</em>.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;aea730725310fbdd67b9355d86ed6513&amp;#039;, 0, 0, &amp;#039;200.122.115.187&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:4:{i:0;s:147:\\&amp;quot;user warning: MySQL server has gone away\\nquery: LOCK TABLES cache_page WRITE in /home/planetac/public_html/includes/database.mysql.inc on line 172.\\&amp;quot;;i:1;s:85:\\&amp;quot;user warning: in /home/planetac/public_html/includes/database.mysql.inc on line 172.\\&amp;quot;;i:2;s:132:\\&amp;quot;user warning: MySQL server has gone away\\nquery: UNLOCK TABLES in /home/planetac/public_html/includes/database.mysql.inc on line 172.\\&amp;quot;;i:3;s:391:\\&amp;quot;user warning: MySQL server in /home/planetac/public_html/includes/database.mysql.inc on line 172

I would really, really, really appreciate any help.
Thanks!!!
Rosamunda

» Login or register to post comments

MySQL Server Issue

vinayras - March 2, 2008 - 19:14

Hi,

This is MySQL server issue. Talk to you host - he will get it sorted.

This problem usually occurs when MySQL is not able to respond to requests - either mysql is dead or too busy

Vinay Yadav
PHP / Drupal Developer
http://www.vinayras.com

www.eDrupal.com - Indian Drupal Community

Login or register to post comments

fix on shared hosting

g76 - May 6, 2008 - 10:37

this worked for me. I am on a shared hosting account, no access to mysql settings(max_allowed_packet or timeout settings), but this seemed to fix it:

http://drupal.org/node/227445#comment-770663

also, disable syslog and database logging.
gideon

Login or register to post comments

THANKS!!!

Rosamunda - May 6, 2008 - 14:42

Yeap, it solved the issue for me too.

Rosamunda
Buenos Aires | Argentina
www.ligadelconsorcista.org

Login or register to post comments

So I guess the easy solution

darumaki - January 26, 2009 - 23:18

So I guess the easy solution would be just to disable everything, including drupal, that will fix it all right (sarcasm). Shouldn't database logging be enabled how else will you know about the errors.

>>>>>>>>>>>>>>>>>>>>>>>
contemplating the meaning of existence, what else would I be doing

Login or register to post comments

See also :

abramo - May 17, 2008 - 13:32

MySql : "Warning: MySQL server has gone away" - Tune MySql to resolve this problem

Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.