-
【TiDB 版本】:5.7.25-TiDB-v3.0.5
-
【问题描述】:使用DM从mysql(版本5.7.24)实时同步10张表至tidb,同步中出现如下错误:
"subTaskStatus": [ { "name": "test", "stage": "Paused", "unit": "Sync", "result": { "isCanceled": false, "errors": [ { "Type": "ExecSQL", "msg": "[code=10006:class=database:scope=not-set:level=high] execute statement failed: REPLACE INTO `test`.`xxxxxx` (`id`,`order_id`,`user_id`,`channel`,.....) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);: cannot convert type: decimal.Decimal github.com/pingcap/dm/pkg/terror.(*Error).Delegate /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267 github.com/pingcap/dm/pkg/conn.(*BaseConn).ExecuteSQLWithIgnoreError /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:159 github.com/pingcap/dm/syncer.(*DBConn).executeSQLWithIgnore.func2 /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:257 github.com/pingcap/dm/pkg/retry.(*FiniteRetryStrategy).Apply /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/retry/strategy.go:71 github.com/pingcap/dm/pkg/conn.(*BaseConn).ApplyRetryStrategy /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:180 github.com/pingcap/dm/syncer.(*DBConn).executeSQLWithIgnore /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:252 github.com/pingcap/dm/syncer.(*DBConn).executeSQL /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:279 github.com/pingcap/dm/syncer.(*Syncer).sync.func3 /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:968 github.com/pingcap/dm/syncer.(*Syncer).sync /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1010 github.com/pingcap/dm/syncer.(*Syncer).Run.func2 /home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1079 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:1357", "error": null },
出现类型转换错误cannot convert type: decimal.Decimal,不知道是什么原因?mysql中这个表有两个字段是decimal类型,记录经纬度的。这张表数据目前已经同步完成90%以上的数据