alibaba / canal

阿里巴巴 MySQL binlog 增量订阅&消费组件
Apache License 2.0
28.4k stars 7.59k forks source link

canal1.1.4,colun size is not match for table: , parse row data failed. #3279

Open hhaojin opened 3 years ago

hhaojin commented 3 years ago

canal1.1.4 解析数据异常,麻烦大佬帮忙看看,日志如下

Caused by;com alibaba otter canal,parse,exception,CanalParseException;colun size is not match for table:chungou Lives,cg orderthird,71 s 52。 Caused by:com.alibaba.otter.canal.parse.exception.CanalParseException:com.alibaba.otter.canal.parse.exception.CanalParseException:parse row data failed. CaNiad Ay:com.a\1aha.Sttar.canal-para.axcaption Cama\paraExc8pEin:Para.rg"date faid h for tableschumaou ties co order third.1 vs s2 be long time for reset or first position stamp":1609135566000}} 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:column size is not match for table:chungou lives.cg order third,7l vs 522020-12-28 14:07:15.372[destination=example,address=/192.168.88.130:3306,EventParser]ERROR c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserproxy-dump address 192.168.88.130/192.168.88.130:3306 ha on"atibaba.ofter.canat.parse.exception.CanalParseException:com.al ibaba.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:chungou_lives.cg order_third,71 vs 52K29·86CeP5A0]:FCORLPOTSSEXCOPT1OD38M:QLL209O:OEJG5:SOD2L:ROTSE:SXcepT1ON caDOLLeTSE XSStion:parse row data falled. Caused by:com.alibaba.otter.canal.parse.exception.CanalParseException:column size is not match for table:chungou_lives.cg_order_third,71 vs 52

wingerx commented 3 years ago

该表发生过字段变更的ddl,导致目前binlog所在位置找不到对应的表结构,先跳位点吧。

feison commented 3 years ago

今天也碰到了 我把这个配置 canal.instance.tsdb.enable 改成了false 就正常了