canal-adapter-1.1.5 手动etl报死锁问题

w9apscun 于 4个月前发布在其他

关注(0)|答案(5)|浏览(111)

手动elt {"succeeded":false,"resultMessage":"导入RDB 数据：20000 条","errorMessage":"xxxx etl failed! ==>Deadlock found when trying to get lock; try restarting transaction\xxxxxx etl failed! ==>Deadlock found when trying to get lock; try restarting transaction"}%
求解？？？？？？？

canal

来源：https://github.com/alibaba/canal/issues/4022

5条答案

按热度按时间

hk8txs481#

我看了下源码，只有在数据大于10000的时候，多线程处理会出现这个死锁问题，有没有人解决下啊？？？？？？
rdb,mysql，数据库隔离级别是rr情况下会出现

赞(0）回复(0）举报 4个月前

bhmjp9jg2#

您的邮件我已收到，非常感谢，以后常联系！

赞(0）回复(0）举报 4个月前

jfgube3f3#

隔离级别调整为RC，也还是有同样的问题

{"succeeded":false,"resultMessage":"导入RDB 数据：1671930 条","errorMessage":"user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction
user_logs etl failed! ==>Deadlock found when trying to get lock; try restarting transaction"}
curl: (6) Could not resolve host: params=20220101

赞(0）回复(0）举报 4个月前

fgw7neuy4#

隔离级别调整为RC没问题的，你应该是设置RC没生效

赞(0）回复(0）举报 4个月前

inb24sb25#

我的问题感觉和这个说法一致：
#2060 (comment)
因为同步结束后，我核实了两个表的数据条数是一致的。虽然报错了，但是数据导入成功了。

赞(0）回复(0）举报 4个月前