canal olumn size is not match for table:,6 vs 5

一 问题描述

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