一 问题描述
canal同步报错:
2021-03-29 14:50:12.340 [MultiStageCoprocessor-Parser-kf-canalServer-GTM-TQMS-1] ERROR com.alibaba.otter.canal.common.utils.NamedThreadFactory - from MultiStageCoprocessor-Parser-kf-canalServer-GTM-TQMS-1
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:tqms.questions_cmextensionattr,6 vs 5
二 解决办法
关闭canal server
删除canal server上该instance的h2.mv.db文件(清除canal对表结构的缓存)
启动canal server