[sqlalchemy] Can't reconnect until invalid transaction is rolled back after application sits idle overnight.

Using SQLAlchemy 0.4.4 I am having a problem with SQLAlchemy where after the application that uses SQLAlchemy has been sitting overnight and a user makes the first queries of the day thru the app that uses SA, SQLAlchemy throws an error saying 'MySQL server has gone away', which I understand the

[sqlalchemy] Re: Can't reconnect until invalid transaction is rolled back after application sits idle overnight.

On Jul 11, 10:03 am, Michael Bayer [EMAIL PROTECTED] wrote:. The reason you're getting the disconnect exception in the first place   is because the pool_recycle feature only works upon checkout from the   pool.  So the solution is the same, ensure all connections are   returned to the pool