为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:3.0.5
- 【问题描述】:
dm同步主键冲突如何查看那个表的主键冲突
日志和界面报错信息均无打印具体表信息
query-status test_tidb
{
"result": true,
"msg": "",
"workers": [
{
"result": true,
"worker": "192.168.10.101:8265",
"msg": "",
"subTaskStatus": [
{
"name": "test_tidb",
"stage": "Paused",
"unit": "Sync",
"result": {
"isCanceled": false,
"errors": [
{
"Type": "ExecSQL",
"msg": "Error 1292: invalid time format: '1'\
github.com/pingcap/errors.AddStack\
\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\
github.com/pingcap/errors.Trace\
\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\
github.com/pingcap/dm/syncer.(*Conn).executeSQLJobImp\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:237\
github.com/pingcap/dm/syncer.(*Conn).executeSQLJob\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:196\
github.com/pingcap/dm/syncer.(*Syncer).sync.func3\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:850\
github.com/pingcap/dm/syncer.(*Syncer).sync\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:935\
github.com/pingcap/dm/syncer.(*Syncer).Run.func2\
\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1013\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1337"
}
],
"detail": null
},
"unresolvedDDLLockID": "",
"sync": {
"totalEvents": "2498486",
"totalTps": "793",
"recentTps": "0",
"masterBinlog": "(db1m-bin.000046, 820805380)",
"masterBinlogGtid": "",
"syncerBinlog": "(db1m-bin|000001.000046, 798554517)",
"syncerBinlogGtid": "",
"blockingDDLs": [
],
"unresolvedGroups": [
],
"synced": false
}
}
],
"relayStatus": {
"masterBinlog": "(db1m-bin.000046, 820805380)",
"masterBinlogGtid": "",
"relaySubDir": "07777bc0-9dd1-11e7-9d49-000c29652500.000001",
"relayBinlog": "(db1m-bin.000046, 820805380)",
"relayBinlogGtid": "",
"relayCatchUpMaster": true,
"stage": "Running",
"result": null
},
"sourceID": "mysql4"
}
]
}
dm-work.log
[2020/04/13 18:04:10.901 +08:00] [WARN] [syncer.go:571] ["something wrong with rollback global checkpoint"] [task=test_tidb] [unit="binlog replication"] ["previous position"="(db1m-bin|000001.000046, 798607937)"] ["current position"="(db1m-bin|000001.000046, 798555298)"]
[2020/04/13 18:04:10.902 +08:00] [INFO] [subtask.go:243] ["unit process returned"] [subtask=test_tidb] [unit=Sync] [stage=Paused] [status="{\"totalEvents\":2794208,\"totalTps\":793,\"masterBinlog\":\"(db1m-bin.000046, 823169177)\",\"syncerBinlog\":\"(db1m-bin|000001.000046, 798555298)\"}"]
[2020/04/13 18:04:10.902 +08:00] [ERROR] [subtask.go:262] ["unit process error"] [subtask=test_tidb] [unit=Sync] ["error information"="{\"Type\":1,\"msg\":\"Error 1292: invalid time format: '2'\\
github.com/pingcap/errors.AddStack\\
\\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/errors.go:174\\
github.com/pingcap/errors.Trace\\
\\t/go/pkg/mod/github.com/pingcap/errors@v0.11.4/juju_adaptor.go:15\\
github.com/pingcap/dm/syncer.(*Conn).executeSQLJobImp\\
\\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:237\\
github.com/pingcap/dm/syncer.(*Conn).executeSQLJob\\
\\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:196\\
github.com/pingcap/dm/syncer.(*Syncer).sync.func3\\
\\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:850\\
github.com/pingcap/dm/syncer.(*Syncer).sync\\
\\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:935\\
github.com/pingcap/dm/syncer.(*Syncer).Run.func2\\
\\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1013\\
runtime.goexit\\
\\t/usr/local/go/src/runtime/asm_amd64.s:1337\"}"]