CODEWITHSUNDEEP
mysql
James Read
James Read

Reputation: 459

Rare reasons for MySQL server has gone away error

I have checked the answers at MySQL error 2006: mysql server has gone away None of them seem to fit my problem.

I am getting the error MySQL server has gone away frequently.

It is not the connection timeout. The default timeout of 8 hours seems plenty.

I have tried upping the max_allowed_packet to no avail. This then seemed irrelevant when I began printing out the offending SQL statement which was in my case: SELECT url FROM crawled WHERE frontier = 1 ORDER BY id. Hardly a large statement which warrants upping max_allowed_packet.

So, none of the given answers seem to fit my scenario. Any other reasons why this error may occur? Any possible fixes?

Upvotes: 2

Views: 5324

Answers (1)

Gordan Bobić
Gordan Bobić

Reputation: 1858

Two common possibilities come to mind:

1) Out Of Memory error. Check syslog for evidence of it.

2) Bug or some other crash in mysqld thread. Check your MySQL error log.

The "server has gone away" almost always means a back end thread crash. And that should leave something obvious in the logs.

Upvotes: 1

Related Questions