Jon Ribbens a écrit : > We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4, > and the MySQL-python-1.2.1_p2 connector. > > We are getting intermittent mysterious errors as follows: > > OperationalError: > (2013, 'Lost connection to MySQL server during query') > > when attempting to connect to the MySQL server (note: on the actual > connection attempt, this is before even trying a query). There doesn't > appear to be any particular pattern to when these errors occur. > > The client and server are on different machines, communicating via > TCP, but I have not managed to find any networking problems. > > Does anyone have any suggestions as to what the problem might be, or > how we might go about trying to solve it? >
We found a similar issue because we were using persistent connection in php and had a firewall between the mysql and the webserver. The problem is that our persistent connection were setup for lasting up to something like 8 hours but the firewall was keeping state of the connection only for up to 1 hour when no data was transferred. After the firewall had flushed the state of the connection and that the webserver were trying to communicate through it, he was reporting "Lost connection to mysql server during query" We adjust the setting of the persistent connection to 45 mins and the problem went away. This don't have anything to do with the version, but that was with 4.1 :) -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
