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等操作;
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 阿里最新开源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清理过期文件【转】