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.
