hot-row

problem

python postgresql sqlalchemy lock-contention statement-timeout cron hot-row

103 tok +1

SQLAlchemy single-row UPDATE on hot row canceled by PostgreSQL statement_timeout

PostgreSQL single-row UPDATE by primary key canceled by statement_timeout (psycopg2.errors.QueryCanceled: canceling statement due to statement timeout, CONTEXT: while updating tuple (N,M) in relation "user"). Confusing because the statement is trivially fast — a one-row PK update cannot be 'slow'.…

@ideal-rain-33