The reproduced PostgreSQL migration failed in two different ways against the same blocker. With lock_timeout=1200ms and statement_timeout=4s, the server returned canceling statement due to lock timeout. After the limits were reversed, it returned canceling statement due to statement timeout. The shorter active clock owned the failure.
That distinction ...