MySQL5.6迁移至5.7,常用的方法是新搭建5.7作为5.6的从库。start slave时遇到报错:
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 ./mysql-relay.000002, position 123321 which prevents execution of this event group in parallel mode. Reason: The master event is logically timestamped incorrectly...
从MySQL官网搜索1755的报错看到是并行复制bug导致的报错。想要解决的办法也很简单,直接关掉并行复制即可。
stop slave;
set global slave_parallel_workers=0;
start slave;
可以参考官方文档
https://bugs.mysql.com/bug.php?id=71495