从MySQL 5.6到5.7复制错误解决_mysql教程_开发教程

在MySQL 5.7下采用多源复制方式，从5.6复制数据过来，会有问题吗？

1、问题描述

Q群里有位朋友想尝鲜5.7的多源复制，于是用MySQL 5.7版本作为slave，把MySQL 5.6作为master，想要将数据进行汇总，发现此路不通。

他在my.cnf中设置了2个选项，开启并发复制：

slave_parallel_type = LOGICAL_CLOCK

slave_parallel_workers = 4

启动复制线程后，结果在错误日志中不断有类似下面的信息：

Transaction is tagged with inconsistent logical timestamps: sequence_number (823267087) <= last_committed (1301275374434324336)

执行 SHOW SLAVE STATUS\G 查看状态：

*************************** 1. row ***************************

Slave_IO_State: Waiting for master to send event

…

Last_Errno: 1756

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).

…

Last_SQL_Errno: 1756

Last_SQL_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).

…

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp: 160523 18:49:05

…

*************************** 2. row ***************************

Slave_IO_State: Waiting for master to send event

…

Last_Errno: 1756

Skip_Counter: 0

…

Last_SQL_Errno: 1756

…