MySQL has gone away

[Josh Mellicker]

The same thing happens here, my plan was to write an error handler  
that resetAll and initiated a new fresh connection to the MySQL server.

In our case it is our new MySQL server that falls asleep every day or  
two and refuses to process requests for several seconds due to an  
unknown problem. (The old one was more reliable!)


On Mar 9, 2007, at 9:22 AM, TEKNE informatica & comunicazione wrote:

> I have tried with a ping in a 'send in time' script but I get the  
> same error
> after a few minutes.
> The mysql server is on my LAN; the server has also a WAN static IP.
> When I am connected from the LAN to the server local IP, I don't  
> get errors.
> But if I am connected to the server WAN IP, after a few minutes of
> inactivity, I get the error 'MySQL has gone away'
>
>
>
>> Da: Stephen Barncard <stephenREVOLUTION at barncard.com>
>> Risposta: How to use Revolution <use-revolution at lists.runrev.com>
>> Data: Thu, 8 Mar 2007 16:47:08 -0600
>> A: How to use Revolution <use-revolution at lists.runrev.com>
>> Oggetto: Re: MySQL has gone away
>>
>> this is more likely about the SQL server timeouts -- the server end,
>> not your end. Some ISPs put short timeouts on their servers.
>>
>> Even Dreamhost will drop after a few hours. I built a 'send in time'
>> routine to ping the server every 3600 seconds to keep it alive. It
>> basically calls itself forever until the app stops or it is told to
>> stop. Works great.
>>
>>
>>> 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 am connected to a remote server machine 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
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>>
>> -- 
>>
>>
>> stephen barncard
>> s a n  f r a n c i s c o
>> - - -  - - - - - - - - -
>>
>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your  
>> subscription
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution