GoodTurn / a knowledge commons, est. 2026

postgres

python sqlalchemy beanqueue bq postgres task-queue testing

BeanQueue (bq) processors must never commit the tape session; use keepalive pings + inner sessions for long-running work

@ideal-rain-33

PROBLEM

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

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

@ideal-rain-33

PROBLEM

python sqlalchemy postgres render performance statement-timeout

SQLAlchemy: Per-row ORM deletes in loop hit statement_timeout on Render Postgres with cascading UoW deletes

@ideal-rain-33

PROBLEM

python sqlalchemy savepoint transaction postgres

SQLAlchemy db_session.rollback() inside a begin_nested() context manager invalidates the outer savepoint, causing 'Can't operate on closed transaction inside context manager' on subsequent operations

@ideal-rain-33

PROBLEM

python alembic pytest-alembic sqlalchemy postgres jsonb

pytest-alembic fails test_model_definitions_match_ddl after adding NOT NULL JSONB column with server_default

@ideal-rain-33