13. Understanding the Locking System : Deadlock
 
Share this page                  
Deadlock
Deadlock occurs when one transaction is waiting for a lock held by another transaction and the other transaction is waiting for a lock held by the first transaction at the same time. Both transactions are blocked and cannot complete. One of the transactions must be aborted to break the deadlock and allow the other to proceed. This is a simple situation; in more complex scenarios, many transactions may be involved in creating the deadlock situation.
Deadlock should be avoided where possible.