最近做了很多组基于并行复制(MTS)的主从,其中大多数为5.6->5.7的结构,少部分5.6->5.6的并行复制。
每组m-s结构配置相近,有一定几率出现如下错误,但不是全部出现:
〇 ERROR 1755:
错误场景:
Master(5.6) -> Slave(5.6/5.7)
相关配置:
Slave开启并行复制:
slave_parallel_workers>=1。
Slave报错信息:(此处是5.7的Slave,5.6也类似,但reason会有不同)
-
……
-
Slave_io_Running: Yes
-
Slave_sql_Running: No
-
……
-
Last_Errno: 1755
-
Last_Error: Cannot execute the current event group in the parallel mode. Encountered event Gtid, relay-log name {目录}/relaylog/Mysql-relay.000002, position 280408 which prevents execution of this event group in parallel mode. Reason: The master event is logically timestamped incorrectly..
-
……
-
Last_IO_Errno: 0
-
Last_IO_Error:
-
Last_SQL_Errno: 1755
-
Last_SQL_Error: Cannot execute the current event group in the parallel mode. Encountered event Gtid, relay-log name {目录}/relaylog/mysql-relay.000002, position 280408 which prevents execution of this event group in parallel mode. Reason: The master event is logically timestamped incorrectly..
-
Replicate_Ignore_Server_Ids:
-
……
--结束END--
本文标题: 【MySQL】5.6/5.7并行复制bug导致的故障 ERROR 1755/1756
本文链接: https://www.lsjlt.com/news/47031.html(转载时请注明来源链接)
有问题或投稿请发送至:
邮箱/279061341@qq.com QQ/279061341
0