Error in DM Deployment

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dm部署报错

| username: tidb狂热爱好者

【TiDB Usage Environment】Production Environment / Test / Poc
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: Issue Phenomenon and Impact】
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots / Logs / Monitoring】

Checking updates for component dmctl… Timed out (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
}
]
}
]
}

| username: tidb狂热爱好者 | Original post link

My MySQL is version 8.0, and it reports an error by default.

| username: 小龙虾爱大龙虾 | Original post link

Currently, this validation rule is not supported. Please initialize it manually and create an incremental synchronization task.

| username: 小龙虾爱大龙虾 | Original post link

Not fully compatible with MySQL 8.0 yet.

| username: 有猫万事足 | Original post link

The collation character sets of the upstream and downstream tables db_target might be different. You can consider skipping the table schema check.

table_schema: Checks the compatibility of the upstream MySQL table structure.

| username: tidb菜鸟一只 | Original post link

You should export the table structure yourself and change utf8mb4_0900_ai_ci to utf8mb4_general_ci.

| username: dba远航 | Original post link

Collation is not supported.

| username: Inkjade | Original post link

The character sets of the tables are different. You can handle it manually or ignore the check.
https://docs.pingcap.com/zh/tidb/stable/dm-precheck#可忽略检查项

| username: 哈喽沃德 | Original post link

Standard answer

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.