Re: Closing SQLAlchemy session in SQLAlchemy + URL Dispatch Wiki Tutorial

2012-01-20 Thread Brian Brinegar
Thanks Michael, You were correct, the pyramid_tm was not listed as an includes in my configuration file. I appreciate your help, and I'll be sure to send future such queries to the -discuss group, Brian On Fri, Jan 20, 2012 at 10:22 AM, Michael Merickel wrote: > First of all, this should be po

Re: Closing SQLAlchemy session in SQLAlchemy + URL Dispatch Wiki Tutorial

2012-01-20 Thread Michael Merickel
First of all, this should be posted to pylons-discuss, not pylons-dev. The tutorial is configured to use the pyramid_tm package which is a transaction manager that effectively wraps the request in a transaction and will call session.close() on any sessions that were configured with extension=[Zope

Closing SQLAlchemy session in SQLAlchemy + URL Dispatch Wiki Tutorial

2012-01-20 Thread Brian
I'm running a simple Pyramid app using SQLAlchemy with a MySQL backend. Pool recycle is set to 3600. The application is similar to the SQLAlchemy + URL Dispatch Tutorial in the documentation. After some number of hours of running application I receive timeout errors indicating that the QueuePool