Impact of long-running transactions on SQL deadlocks
Detecting and resolving deadlocks in PostgreSQL
Detecting and resolving deadlocks in Oracle
Detecting and resolving deadlocks in MySQL
Deadlock recovery strategies