openannotation / annotateit

The web application running AnnotateIt
http://annotateit.org
Other
27 stars 11 forks source link

Application leaks DB connections #14

Closed nickstenning closed 10 years ago

nickstenning commented 11 years ago

Over time, the application leaks connections to the database, resulting in OperationalError: (OperationalError) FATAL: too many connections for role "foobarbaz" from Heroku postgres. This results in complete outage of the site, leading to frustration among users (and operators!).

nickstenning commented 10 years ago

We fixed this in the end. sqlalchemy was running in DEBUG mode.