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

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