mysql间隙锁导致死锁

建表语句

CREATE TABLE `aaa_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

产生死锁的场景

sessionA
1、start TRANSACTION;
2、select * from aaa_user where id = 8 FOR UPDATE; //产生间隙锁
5、INSERT INTO aaa_user VALUES(8,"dowsws",27); //等待B间隙锁

sessionB
3、start TRANSACTION;
4、select * from aaa_user where id = 8 FOR UPDATE; //产生间隙锁
6、INSERT INTO aaa_user VALUES(8,"dowsws",27); //产生死锁

因为间隙锁之间是不互斥的，所以获取间隙锁都可以获取的到。