mysql主从位点保存时间_位点过段时间就会重置

最新推荐文章于 2022-09-26 08:52:19 发布

weixin_39533361

最新推荐文章于 2022-09-26 08:52:19 发布

阅读量432

点赞数

文章标签： mysql主从位点保存时间

本文链接：https://blog.csdn.net/weixin_39533361/article/details/113474080

版权

查看otter的同步日志，发现过段时间canal的位置就会重置，导致一直停留在那个时间段，otter没法向前跑了

2018-02-01 09:36:55.663 [destination = 175_zhenai_crm , address = d.db.jiebao.zhenai.com/10.10.10.175:3311 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - prepare to find start position just last position

{"identity":{"slaveId":-1,"sourceAddress":{"address":"d.db.jiebao.zhenai.com","port":3311}},"postion":{"included":false,"journalName":"mysql-bin.001909","position":262778737,"serverId":10096,"timestamp":1517415628000}}

2018-02-01 09:36:55.750 [pipelineId = 13,taskName = SelectTask] WARN c.a.o.shared.arbitrate.impl.setl.monitor.MainstemMonitor - mainstem check is interrupt

2018-02-01 09:36:56.919 [pipelineId = 13,taskName = SelectTask] WARN c.a.o.shared.arbitrate.impl.setl.monitor.MainstemMonitor - mainstem is not run any in node

2018-02-01 09:36:56.997 [destination = 175_zhenai_crm , address = d.db.jiebao.zhenai.com/10.10.10.175:3311 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - prepare to find start position just last position