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.
