A deadlock ya faru lokacin da juna (ko fiye) transactions kowannen yana riƙe da lock wanda juna ne suke buƙata, don haka babu wanda zai iya ci gaba — sun takura suna jira juna har abada. Databases suna gano deadlocks kuma suna warware su ta hanyar kawar da wata transaction ("victim"), wacce dole ne ta sake gudun aiki. Fahimtar dalilan da hanyoyin kawar da su yana da mahimmanci ga aikace-aikacen da ke aiki daidai.
Yadda deadlock ya faru
Transaction A: locks row 1, then wants row 2
Transaction B: locks row 2, then wants row 1
→ A waits for B (to release row 2), B waits for A (to release row 1) → DEADLOCK
Neither can proceed; they're waiting on each other in a cycle.
