Intermittent connect errors

[Stefan Linden]

Hi

We are experiencing some annoying intermittent connect errors from MySQL using PHP. We have about 300 databases running and some of them seem to have connect errors now and then. I have a script connecting every minute to one MySQL-server and I have this in the log from my script:

MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-10 10:10:02
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-10 10:21:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-10 10:38:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-11 01:29:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-15 08:21:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-17 03:43:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-17 03:50:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-18 09:18:03
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-18 12:47:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-18 20:58:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-19 21:20:03
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-20 18:14:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-21 00:04:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-21 03:14:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-21 09:56:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-21 09:57:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-21 11:21:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-21 14:31:03
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-22 19:31:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-23 09:34:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-23 23:19:02
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-26 22:34:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-28 15:51:00
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-28 17:00:01
MySQL error 2003: Can't connect to MySQL server on 'one.of.our.servers' (126) ::2012-02-28 22:28:00


126 would point to a corrupted index on a MyISAM-table as far as I know. But why would that cause a connect error? Unless a failed connect actually does not update the last mysql error and therefore mysql_error just reports the last mysql error from an otherwise successful connect and thus the error has nothing to do with the mysql_connect.

Anyway, these connect errors are really a problem that I need to solve A.S.A.P.

Have anyone seen this before? I have tried to search the forums but the only similar problems I have seen is people who have the problems all the time. We only see it a few times per day.