为什么运行好好的，突然报错Could not find first log file name in binary log index file

aiaix commented 7 years ago

双向同步中，出现的。而且还影响了单向同步。指定了位点，同步看起来正常，但是始终处于定位中，数据不同步。

owenludong commented 7 years ago

我这边也是，运行着突然报这个 canal 1.0.22, rds

我记得canal1.0.22已经支持了rds(myql)的主备切换时的binlog自动切换的问题。但是还是会有这个问题

ERROR c.a.o.canal.parse.inbound.mysql.dbsync.DirectLogFetcher - I/O error while reading from client socket java.io.IOException: Received error packet: errno = 1236, sqlstate = HY000 errmsg = Could not find first log file name in binary log index file at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:95) ~[canal.parse-1.0.22.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:113) [canal.parse-1.0.22.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:210) [canal.parse-1.0.22.jar:na] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]

agapple commented 7 years ago

rds会有删除binlog的操作，如果消费有延迟就容易出现位点不在的情况

geckhan commented 6 years ago

请问这个要怎么处理

alibaba / canal

为什么运行好好的，突然报错Could not find first log file name in binary log index file #236