侧边栏壁纸
博主头像
落叶人生博主等级

走进秋风,寻找秋天的落叶

  • 累计撰写 130562 篇文章
  • 累计创建 28 个标签
  • 累计收到 9 条评论
标签搜索

目 录CONTENT

文章目录

MySQL主从复制异常.md

2024-05-14 星期二 / 0 评论 / 0 点赞 / 88 阅读 / 646 字

一、MySQL 5.6 >> MySQL 5.7错误信息:Last_Error: ... The slave coordinator and worker threads are stopped, p

一、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;

广告 广告

评论区