Deadlocks from inconsistent row lock ordering

Two or more transactions lock rows in opposite orders, resulting in deadlocks that abort transactions and require application retry logic

Standardize row locking order across all application code paths. Always lock rows sorted by primary key ascending. For batch updates, use ORDER BY in CTEs or sort IDs in application code before acquiring locks.