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:
> (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 :)
GPG keys available @ http://rounoff.darktech.org