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 <[EMAIL PROTECTED]>
Risposta: How to use Revolution <use-revolution@lists.runrev.com>
Data: Thu, 8 Mar 2007 16:47:08 -0600
A: How to use Revolution <use-revolution@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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
