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, &#039;akismet&#039;, &#039;Spambot detected (action: 503 Service unavailable).&lt;p&gt;Additional information:&lt;/p&gt;&lt;div class=\\&quot;item-list\\&quot;&gt;&lt;ul&gt;&lt;li&gt;&lt;strong&gt;SQL&lt;/strong&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;#039;node&amp;#039; AND s.content_id = n.nid WHERE (s.hostname = &amp;#039;69.116.65.xx&amp;#039; OR r.body = &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(&#039;Submit Forum topic&#039;, &#039;node/add/forum&#039;, &#039;http://www.example.org/?q=node/add/forum&#039;, &#039;68.116.65.94&#039;, 24, &#039;ea4090056955f39a0701f38f10d092b4&#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 = &#039;ea4090056955f39a0701f38f10d092b4&#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 (&#039;ea4090056955f39a0701f38f10d092b4&#039;, 24, 0, &#039;69.116.65.xx&#039;, &#039;messages|a:1:{s:5:\\&quot;error\\&quot;;a:2:{i:0;s:1433:\\&quot;user warning: 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&am in /home/useraccnt/public_html/drupaldir/includes/database.mysql.inc on line 172I 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
Comment #1
avpadernoI am closing this issue, since it's for a Drupal version not supported.