For what it's worth I forgot to mention I'm using pyramid_tm 0.3 as well.
On Wed, Mar 21, 2012 at 4:08 PM, Jacob Hite <[email protected]> wrote: > > Hi all, > > I've built a webapp using pyramid and sqlalchemy. I also hooked up beaker > to help with session data. I've started seeing SQLAlchemy errors like this: > > TimeoutError: QueuePool limit of size 5 overflow 10 reached, connection > timed out, timeout 30 > > > I started logging sqlalchemy information and see things like this: > > 2012-03-21 15:56:44,805 DEBUG [sqlalchemy.pool.QueuePool][worker 8] > Connection <_mysql.connection open to 'localhost' at 7fba941ae020> checked > out from pool > 2012-03-21 15:56:44,806 INFO [sqlalchemy.engine.base.Engine][worker 8] > SELECT beaker_cache.data > FROM beaker_cache > WHERE beaker_cache.namespace = %s > 2012-03-21 15:56:44,807 INFO [sqlalchemy.engine.base.Engine][worker 8] > ('ce95383d11c14577881b5e2c549e87ec',) > > I soon discovered in many cases the connection checked out for the beaker > query is never returned to the pool. The queries I'm doing for in the > application code seem to be behaving properly, checking out and returning > connections correctly. It's just he beaker queries... > > > Does anyone have similar experiences beaker and issues like this? Any > advice on approaching this? I'm a bit stuck. > > > I'm currently using: Beaker 1.6, SQLAlchemy 0.7.3 and Pyramid 1.2.1 > > Thanks much in advance! > Jacob > > > > > > -- You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss?hl=en.
