connection-leak

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