Deadlock

What
A deadlock is a cycle of transactions waiting for locks to be released by each other.

Solutions

 * Deadlock Prevention
 * Deadlock Detection