Table A is:
id integer version varchar data jsonb (large data 1mb) fkToBid integer
Table B is:
id integer other...
Processes are aggressively running these two updates, in any order. Sometimes with same B.id and sometimes with same A.id:
UPDATE A.version WHERE A.id=:id and UPDATE A.data WHERE A.id=:id
Why this can interlock? They should lock the A pk and the B pk always in the same order, so it should never interlock, isn’t it ? I heard somewhere about deadlock graph, how to see it?