开发者社区> 问答> 正文

主备切换的问题

主备切换的过程中出现错误,log如下(注意mysql-bin.000029=7¾ 以及Could not find first log file name in binary log index) 2017-01-03 22:09:16.930 [destination = xiaopang3 , address = /192.168.6.123:3306 , EventParser] INFO c.alibaba.otter.canal.parse.driver.mysql.MysqlConnector - client authentication packet is sent out. 2017-01-03 22:09:16.934 [destination = xiaopang3 , address = /192.168.6.123:3306 , EventParser] INFO c.a.otter.canal.parse.inbound.mysql.MysqlConnection - COM_BINLOG_DUMP with position:BinlogDumpCommandPacket[binlogPosition=21725485,slaveServerId=1237,binlogFileName=mysql-bin.000029=7¾ ,command=18] 2017-01-03 22:09:16.935 [destination = xiaopang3 , address = /192.168.6.123:3306 , EventParser] ERROR c.a.o.canal.parse.inbound.mysql.dbsync.DirectLogFetcher - I/O error while reading from client socket 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:95) ~[canal.parse-1.0.23.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:121) [canal.parse-1.0.23.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:209) [canal.parse-1.0.23.jar:na] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45] 2017-01-03 22:09:16.935 [destination = xiaopang3 , address = /192.168.6.123:3306 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address /192.168.6.123: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:95) ~[canal.parse-1.0.23.jar:na] at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.dump(MysqlConnection.java:121) ~[canal.parse-1.0.23.jar:na] at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$3.run(AbstractEventParser.java:209) ~[canal.parse-1.0.23.jar:na] at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45] 2017-01-03 22:09:16.935 [destination = xiaopang3 , address = /192.168.6.123:3306 , EventParser] ERROR com.alibaba.otter.canal.common.

原提问者GitHub用户ch-lgs

展开
收起
绿子直子 2023-05-09 15:47:10 66 0
1 条回答
写回答
取消 提交回答
  • 感觉是binlog名字出现了乱码,试试当前主干

    原回答者GitHub用户agapple

    2023-05-10 10:42:47
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载