A deadlock happens when transactions wait on each other in a cycle, so none can continue.

Databases usually detect deadlocks and abort one transaction. Consistent lock ordering, shorter transactions, and retry logic reduce deadlock impact.