You need to make sure that you are closing your sessions--otherwise, they keep your connections open, and are never returned to the pool. Make sure to read up on sessions here: http://www.sqlalchemy.org/docs/05/session.html
Also, read up on logging: http://www.sqlalchemy.org/docs/05/dbengine.html#configuring-logging It's nice to be able to log your pool status at some points, so that you can see how many connections are open. -Jeff On May 22, 4:41 am, Marcin Krol <[email protected]> wrote: > Hello everyone, > > After some time of operation (a day or so), from time to time I'm > getting this error: > > TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection > timed out, timeout 30 > > I have to stress that not much activity is taking place on that OS as it > is development installation. > > Does anybody know what could be causing this? > > Restarting apache or postgres eliminates that problem, but then it > reappears. > > I'm getting sick of this. Does anybody know what could be the root > cause? How to fix this? > > My app uses mod_python / SQLA 5.3. > > The backend is Postgres 8.1 on RH 5.3. > > Regards, > mk --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
