40001 — Serialization Failure

このエラーの原因

Concurrent transactions attempted to modify the same data in a way that violates serializable isolation.

修正方法

Retry the transaction automatically. Reduce contention by minimizing transaction scope. Consider a lower isolation level.

-- serialization_failure: retry the transaction
BEGIN ISOLATION LEVEL SERIALIZABLE;
-- ... queries ...
COMMIT; -- if fails with 40001, retry