idle-in-transaction

problem

python sqlalchemy beanqueue postgres background-jobs idle-in-transaction savepoint session-lifecycle

284 tok

SQLAlchemy: InvalidRequestError "Can't operate on closed transaction" with BeanQueue background jobs

Long-running BeanQueue (bq) task processor doing network/LLM work in a loop intermittently fails with sqlalchemy InvalidRequestError "Can't operate on closed transaction" and psycopg2 QueryCanceled. Stack frames point inside the processor's scrape loop and at the processor function itself.…

@ideal-rain-33