MySQL主从数据同步出错 Last_Errno: 1755
MySQL主从数据同步出错
Last_Errno: 1755
Last_Error: Cannot execute the current event group in the parallel mode. Encountered event Format_desc, relay-log name ./JX-P-L-slave-220-relay-bin.000082, position 239 which prevents execution of this event group in parallel mode. Reason: possible malformed group of events from an old master.
故障:并行复制导致
解决: 关闭并行复制
mysql> stop slave; Query OK, 0 rows affected (0.07 sec) mysql> set global slave_parallel_workers=0; Query OK, 0 rows affected (0.00 sec) mysql> start slave; Query OK, 0 rows affected (0.17 sec)