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 @   郭大侠1  阅读(372)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
历史上的今天:
2019-09-19 (4.35)sql server清理过期文件【转】
点击右上角即可分享
微信分享提示