canal icon indicating copy to clipboard operation
canal copied to clipboard

canal连接ali RDS提示Could not find first log file name in binary log index file

Open jason-wks opened this issue 11 months ago • 1 comments

at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:102) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:270) at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:257) at java.lang.Thread.run(Thread.java:748) 2025-01-17 12:54:54.911 [destination = yorky , address = rm-wz9bbe4li62amld67do.m******95.150:*306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:yorky[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:102) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:270) at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:257) at java.lang.Thread.run(Thread.java:748)

Image

jason-wks avatar Jan 17 '25 05:01 jason-wks

这个报错:Could not find first log file name in binary log index file

代表binlog已经被清理了

agapple avatar Jan 20 '25 02:01 agapple

我遇到了相同的问题, 如何解决呢, 请提供下思路

linhebin1995 avatar May 21 '25 05:05 linhebin1995

已经解决了, 我使用的是canal_1.1.7 + zookeeper-3.4.10 我的解决思路是 1.先停止canal Image 2.登录zookeeper 删除了有问题的节点 rmr /otter/canal/destinations/有问题的节点 3.修改canal配置, 增加RDS二进制日志文件名称 和 position号码 Image 4.启动canal Image

Image

linhebin1995 avatar May 21 '25 07:05 linhebin1995