查看 /home/admin/canal-server/logs/example/example.log 中有如下报错:
2022-07-20 00:00:08.473 [destination = example , address = mall-mysql/192.168.38.131:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:e
xample[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:238)
at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:262)
at java.lang.Thread.run(Thread.java:748)
原因:
配置文件中设置的 binlog 文件没有找到
解决:
因为本例的 instance.properties 配置文件是打包到 docker 镜像中的,因此只能在实例中修改
先查看数据库中的 binlog 日志文件名及 position
在本例 mall-mysql 数据库中查询:
mysql> show master status;
输出的 File:mysql-binlog.000233,Position:652645
进入实例:
kubectl exec -ti mall-canal-84f6f7d7cc-xbghn bash -n nsName
xxx> vi /home/admin/canal-server/conf/example/instance.properties
修改其中的 position info 部分:
canal.instance.master.address=mall-mysql:3306
canal.instance.master.journal.name=mysql-binlog.000233
canal.instance.master.position=652645
canal.instance.master.timestamp=
canal.instance.master.gtid=
重启服务:
xxx> cd /home/admin/canal-server
xxx> ./restart.sh
重启后查看日志,故障消除