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