开发者社区> 问答> 正文

主库是mysql 5.7,主库编码UTF8MB4,用canal-1.0.24这个版本,位点初始值为1

主库是mysql 5.7,主库编码UTF8MB4,用canal-1.0.24这个版本,位点初始值为123,执行时间1506482123,canal配置了timestamp,没有配置位点,提示以下异常

2017-09-29 14:20:32.614 [main] INFO c.a.otter.canal.instance.core.AbstractCanalInstance - start successful.... 2017-09-29 14:20:32.892 [destination = example_wxprober , address = /XXXXXXX:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - prepare to find start position mysql-bin.000013::1506482123000 2017-09-29 14:20:32.934 [destination = example_wxprober , address = /XXXXXXX: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

原提问者GitHub用户angelmm126

展开
收起
绿子直子 2023-05-09 12:02:04 77 0
1 条回答
写回答
取消 提交回答
  • Could not find first log file name in binary log index file,位点不对

    原回答者GitHub用户agapple

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

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像