canal icon indicating copy to clipboard operation
canal copied to clipboard

canal 1.1.5版本 mysql 同步数据 到 es报错

Open gyy-bisontech opened this issue 1 year ago • 1 comments

canal 版本是用的 1.1.5 版本 现在从 mysql 同步到 es 的时候会重复打印下边这个log

2024-12-27 11:52:07.586 [destination = example , address = /192.168.31.13:3306 , 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
2024-12-27 11:52:07.587 [destination = example , address = /192.168.31.13:3306 , EventParser] WARN  c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - prepare to find start position just last position
 {"identity":{"slaveId":-1,"sourceAddress":{"address":"192.168.31.13","port":3306}},"postion":{"gtid":"","included":false,"journalName":"mysql-bin.000070","position":80194659,"serverId":1,"timestamp":1735268438000}}
2024-12-27 11:52:07.621 [destination = example , address = /192.168.31.13:3306 , EventParser] WARN  c.a.o.c.p.inbound.mysql.rds.RdsBinlogEventParserProxy - ---> find start position successfully, EntryPosition[included=false,journalName=mysql-bin.000070,position=80194659,serverId=1,gtid=,timestamp=1735268438000] cost : 35ms , the next step is binlog dump
2024-12-27 11:52:07.630 [MultiStageCoprocessor-Parser-example-0] ERROR com.alibaba.otter.canal.common.utils.NamedThreadFactory - from MultiStageCoprocessor-Parser-example-0
com.alibaba.otter.canal.parse.exception.CanalParseException: 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: 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_db.user_info,15 vs 14

gyy-bisontech avatar Dec 27 '24 04:12 gyy-bisontech

column size is not match for table:user_db.user_info,15 vs 14

dikeqin avatar Feb 10 '25 00:02 dikeqin