Two Transactions, Frozen Forever: The Deadlock Explained

Your logs show a "deadlock detected" error and one of your requests just died for no obvious reason. It feels random. It isn't. Deadlocks happen for one specific, avoidable reason — and once you see i