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

2008-07-11 Thread Michael Bayer
On Jul 11, 2008, at 9:23 AM, Ryan Parrish wrote: 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

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

2008-07-11 Thread Ryan Parrish
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

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

2008-07-11 Thread Michael Bayer
On Jul 11, 2008, at 10:45 AM, Ryan Parrish wrote: 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,