Error reading relay log event for channel '10.18.51.35': slave SQL thread was killed

报错信息:

2022-09-04T03:02:01.028220+08:00 2848717 [Note] Error reading relay log event for channel '192.168.1.35': slave SQL thread was killed
2022-09-04T03:02:01.241783+08:00 2854784 [Note] Slave SQL thread for channel '192.168.1.35' initialized, starting replication in log 'mysq
l_bin.000222' at position 203691981, relay log '/data/mysql/binlog/mysql_relay_bin-10@002e18@002e51@002e35.000607' position: 203692154
2022-09-05T03:02:02.489944+08:00 2854784 [Note] Error reading relay log event for channel '192.168.1.35': slave SQL thread was killed
2022-09-05T03:02:02.704105+08:00 2860852 [Note] Slave SQL thread for channel '192.168.1.35' initialized, starting replication in log 'mysq
l_bin.000223' at position 176706035, relay log '/data/mysql/binlog/mysql_relay_bin-10@002e18@002e51@002e35.000610' position: 176706208
2022-09-06T03:02:36.247343+08:00 2860852 [Note] Error reading relay log event for channel '192.168.1.35': slave SQL thread was killed
2022-09-06T03:02:36.457626+08:00 2866923 [Note] Slave SQL thread for channel '192.168.1.35' initialized, starting replication in log 'mysq
l_bin.000224' at position 160079172, relay log '/data/mysql/binlog/mysql_relay_bin-10@002e18@002e51@002e35.000613' position: 160079345
2022-09-07T03:02:06.126161+08:00 2866923 [Note] Error reading relay log event for channel '192.168.1.35': slave SQL thread was killed
2022-09-07T03:02:06.337287+08:00 2872989 [Note] Slave SQL thread for channel '192.168.1.35' initialized, starting replication in log 'mysq
l_bin.000225' at position 152624716,

 

根据上述信息可以得知,基本都是 03:02分左右

看了一下 crontab 是 xtrabackup 备份导致有这个操作,因为里面为了获取一致性binlog位点,有类似 stop slave等操作;

 

posted @ 2022-09-19 11:42  郭大侠1  阅读(302)  评论(0编辑  收藏  举报