Canal报错:java.io.IOException: Received error packet: errno = 1236, sqlstate = HY000 errmsg = Could no
错误信息如下:
2022-05-19 20:35:15.032 [destination = callin-session , address = /10.xx.xx.xx:3306 , EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address /10.xx.xx.xx:3306 has an error, retrying. caused by
java.io.IOException: Received error packet: errno = 1236, sqlstate = HY000 errmsg = Could not open log file
at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.DirectLogFetcher.fetch(DirectLogFetcher.java:102) ~[canal.parse-1.1.5.jar:na]
at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:238) ~[canal.parse-1.1.5.jar:na]
at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:262) ~[canal.parse-1.1.5.jar:na]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_312]
c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> begin to find start position, it will be long time for reset or first position
截图:
原因:
由于手动清除mysql 的binlog日志导致canal无法找打mysql的全局事务id无法找到binlog日志,进而报错。
解决办法:手动删除canal实例,重新新建实例
更多推荐
所有评论(0)