Is the scheduled process doing a GET request to your application or is it a python application that imports your app models? In the second case you have to dispese the sqla sessions by yourself and changing the .ini of the app won't change a lot.
On Thu, Jul 14, 2011 at 10:08 AM, Rotem Tamir <[email protected]> wrote: > Alessandro, > > Thanks for the reply. > > I already have > > sqlalchemy.pool_recycle = 3600 > > in my development.ini.. > > Any other ideas? > > On Jul 13, 7:46 pm, Alessandro Molina <[email protected]> > wrote: >> Add a pool recycling option to the .ini configuration file. It is >> probably related to the fact that you are not correctly disposing the >> connections to the pool and so they keep stacking. Adding pool >> recycling should suffice to let sqlalchemy recycle old connections for >> you. >> >> >> >> >> >> >> >> On Wed, Jul 13, 2011 at 6:33 PM, Rotem Tamir <[email protected]> wrote: >> > I have a scheduled process updating db some data every second. >> >> > My app loads fine but after about 30 seconds I start getting this >> > weird error: >> > TimeoutError: QueuePool limit of size 5 overflow 10 reached, >> > connection timed out, timeout 30 >> > I tried flushing and closing my session in the function that's run but >> > that doesn't seem to help... >> >> > Any Clues? >> >> > Thanks in advance >> >> > Rotem >> >> > -- >> > You received this message because you are subscribed to the Google Groups >> > "TurboGears" 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 >> > athttp://groups.google.com/group/turbogears?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "TurboGears" 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/turbogears?hl=en. > > -- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
