canal连接ali RDS提示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) 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)
这个报错:Could not find first log file name in binary log index file
代表binlog已经被清理了
我遇到了相同的问题, 如何解决呢, 请提供下思路
已经解决了, 我使用的是canal_1.1.7 + zookeeper-3.4.10
我的解决思路是
1.先停止canal
2.登录zookeeper
删除了有问题的节点 rmr /otter/canal/destinations/有问题的节点
3.修改canal配置, 增加RDS二进制日志文件名称 和 position号码
4.启动canal