数据库主从宕了，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
所有回答(2)
0
https://www.cnblogs.com/Biuget-Golang/p/16788301.html 参考我写的文章，可能出现的问题。
0
错误信息都告诉你了“Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; ” 从库主键重复。
可以仔细核对主从涉及表的数据； 另外看下主从表结构是否相同。最后可以手工处理从库的重复数据。
