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 <mmeri...@gmail.com> wrote: > 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=[ZopeTransactionExtension()]. It sounds to me like you removed the > tm package, or your session is not configured to use the extension. > > > On Fri, Jan 20, 2012 at 9:16 AM, Brian <brian.brine...@gmail.com> wrote: >> >> 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 limit has been exceeded. >> >> Running the pool log at debug level I could see that the sessions were >> not returned to the pool. >> >> Explicitly calling session.close() on the DBsession instance before >> returning fixed the problem. >> >> Should it be necessary to explicitly close the session and if so can >> the session.close() calls be added to the tutorial documentation? >> >> Thanks, >> >> Brian Brinegar >> >> -- >> You received this message because you are subscribed to the Google Groups >> "pylons-devel" group. >> To post to this group, send email to pylons-devel@googlegroups.com. >> To unsubscribe from this group, send email to >> pylons-devel+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/pylons-devel?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "pylons-devel" group. > To post to this group, send email to pylons-devel@googlegroups.com. > To unsubscribe from this group, send email to > pylons-devel+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/pylons-devel?hl=en. -- You received this message because you are subscribed to the Google Groups "pylons-devel" group. To post to this group, send email to pylons-devel@googlegroups.com. To unsubscribe from this group, send email to pylons-devel+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/pylons-devel?hl=en.
