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.
