Deadlocks happen when two or extra transactions look forward to one another to launch a lock. This will result in a scenario the place neither transaction can proceed, and the database turns into unresponsive.
There are a selection of the way to keep away from deadlocks, together with: