DM 报错Column count doesn't match value

  • 【TiDB 版本】:DM 1.0.4版本
  • 【问题描述】:报错信息是Column count doesn’t match value count: 14 (columns) vs 15 (values) 但是我确认了下 上游的数据都14个字段 为啥会有15个呢

“result”: { “isCanceled”: false, “errors”: [ { “Type”: “UnknownError”, “msg”: “[code=36027:class=sync-unit:scope=internal:level=high] current pos (mysql-bin|000003.000880, 453050589): gen update sqls failed, schema: dtm_customer_service, table: dtm_user_order_customer: Column count doesn’t match value count: 14 (columns) vs 15 (values)\ngithub.com/pingcap/dm/pkg/terror.(*Error).Generate\n\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232\ngithub.com/pingcap/dm/syncer.genUpdateSQLs\n\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/dml.go:178\ngithub.com/pingcap/dm/syncer.(*Syncer).handleRowsEvent\n\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1511\ngithub.com/pingcap/dm/syncer.(*Syncer).Run\n\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1306\ngithub.com/pingcap/dm/syncer.(*Syncer).Process\n\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:599\ngithub.com/pingcap/dm/syncer.(*Syncer).Resume\n\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:2320\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357”,

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

请问下上游是否用阿里 RDS ?默认情况下有个隐式主键的设置,针对没有主键的表增加了隐式主键同步到 TiDB 会报如上的错,需要关掉这个设置。另外可以在论坛里搜索下,类似的问题和解决方案很多,可以参考下。

好的 谢谢你了

:ok_hand:,有问题环境开新帖继续讨论哦~