记一次Mysql 数据库迁移后报错问题
admin
2023-01-25 17:23:56
0

现象说明:老数据库版本是5.6,新库版本5.7,数据量不大,备份恢复数据均正常,配置主从使用gtid复制后也是正常的,第二天查看新库的时候,发现新库复制出现问题,报错如下:

2019-10-10T10:15:27.541697+08:00 4256 [Warning] Master server does not support semi-sync, fallback to asynchronous replication
2019-10-10T10:15:29.993985+08:00 4257 [ERROR] Transaction is tagged with inconsistent logical timestamps: sequence_number (3546074770274598260) <= last_committed (8314045271803935669)
2019-10-10T10:15:29.994028+08:00 4257 [Warning] Slave SQL for channel '': Coordinator thread of multi-threaded slave is being stopped in the middle of assigning a group of events; deferring to exit until the group completion ... , Error_code: 0
2019-10-10T10:15:29.994052+08:00 4257 [ERROR] Slave SQL for channel '': Cannot execute the current event group in the parallel mode. Encountered event Gtid, relay-log name ./relay.000002, position 1090573 which prevents execution of this event group in parallel mode. Reason: The master event is logically timestamped incorrectly.. Error_code: 1755
2019-10-10T10:15:29.994066+08:00 4257 [Warning] Slave: Cannot execute the current event group in the parallel mode. Encountered event Gtid, relay-log name ./relay.000002, position 1090573 which prevents execution of this event group in parallel mode. Reason: The master event is logically timestamped incorrectly.. Error_code: 1755
2019-10-10T10:15:29.994070+08:00 4257 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'logbin.000015' position 234960156
2019-10-10T10:16:01.494097+08:00 4256 [Note] Slave I/O thread killed while reading event for channel ''

查看数据库的变量参数 slave_parallel_workers ,发现老库的是0,串行复制,新库的是4,并行组复制,根据网上查到的内容,也是由于这个参数导致
修复方法:修改新库的slave_parallel_workers 参数为0,清理数据库,清理binlog 日志,恢复数据,重建主从关系,主从复制OK

相关内容

热门资讯

玩家攻略科普“微乐三打一.可以... 家人们!今天小编来为大家解答微乐三打一透视挂怎么安装这个问题咨询软件客服徽9784099的挂在哪里买...
终于懂了“微乐卡五星.是不是有... 终于懂了“微乐卡五星.是不是有挂?”果然有透视挂您好,微乐卡五星这个游戏其实有挂的,确实是有挂的,需...
终于明白“新贝壳牛牛.到底是不... 有 亲,根据资深记者爆料新贝壳牛牛是可以开挂的,确实有挂(咨询软件无需打...
今日重大通报“科乐吉林麻将.真... 网上科普关于“科乐吉林麻将有没有挂”话题很是火热,小编也是针对科乐吉林麻将作*弊开挂的方法以及开挂对...
今日重大发现“乐禧棋牌.辅助器... 今日重大发现“乐禧棋牌.辅助器?”其实是有挂您好,乐禧棋牌这个游戏其实有挂的,确实是有挂的,需要了解...
今日重大消息“友乐广西麻将.辅... 您好:友乐广西麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9784099】很多玩家在这款...
【第一资讯】“拱趴大菠萝.真的... 【第一资讯】“拱趴大菠萝.真的有挂吗?”太坑了原来有挂您好,拱趴大菠萝这个游戏其实有挂的,确实是有挂...
今日重磅消息“阿道夫十三水.开... 网上科普关于“阿道夫十三水有没有挂”话题很是火热,小编也是针对阿道夫十三水作*弊开挂的方法以及开挂对...
终于了解“潮汕掌上娱.开挂器?... 家人们!今天小编来为大家解答潮汕掌上娱透视挂怎么安装这个问题咨询软件客服徽4282891的挂在哪里买...
【今日要闻】“先锋大厅.怎么开... 有 亲,根据资深记者爆料先锋大厅是可以开挂的,确实有挂(咨询软件无需打开...