Canal报错:Could not find first log file name in binary log index file
canal
alibaba/canal: Canal 是由阿里巴巴开源的分布式数据库同步系统,主要用于实现MySQL数据库的日志解析和实时增量数据订阅与消费,广泛应用于数据库变更消息的捕获、数据迁移、缓存更新等场景。
项目地址:https://gitcode.com/gh_mirrors/ca/canal

·
错误信息:
address gdny-mall.rwlb.rds.aliyuncs.com/172.18.110.56: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) ~[canal.parse-1.1.6.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:237) ~[canal.parse-1.1.6.jar:na]
at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:262) ~[canal.parse-1.1.6.jar:na]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_202]
1、关闭canal服务 canal安装目录/bin/stop.sh
sh example/bin/stop.sh
2、删除上次canal服务停止时产生的meta.bat (数据消费位置文件)
rm -rf /canal/conf/example/meta.bat
3、启动canal服务
sh /canal/bin/startup.sh




alibaba/canal: Canal 是由阿里巴巴开源的分布式数据库同步系统,主要用于实现MySQL数据库的日志解析和实时增量数据订阅与消费,广泛应用于数据库变更消息的捕获、数据迁移、缓存更新等场景。
最近提交(Master分支:23 天前 )
af937544 - 1 个月前
9f2fc740 - 1 个月前
更多推荐
所有评论(0)