[Twisted-Python] "MySQL has gone away"

[Phil Christensen]

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