为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:3.0.5
- 【问题描述】:
dm同步过程中可能是因为大量skip-sql导致上游与下游数据库字段不一致,目前已经将下游tidb数据库表与mysql表手动同步一致。 resume-task后仍然报错字段长度不一致。 如何跳过改异常?
报错信息:
"Column count doesn't match value count: 49 (columns) vs 51 (values)\
github.com/pingcap/dm/syncer.genInsertSQLs\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/dml.go:120\
github.com/pingcap/dm/syncer.(*Syncer).handleRowsEvent\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1417\
github.com/pingcap/dm/syncer.(*Syncer).Run\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1224\
github.com/pingcap/dm/syncer.(*Syncer).Process\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:538\
github.com/pingcap/dm/syncer.(*Syncer).Resume\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:2191\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1337\
gen insert sqls failed,