Random “Lost connection to MySQL server at 'reading initial communication packet', system error: 0”
Posted
by
user1606545
on Server Fault
See other posts from Server Fault
or by user1606545
Published on 2012-08-17T15:47:56Z
Indexed on
2012/09/25
15:39 UTC
Read the original article
Hit count: 225
networking
|mysql
Sometimes I get the error from MYSQL server:
Lost connection to MySQL server at 'reading initial communication packet', system error: 0
I cannot find the cause, since most of the time it works, but every week for some hours I get this error. I googled, but there seem to be only users which have this error permanently. But in this case, it only occurs sometimes. I checked hosts.allow and hosts.deny, but the host is allowed and not denied.
Also sometimes I get the error:
File './database/table.MYD' not found (Errcode: 24)
It occurs very rarely. But it occurs for some hours once a week, sometimes on multiple days, but suddenly the problem disappears again. I have checked the open files limit. It's 2048 and should be absolutely enough. I also tried to increase the number of open files nevertheless, but no effect. I thought, perhaps the process does not close some tables. But this is impossible, because after a while everythings o.k. again and the process opens maximum 100 tables at once. I also checked the MySQL-runtime-environment, and there were 930 opened files. I cannot explain that. After a while it's 129.
I am running a MySQL-Server on a SUSE-Linux machine. I connect to the MySQL-Server from another host by the command line tool "mysql" and by MySQL-C-connector. The MySQL-Server is version 5.0.67.
© Server Fault or respective owner