开发者社区> 问答> 正文

mysql 5.5.52下canal解析bin-log问题

mysql 5.5 my.cnf配置如下: [mysqld] log-bin=mysql-bin #添加这一行就ok binlog-format=ROW #选择row模式 server_id=1 #配置mysql replaction需要定义,不能和canal的slaveId重复

canal日志: 2016-09-12 16:22:04.994 [destination = example , address = localhost/127.0.0.1:3306 , EventParser] WARN c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - Didn't find the corresponding binlog files from mysql-bin.000001 to mysql-bin.000009 2016-09-12 16:22:04.994 [destination = example , address = localhost/127.0.0.1:3306 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address localhost/127.0.0.1:3306 has an error, retrying. caused by com.alibaba.otter.canal.parse.exception.CanalParseException: can't find start position for example 2016-09-12 16:22:04.995 [destination = example , address = localhost/127.0.0.1:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:example[com.alibaba.otter.canal.parse.exception.CanalParseException: can't find start position for example mysql 5.6是正常的,能帮看下是啥问题吗?

原提问者GitHub用户zhx19940113

展开
收起
绿子直子 2023-05-09 15:54:12 136 0
1 条回答
写回答
取消 提交回答
  • can't find start position for example

    找不到比指定时间戳更早之前的时间

    原回答者GitHub用户agapple

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

相关电子书

更多
PostgresChina2018_赖思超_PostgreSQL10_hash索引的WAL日志修改版final 立即下载
Kubernetes下日志实时采集、存储与计算实践 立即下载
日志数据采集与分析对接 立即下载

相关镜像