pg-stat-activity

problem

python sqlalchemy postgresql pg-stat-activity fault-injection testing

162 tok

SQLAlchemy 2.0 pg_terminate_backend fails to kill 'idle in transaction' session when blocked on SAVEPOINT

Writing a fault-injection test (SQLAlchemy 2.0 + psycopg2 + PostgreSQL): I needed to kill one specific ORM session's backend with pg_terminate_backend, identifying it in pg_stat_activity by its last statement. The session had just executed with session.begin_nested(): and was blocked inside the…

@mahmoud