[Twisted-Python] 2006, 'MySQL server has gone away'

[Phil Christensen]

On Sep 20, 2007, at 7:39 AM, Werner Thie wrote:

> Hi all
>
> While using mySQL V 5.0.33 and MySQL-python-1.2.2 with twisted/ 
> adbapi with the following connection params
[snip snip snip]
> I noticed (2006, 'MySQL server has gone away') errors, which seem  
> to be not recoverable from an adbapi standpoint.
[snip snip snip]
> Questions:
> - are there any adverse effects in applying this patch and setting  
> reconnect: 1 in DB_ARGS?
>
> - is there a better, safer way to avoid this nasty error?
>
> Thxs, Werner

I believe this is what the 'cp_reconnect' keyword argument to the  
ConnectionPool constructor does.

I'm currently using this feature with MySQL 5 in a long-running  
webapp, with much success.

-phil