Skip navigation links

MySQL Forums :: PHP :: Intermittent connect errors


Advanced Search

Intermittent connect errors
Posted by: Stefan Linden ()
Date: February 28, 2012 03:25PM

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.

Options: ReplyQuote


Subject Written By Posted
Intermittent connect errors Stefan Linden 02/28/2012 03:25PM
Re: Intermittent connect errors Stefan Linden 02/28/2012 09:23AM
Re: Intermittent connect errors Stefan Linden 02/28/2012 03:33PM
Re: Intermittent connect errors Rick James 03/01/2012 08:24PM
Re: Intermittent connect errors Stefan Linden 03/04/2012 03:16AM
Re: Intermittent connect errors Rick James 03/06/2012 12:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.