为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v1.0.4
- 【问题描述】: DM 同步分库分表上游两个库的表结构不一致导致 Column count doesn’t match value count
query-status shard_merge { “result”: true, “msg”: “”, “workers”: [ { “result”: true, “worker”: “192.168.179.101:8263”, “msg”: “”, “subTaskStatus”: [ { “name”: “shard_merge”, “stage”: “Paused”, “unit”: “Sync”, “result”: { “isCanceled”: false, “errors”: [ { “Type”: “UnknownError”, “msg”: “[code=36027:class=sync-unit:scope=internal:level=high] current pos (mysql-bin|000001.000009, 3836): gen update sqls failed, schema: test, table: t_test: Column count doesn’t match value count: 5 (columns) vs 4 (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\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357”, “error”: null } ], “detail”: null }, “unresolvedDDLLockID”: “”, “sync”: { “totalEvents”: “0”, “totalTps”: “0”, “recentTps”: “0”, “masterBinlog”: “(mysql-bin.000009, 5535)”, “masterBinlogGtid”: “”, “syncerBinlog”: “(mysql-bin|000001.000009, 3653)”, “syncerBinlogGtid”: “”, “blockingDDLs”: [ ], “unresolvedGroups”: [ ], “synced”: false } } ], “relayStatus”: { “masterBinlog”: “(mysql-bin.000009, 5535)”, “masterBinlogGtid”: “”, “relaySubDir”: “6584405c-57e6-11ea-a55f-000c2948ff10.000001”, “relayBinlog”: “(mysql-bin.000009, 5535)”, “relayBinlogGtid”: “”, “relayCatchUpMaster”: true, “stage”: “Running”, “result”: null }, “sourceID”: “instance-2” }, { “result”: true, “worker”: “192.168.179.101:8264”, “msg”: “”, “subTaskStatus”: [ { “name”: “shard_merge”, “stage”: “Paused”, “unit”: “Sync”, “result”: { “isCanceled”: false, “errors”: [ { “Type”: “UnknownError”, “msg”: “[code=36027:class=sync-unit:scope=internal:level=high] current pos (mysql-bin|000001.000002, 3661): gen update sqls failed, schema: test, table: t_test: Column count doesn’t match value count: 5 (columns) vs 4 (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\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357”, “error”: null } ], “detail”: null }, “unresolvedDDLLockID”: “”, “sync”: { “totalEvents”: “0”, “totalTps”: “0”, “recentTps”: “0”, “masterBinlog”: “(mysql-bin.000002, 6214)”, “masterBinlogGtid”: “”, “syncerBinlog”: “(mysql-bin|000001.000002, 3403)”, “syncerBinlogGtid”: “”, “blockingDDLs”: [ ], “unresolvedGroups”: [ ], “synced”: false } } ], “relayStatus”: { “masterBinlog”: “(mysql-bin.000002, 6214)”, “masterBinlogGtid”: “”, “relaySubDir”: “52a7aad6-6cd6-11ea-8068-f875a467c631.000001”, “relayBinlog”: “(mysql-bin.000002, 6214)”, “relayBinlogGtid”: “”, “relayCatchUpMaster”: true, “stage”: “Running”, “result”: null }, “sourceID”: “instance-3” } ] }
请问这种有什么解决办法?
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。