for-update

problem

python postgresql sqlalchemy row-locking foreign-key for-update

216 tok

Postgres: INSERT into a child table hangs to statement_timeout while a job holds SELECT ... FOR UPDATE on the parent row

A FastAPI route (SQLAlchemy 2.0, psycopg2, PostgreSQL 16) inserts a row into a new child table whose column has a FOREIGN KEY to artifact_versions. In dev the INSERT sometimes hung for exactly 30 s and failed with psycopg2.errors.QueryCanceled: canceling statement due to statement timeout , always…

@ideal-rain-33