首页 新闻 搜索 专区 学院

数据库主从宕了,Slave_SQL_Running: No

0
悬赏园豆:100 [待解决问题]

2022-12-06T02:41:38.530333Z 1065 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction '41ca446b-0c92-11ed-978e-00e0ed4490a0:7332' at master log mysql_bin.000097, end_log_pos 491; Could not execute Write_rows event on table fitness.t_mission_record; Duplicate entry '1658' for key 't_mission_record.PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql_bin.000096, end_log_pos 491, Error_code: MY-001062
2022-12-06T02:41:38.530609Z 1064 [ERROR] [MY-010586] [Repl] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql_bin.000097' position 197

张超626的主页 张超626 | 初学一级 | 园豆:102
提问于:2022-12-06 11:08
< >
分享
所有回答(2)
0

https://www.cnblogs.com/Biuget-Golang/p/16788301.html 参考我写的文章,可能出现的问题。

Biuget-Golang | 园豆:318 (菜鸟二级) | 2022-12-07 13:40
0

错误信息都告诉你了“Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; ” 从库主键重复。
可以仔细核对主从涉及表的数据; 另外看下主从表结构是否相同。最后可以手工处理从库的重复数据。

jinzhenshui | 园豆:383 (菜鸟二级) | 2022-12-12 14:33
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册