【 TiDB 使用环境`】测试环境
【 TiDB 版本】V5.4.0
【遇到的问题】
使用DM启动迁移任务，报错
[root@instance-8q00utxd dm]# tiup dmctl --master-addr 192.168.16.5:8261 query-status test
tiup is checking updates for component dmctl …
Starting component dmctl: /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl /root/.tiup/components/dmctl/v5.4.0/dmctl/dmctl --master-addr 192.168.16.5:8261 query-status test
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-01”,
“worker”: “dm-192.168.16.5-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “test”,
“stage”: “Paused”,
“unit”: “Dump”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 32001,
“ErrClass”: “dump-unit”,
“ErrScope”: “internal”,
“ErrLevel”: “high”,
“Message”: "mydumper/dumpling runs with error, with output (may empty): ",
“RawCause”: “sql: SELECT VARIABLE_NAME,VARIABLE_VALUE FROM information_schema.GLOBAL_STATUS LIMIT 1: Error 3167: The ‘INFORMATION_SCHEMA.GLOBAL_STATUS’ feature is disabled; see the documentation for ‘show_compatibility_56’”,
“Workaround”: “”
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“dump”: {
“totalTables”: “181”,
“completedTables”: 128,
“finishedBytes”: 5129972,
“finishedRows”: 55157,
“estimateTotalRows”: 1332347
}
}
]
}
]
}
根据提示已修改源端数据库show_compatibility_56兼容性问题,如下为源库信息
