测试环境:
MySQL 5.7.26
创建测试表:
mysql> create table t3(id int not null default '0',primary key(id));
Query OK, 0 rows affected (0.00 sec)
插入测试数据:
mysql> insert into t3 values(1);
Query OK, 1 row affected (0.00 sec)
死锁模拟过程如下:
会话1commit之后,会话2核会话3产生死锁,会话3回滚,并抛出:
ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
过程说明:
死锁日志:
LATEST DETECTED DEADLOCK
------------------------
2020-08-21 18:23:54 0x7f39023