MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mathieu Bruneau Date:May 10 2007 2:07am
Subject:Re: Mysterious 'Lost connection' errors
View as plain text  
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
Thread
Mysterious 'Lost connection' errorsJon Ribbens9 May
  • Re: Mysterious 'Lost connection' errorsMichael Dykman9 May
    • Re: Mysterious 'Lost connection' errorsJon Ribbens9 May
      • Re: Mysterious 'Lost connection' errorsMichael Dykman9 May
        • Re: Mysterious 'Lost connection' errorsmos9 May
        • Re: Mysterious 'Lost connection' errorsJon Ribbens9 May
  • Re: Mysterious 'Lost connection' errorsMathieu Bruneau10 May
    • Re: Mysterious 'Lost connection' errorsJon Ribbens10 May
      • Re: Mysterious 'Lost connection' errorsJon Ribbens10 May
        • Re: Mysterious 'Lost connection' errorsmos10 May
          • Re: Mysterious 'Lost connection' errorsJon Ribbens10 May
            • Re: Mysterious 'Lost connection' errorsJon Ribbens11 May