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 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.
