mysql - Since innodb has gap locks at the RR isolation level, why do two transactions still produce deadlocks due to different locking orders? ?-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

mysql - Since innodb has gap locks at the RR isolation level, why do two transactions still produce deadlocks due to different locking orders? ?

ringa_lee 2017-05-18 10:54:38

611

Deadlock is caused by multiple transactions competing for the same resource. Whether it is two SQL statements in two transactions, the locking order of the resources being operated is different, or the locking order of the resources operated by one SQL statement in the two transactions is different. Why is the gap lock not locking in the scope, thus suspending another transaction's request for the resource?