Deadlock

When two transactions wait on each other to release their locks, they get into a deadlock. Deadlocks occur more frequently with increased usage of locks, like in Serializable Isolation and Two-phase locking.

Databases automatically detect deadlocks between transactions and abort one of them so that other transactions can make progress. The aborted transaction then needs to be retried by the application.