Consider the following example: — Transaction 1 -> T1 BEGIN; SELECT * FROM table1 WHERE id = 1 FOR UPDATE; SELECT * FROM table1 WHERE id = 2 FOR UPDATE; UPDATE table1 set col1 = ‘abcd’ where id = 1; COMMIT; — Transaction 2 -> T2 BEGIN; SELECT * FROM table1 WHERE id = 2… Read More Deadlock when using SELECT FOR UPDATE with IN list