canal 报错：Could not find first log file name in binary log index file

canal wiki地址：https://github.com/alibaba/canal/wiki/

canal 报错：Could not find first log file name in binary log index file

1、canal_deployer 日志报错：

2024-07-29 14:25:21.624 [destination = example , address = /192.168.1.7:3306 , EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address /192.168.1.7:3306 has an error, retrying. caused by
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:247)
    at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:257)
    at java.lang.Thread.run(Thread.java:748)

2、关闭canal_deployer服务

/data/canal_deployer/bin/stop.sh

3、删除数据消费文件 meta.dat 以及 h2.mv.db 两个文件

# cd /data/canal_deployer/conf/example

# rm -rf meta.dat h2.mv.db

4、修改canal_deployer中的配置文件instance.properties,修改binlog以及pos点

canal.instance.master.journal.name=mysql-bin.074560
canal.instance.master.position=241476047

5、启动canal_deployer服务，重启canal_adapter

# /data/canal_deployer/bin/startup.sh

# /data/canal_adapter/bin/startup.sh

6、查看canal_adapter、canal_deployer、meta日志是否正常