dm部署报错

【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】做过哪些操作出现的问题
【遇到的问题:问题现象及影响】
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】

Checking updates for component dmctl… Timedout (after 2s)
Starting component dmctl: /root/.tiup/components/dmctl/v7.5.0/dmctl/dmctl query-status ./sync.yaml --master-addr 10.8.0.220:8261
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-01”,
“worker”: “dm-10.8.0.220-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “test”,
“stage”: “Running”,
“unit”: “Sync”,
“result”: null,
“unresolvedDDLLockID”: “”,
“sync”: {
“totalEvents”: “16”,
“totalTps”: “0”,
“recentTps”: “0”,
“masterBinlog”: “(mysql-bin-changelog.031508, 26970784)”,
“masterBinlogGtid”: “21e02bb3-48b6-38d2-9839-148a6cd05851:1-8290975”,
“syncerBinlog”: “(mysql-bin-changelog.031508, 26970784)”,
“syncerBinlogGtid”: “21e02bb3-48b6-38d2-9839-148a6cd05851:1-8290975”,
“blockingDDLs”: [
],
“unresolvedGroups”: [
],
“synced”: true,
“binlogType”: “remote”,
“secondsBehindMaster”: “0”,
“blockDDLOwner”: “”,
“conflictMsg”: “”,
“totalRows”: “16”,
“totalRps”: “0”,
“recentRps”: “0”
},
“validation”: null
}
]
},
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-replica-01”,
“worker”: “dm-10.8.0.218-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “test”,
“stage”: “Paused”,
“unit”: “Load”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 34019,
“ErrClass”: “load-unit”,
“ErrScope”: “internal”,
“ErrLevel”: “high”,
“Message”: “”,
“RawCause”: “[Lightning:Restore:ErrCreateSchema]create schema failed, table: db_target., stmt: restore database schema: run create schema job failed: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'utf8mb4_0900_ai_ci'", "Workaround": "" } ], "detail": null }, "unresolvedDDLLockID": "", "load": { "finishedBytes": "0", "totalBytes": "0", "progress": "0.00 %", "metaBinlog": "(mysql-bin-changelog.031508, 26970784)", "metaBinlogGTID": "21e02bb3-48b6-38d2-9839-148a6cd05851:1-8290975", "bps": "0" }, "validation": null } ] }, { "result": true, "msg": "", "sourceStatus": { "source": "mysql-replica-02", "worker": "dm-10.8.0.149-8262", "result": null, "relayStatus": null }, "subTaskStatus": [ { "name": "test", "stage": "Paused", "unit": "Load", "result": { "isCanceled": false, "errors": [ { "ErrCode": 34019, "ErrClass": "load-unit", "ErrScope": "internal", "ErrLevel": "high", "Message": "", "RawCause": "[Lightning:Restore:ErrCreateSchema]create schema failed, table: `db_target`., stmt: restore database schema: run create schema job failed: Error 1273 (HY000): Unsupported collation when new collation is enabled: ‘utf8mb4_0900_ai_ci’”,
“Workaround”: “”
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“load”: {
“finishedBytes”: “0”,
“totalBytes”: “0”,
“progress”: “0.00 %”,
“metaBinlog”: “(mysql-bin-changelog.031508, 26970784)”,
“metaBinlogGTID”: “21e02bb3-48b6-38d2-9839-148a6cd05851:1-8290975”,
“bps”: “0”
},
“validation”: null
}
]
}
]
}

我这个mysql是8.0的 默认就报错

现在还不支持这个检验规则,初始化手工做下,建一个增量的同步任务吧

还不是完全兼容mysql 8.0

上下游的表db_target中,collation 字符集可能不一样。
可以考虑跳过这个table schema的检查。

https://docs.pingcap.com/zh/tidb/stable/dm-precheck#可忽略检查项

table_schema 检查上游 MySQL 表结构的兼容性

表结构自己导一下吧,把utf8mb4_0900_ai_ci改成utf8mb4_general_ci

排序规则不支持

“RawCause”: “[Lightning:Restore:ErrCreateSchema]create schema failed, table: db_target ., stmt: restore database schema: run create schema job failed: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'utf8mb4_0900_ai_ci'", "Workaround": "" } ], "detail": null }, "unresolvedDDLLockID": "", "load": { "finishedBytes": "0", "totalBytes": "0", "progress": "0.00 %", "metaBinlog": "(mysql-bin-changelog.031508, 26970784)", "metaBinlogGTID": "21e02bb3-48b6-38d2-9839-148a6cd05851:1-8290975", "bps": "0" }, "validation": null } ] }, { "result": true, "msg": "", "sourceStatus": { "source": "mysql-replica-02", "worker": "dm-10.8.0.149-8262", "result": null, "relayStatus": null },

表的字符集不一样。手动处理,或是忽略掉检查就可以
https://docs.pingcap.com/zh/tidb/stable/dm-precheck#可忽略检查项

标准答案

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。