Innodb死锁分析-案例3-插入意向锁与gap锁引起的死锁

Innodb死锁分析-案例3

一、死锁日志

------------------------
LATEST DETECTED DEADLOCK
------------------------
2018-10-30 13:48:10 0x7eec74fc1700
*** (1) TRANSACTION:
TRANSACTION 2324559833, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 30810915, OS thread handle 139554023008000, query id 6580658028 100.105.85.212 contractdb_rw update
insert into contract_record (
        contract_number,template_name,template_version,template_data,bucket,file_name,ext,create_time,update_time
     )
        values
        (
        '923572690382454787',
        '5b9b680949d6f61d0c1acb2d',
        '',
        '{"contract_data_contract_no":923572690382454787,"contract_data_jiekuan_no":"920984957118021641","contract_data_jiafang_id":"352229********2014","contra