hard20 pts · first answer countsconcurrencytransactions

Deadlocks between two transfers

A transfer from A to B locks row A then row B. At the same moment, a transfer from B to A locks B then A. The database reports deadlocks under load. What is the best fix?

A.Raise lock_timeout and deadlock_timeout so transactions wait longer for each other before the database gives upB.Lock rows in one consistent order, such as by ascending account id, and retry deadlock victimsC.Use READ UNCOMMITTED so no locks are takenD.Add an index on the balance column

Discussion 0

Join free to post in the discussion.

Deadlocks between two transfers

Discussion 0

Related questions