PHP Warning: MySQL server has gone awayService unavailable
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (24, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (24, &amp;#039;akismet&amp;#039;, &amp;#039;Spambot detected (action: 503 Service unavailable).&amp;lt;p&amp;gt;Additional information:&amp;lt;/p&amp;gt;&amp;lt;div class=\\&amp;quot;item-list\\&amp;quot;&amp;gt;&amp;lt;ul&amp;gt;&amp;lt;li&amp;gt;&amp;lt;strong&amp;gt;SQL&amp;lt;/strong&amp;gt;: SELECT 1 FROM node n INNER JOIN node_revisions r ON r.nid = n.nid INNER JOIN akismet_spam_marks s ON s.content_type = &amp;amp;#039;node&amp;amp;#039; AND s.content_id = n.nid WHERE (s.hostname = &amp;amp;#039;69.116.65.xx&amp;amp;#039; OR r.body = &amp;amp;#039;loading up mySQL queries to the point of crash, la in /home/useraccnt/public_html/drupaldir/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 (24, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&amp;#039;Submit Forum topic&amp;#039;, &amp;#039;node/add/forum&amp;#039;, &amp;#039;http://www.example.org/?q=node/add/forum&amp;#039;, &amp;#039;68.116.65.94&amp;#039;, 24, &amp;#039;ea4090056955f39a0701f38f10d092b4&amp;#039;, 64604, 1202346601)</em> in <em>/home/useraccnt/public_html/drupaldir/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.example.org/?q=node/add/forum', 'http://www.example.org/?q=node/add/forum', '69.116.65.xx', 1202346601) in /home/useraccnt/public_html/drupaldir/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 (24, 'php', '<em>MySQL server has gone away\nquery: SELECT sid FROM sessions WHERE sid = &amp;#039;ea4090056955f39a0701f38f10d092b4&amp;#039;</em> in <em>/home/useraccnt/public_html/drupaldir/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.example.org/?q=node/add/forum', 'http://www.example.org/?q=node/add/forum', '69.116.65.xx', 1202346601) in /home/useraccnt/public_html/drupaldir/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 (24, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;ea4090056955f39a0701f38f10d092b4&amp;#039;, 24, 0, &amp;#039;69.116.65.xx&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:1433:\\&amp;quot;user warning: MySQL server has gone away\\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (24, &amp;amp;#039;akismet&amp;amp;#039;, &amp;amp;#039;Spambot detected (action: 503 Service unavailable).&amp;amp;lt;p&amp;amp;gt;Additional information:&amp;amp;lt;/p&amp;amp;gt;&amp;amp;lt;div class=\\\\&amp;amp;quot;item-list\\\\&amp;amp;quot;&amp;amp;gt;&amp;amp;lt;ul&amp;amp;gt;&amp;amp;lt;li&amp;am in /home/useraccnt/public_html/drupaldir/includes/database.mysql.inc on line 172

I removed my specific path, domain name and IP address in the above error messages for privacy purposes.

I've checked extensively and these errors are generated by the Akismet module, but only on a regular registered user, the admin account can post. Yet changing permissions on askimet checking per role had no effect (bypass for registered user). Only disabling the module worked to stop the above errors when they went to submit/preview a post of type blog, forum.

My API key is valid and this also just started happening, but there is nothing about Akismet being down and it seems to be with the mySQL inserts that are going nuts.

Maybe this should be a support request but from what I could find it seems to just plain be crashing and sending massive large mySQL inserts.

Comments

avpaderno’s picture

Version: 5.x-1.3 » 5.x-1.x-dev
Status: Active » Closed (outdated)

I am closing this issue, since it's for a Drupal version not supported.