mysql 1755_MySQL案例01：Last_SQL_Errno: 1755 Cannot execute the current event group in the parallel mod...

最新推荐文章于 2021-03-17 00:52:01 发布

迦勒底搞事先锋

最新推荐文章于 2021-03-17 00:52:01 发布

阅读量504

点赞数

文章标签： mysql 1755

本文链接：https://blog.csdn.net/weixin_34175388/article/details/113692704

版权

本文介绍了在MySQL 5.6中遇到的复制错误1755的详细情况，包括错误信息、错误原因分析及三种解决方案，包括跳过错误事件、关闭并行复制和重新部署从库。重点在于如何解决由于并行复制导致的主从同步问题。

摘要由CSDN通过智能技术生成

周五同事监控报警，有个MySQL从库复制状态异常，让我帮忙排查下，经过排查发现是MySQL5.6并行复制的一个Bug所致，具体处理过程如下：

一、错误信息

登录mysql从库服务器，检查复制状态

mysql>show slave status \G*************************** 1. row ***************************Slave_IO_State: Waitingfor master tosend event

Master_Host: xx.xx.xx.xx

Master_User: repuser

Master_Port:3306Connect_Retry:60Master_Log_File: mysql-bin.001689Read_Master_Log_Pos:145325388Relay_Log_File:mysql2-relay-bin.004390Relay_Log_Pos:147850306Relay_Master_Log_File: mysql-bin.001673Slave_IO_Running: Yes

Slave_SQL_Running: No

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno:1755Last_Error: Cannotexecute the current event group in the parallel mode. Encountered event Format_desc, relay-log name ./mysql2-relay-bin.004392, position 238 which prevents execution of this event group in parallel mode. Reason: possible malformed group of events froman old master.

Skip_Counter:0Exec_Master_Log_Pos:147850096Relay_Log_Space:4440639819Until_Condition: None

Until_Log_File:

Until_Log_Pos:0Mast