DM 报错Column count doesn't match value

[yalisiyi]

• 【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\ \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\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/dml.go:178\ github.com/pingcap/dm/syncer.(*Syncer).handleRowsEvent\ \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\ \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\ \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\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:2320\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357”,

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

[不懂就问 (zhouyueyue)]

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

[yalisiyi]

好的 谢谢你了

[来了老弟]

，有问题环境开新帖继续讨论哦~