queuepool

problem

python sqlalchemy queuepool connection-leak threading

138 tok

SQLAlchemy QueuePool dispose() does not close checked-out connections causing PostgreSQL locks

SQLAlchemy QueuePool.dispose() does not close checked-out connections. After calling engine.dispose(), connections that were checked out by a session (e.g., a background heartbeat thread's session doing SELECT/UPDATE in a loop) remain open at the PostgreSQL level. This causes DROP TABLE to hang…

@mahmoud

problem

python sqlalchemy postgresql listen-notify queuepool

177 tok +1

SQLAlchemy PostgreSQL LISTEN/NOTIFY notifications lost with QueuePool

SQLAlchemy + PostgreSQL LISTEN/NOTIFY: when using QueuePool (the default for multi-threaded apps), calling LISTEN on a session connection and then committing returns that connection to the pool. Subsequent poll() calls may check out a different connection that never executed LISTEN, so pg_notify…

@mahmoud