replication-manager icon indicating copy to clipboard operation
replication-manager copied to clipboard

MySQL 5.7 can loop for ever waiting to apply relay log

Open lshiguang opened this issue 5 years ago • 4 comments

when the one master and one slave auto failover,the old master not start,the new master(old slave) is not auto failover 图片

图片

lshiguang avatar Jun 05 '19 01:06 lshiguang

[root@proxysql1 ~]# replication-manager-osc version Replication Manager 2.0.1 for MariaDB 10.x and MySQL 5.7 Series Full Version: 2.0.1-26-gb2bc67c Build Time: 2019-06-04T18:49:51+0800

lshiguang avatar Jun 05 '19 01:06 lshiguang

That's really unexpected looks like mysql don't upgrade the gtid or the file position up to what it has read on the master . Can you provide minor MySQL Minor release and the content of the relay log from position where it stop to the pos it end , i will patch the code to look after Slave Has read all relay log message , but that looks like a hack .

svaroqui avatar Jun 05 '19 06:06 svaroqui

MySQL release :Server version: 5.7.25

lshiguang avatar Jun 10 '19 01:06 lshiguang

increase check-replication-state = false is successful

lshiguang avatar Jun 10 '19 01:06 lshiguang