mysql deadlock when replicating table with unique key

[ghost]

CREATE TABLE a.t13 (id INT(11) AUTO_INCREMENT, c CHAR(20)  DEFAULT 't13',
 CONSTRAINT UNIQUE INDEX (id, c));

2022-11-14T17:37:09.879+0800 [ERROR] extractor: onError: job=ddl_create_table_constraint-migration err="applier error: Error 1213: Deadlock found when trying to get lock; try restarting transaction" hasShutdown=false

[ghost]

使用简化情况代码测试:

• 5.7.25 可以复现
• 5.7.34 无法复现

此处描述了 MySQL 5.7.26 中 deadlock 增多的情况 https://stackoverflow.com/questions/68627347

[ghost]

总结

1. 死锁由MySQL Bug引起. 该MySQL Bug于5.7.26修复.
   • https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-26.html (搜 25966845)
2. dtle 将在新版提供“死锁时重试事务”机制, 一定程度上能缓解问题.
   • b8d4ebb
   • 6e67993

[ghost]

ATK-3274