[Twisted-Python] "MySQL has gone away"
Hi all,
I'm using MySQL database in my server app. Pretty often after some inactivity I get this message in my logs "MySQL server has gone away". How can I prevent this?
TIA
Actually usually it means mysql server died. it's certainly not twisted question, but first of all you need to check mysql logs.
2007/7/26, Pavel Bastov pbastov@gmail.com:
Hi all,
I'm using MySQL database in my server app. Pretty often after some inactivity I get this message in my logs "MySQL server has gone away". How can I prevent this?
TIA
-- Good luck,
Pavel Bastov xooChat Evangelist and Team Leader http://www.xoochat.com/
Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
On 7/26/07, Aleksey Kishkin aleksey.kishkin@gmail.com wrote:
Actually usually it means mysql server died. it's certainly not twisted question, but first of all you need to check mysql logs.
No, it just means Mysql dropped your connection. By default, MySQL is configured to drop conncetions after a period of inactivity (600 seconds I think). Your client either needs to detect this condition and reconnect, or you can increase the timeout.
Arnar
May be. default wait_timeout 8 hours.
2007/7/26, Arnar Birgisson arnarbi@gmail.com:
On 7/26/07, Aleksey Kishkin aleksey.kishkin@gmail.com wrote:
Actually usually it means mysql server died. it's certainly not twisted question, but first of all you need to check mysql logs.
No, it just means Mysql dropped your connection. By default, MySQL is configured to drop conncetions after a period of inactivity (600 seconds I think). Your client either needs to detect this condition and reconnect, or you can increase the timeout.
Arnar
Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
On Jul 26, 2007, at 6:11 AM, Pavel Bastov wrote:
Hi all,
I'm using MySQL database in my server app. Pretty often after some inactivity I get this message in my logs "MySQL server has gone away". How can I prevent this?
TIA
I've seen this most frequently when I'm dealing with the MySQLdb module directly (i.e., not using twisted.adbapi).
It was happening to me when I was trying to use a single cursor throughout my code by passing it around as a property of some object.
I believe it has something to do with the weak references used internally in the MySQLdb module (this is just a theory).
My solution was to fetch a new cursor in each scope where I needed it, making sure to close it when I was done.
Just my 2/100ths....
-phil
2007/7/26, Pavel Bastov pbastov@gmail.com:
Hi all,
I'm using MySQL database in my server app. Pretty often after some inactivity I get this message in my logs "MySQL server has gone away". How can I prevent this?
TIA
U can use Mysql::Ping(dbh) to keep the connection alive.
----------- n = mysql::Ping(dbh)
Checks whether or not the connection to the server is working. If it has gone down, an automatic reconnection is attempted.
Clients that remain idle for a long while, to check whether or not the server has closed the connection and reconnect if necessary can use this function.
Returns true if the server is alive and false if an error occurred.
Have you tried cp_reconnect? It solved the problem for me.
dbPool = adbapi.ConnectionPool('MySQLdb', db='fee', user='fii', passwd='foo', host='fum', cp_reconnect=True)
Cheers, Einar
Pavel Bastov wrote:
Hi all,
I'm using MySQL database in my server app. Pretty often after some inactivity I get this message in my logs "MySQL server has gone away". How can I prevent this?
TIA
Hmm,
cp_reconnect seems like the proper solution. Thanks for pointing that out to me.
On 7/29/07, "Einar S. Idsø" einar.twisted@norsk-esport.no wrote:
Have you tried cp_reconnect? It solved the problem for me.
dbPool = adbapi.ConnectionPool('MySQLdb', db='fee', user='fii', passwd='foo', host='fum', cp_reconnect=True)
Cheers, Einar
Pavel Bastov wrote:
Hi all,
I'm using MySQL database in my server app. Pretty often after some inactivity I get this message in my logs "MySQL server has gone away". How can I prevent this?
TIA
Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
participants (6)
-
"Einar S. Idsø" -
Aleksey Kishkin -
Arnar Birgisson -
Pavel Bastov -
Phil Christensen -
马踏飞燕