开发者社区> 问答> 正文

Canal报找不到binlog file

2017-03-17 15:17:27.000 [destination = qbo , address = /10.0.0.68: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.000004 2017-03-17 15:17:27.005 [destination = qbo , address = /10.0.0.68:3306 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address /10.0.0.68:3306 has an error, retrying. caused by com.alibaba.otter.canal.parse.exception.CanalParseException: can't find start position for qbo 2017-03-17 15:17:27.008 [destination = qbo , address = /10.0.0.68:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:qbo[com.alibaba.otter.canal.parse.exception.CanalParseException: can't find start position for qbo ]

canal 版本 1.0.24 mysql版本 5.6.33

主库状态

mysql> show master status; +------------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+-------------------+ | mysql-bin.000004 | 1507 | | | | +------------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec)

完整日志在附件中 qbo.log.txt

原提问者GitHub用户GYWang1983

展开
收起
绿子直子 2023-05-09 15:20:56 194 0
1 条回答
写回答
取消 提交回答
  • 这异常是你指定的时间戳,比现在的任何binlog文件都早,调整一下位点

    原回答者GitHub用户agapple

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

相关电子书

更多
PolarDB-X 2.0 全局 Binlog 与备份恢复能 立即下载
低代码开发师(初级)实战教程 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载