开发者社区> 问答> 正文

求解:解析binlog抛出异常 column size is not match for table

使用版本 canal.deployer-1.1.3-SNAPSHOT.tar.gz 异常信息: 2019-02-15 10:35:36.342 [destination = test , address = /172.17.139.231:3366 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> begin to find start position, it will be long time for reset or first position 2019-02-15 10:35:36.343 [destination = test , address = /172.17.139.231:3366 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - prepare to find start position just last position {"identity":{"slaveId":-1,"sourceAddress":{"address":"172.17.139.231","port":3366}},"postion":{"gtid":"","included":false,"journalName":"mysql-bin.001303","position":523652,"serverId":1877583954,"timestamp":1550138420000}} 2019-02-15 10:35:36.353 [destination =test , address = /172.17.139.231:3366 , EventParser] WARN c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.001303,position=523652,serverId=1877583954,gtid=,timestamp=1550138420000] cost : 11ms , the next step is binlog dump 2019-02-15 10:35:36.496 [destination = test , address = /172.17.139.231:3366 , EventParser] ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - dump address 172.17.139.231/172.17.139.231:3366 has an error, retrying. caused by com.alibaba.otter.canal.parse.exception.CanalParseException: com.alibaba.otter.canal.parse.exception.CanalParseException: parse row data failed. Caused by: com.alibaba.otter.canal.parse.exception.CanalParseException: parse row data failed. Caused by: com.alibaba.otter.canal.parse.exception.CanalParseException: column size is not match for table:user.test_user,30 vs 27

biglog部分信息:

提问246.png

源码:

提问247.png

没搞懂是怎么回事?是否会影响数据同步?

原提问者GitHub用户zwh201806

展开
收起
古拉古拉 2023-05-08 14:22:48 225 0
1 条回答
写回答
取消 提交回答
  • 报错的意思,是指binlog里DML数据的表的列信息 要比 TableMeta里获取到的列信息要多,确认下是否有开启TableMeta TSDB的功能

    原回答者GitHub用户agapple

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

相关电子书

更多
神龙云服务器产品及技术深度解析 立即下载
弹性创造价值:基于ECS的最佳性价比实践解析 立即下载
又快又稳:阿里云下一代虚拟交换机解析 立即下载

相关镜像