MySQL has gone away

riccardo · Post by **riccardo** » Thu Mar 08, 2007 6:48 pm

Do you know if there is a relationship between the socket timeout and the connection to a MySQL server with the revOpenDatabase function?
When I stay connect from a remote machine to the server and I don't send a query for more than 5 minutes, I obtain the error "MySQL has gone away".
PS
I have tuned the server system variables in order to have a good connection (wait_timeout, max_allowad_packets, etc.).
If I make the connection from the LAN I don't have this error!

Thank you for your suggestions.

Riccardo

riccardo · Post by **riccardo** » Tue Mar 13, 2007 8:53 am

I have made same tests and I have got the following results:
-the error doesn't depend by the socket timeout;
-the error doesn't depend by the server OS (I have tried with windows server 2003 and MacOS X);
-the error doesn't depend by the client OS (I have tried with windows XP and MacOS X);
-I get the error only when I am connected with MySQL over the WAN
-the error doesn't depend by the connection timeout (I always get the error even if I send a ping every 120 seconds)

Perhaps the error depends bythe revolution client driver or ...

In order to don't get the error I use a 'send in time' handler where I send a query every 120 seconds.

Hope this helps.
Riccardo