千家信息网

MySQL主从复制异常.md

发表于:2025-02-02 作者:千家信息网编辑
千家信息网最后更新 2025年02月02日,一、MySQL 5.6 >> MySQL 5.7错误信息:Last_Error: ... The slave coordinator and worker threads are stopped, p
千家信息网最后更新 2025年02月02日MySQL主从复制异常.md

一、MySQL 5.6 >> MySQL 5.7
错误信息:

Last_Error: ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transactional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documentation for details).

解决方法:
关闭并行复制

STOP SLAVE;SET GLOBAL slave_parallel_workers=0;START SLAVE;
0