Error in DDL during DM data synchronization, using binlog skip to bypass the error

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

Original topic: dm同步数据的时候 ddl出错,用binlog skip跳过报错

| username: TiDBer_8mpI7QNz

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] Error occurs during dm data synchronization when executing ddl, using binlog skip to bypass the error
[Encountered Problem: Error occurs during dm data synchronization when executing ddl, using binlog skip to bypass the error]
[Resource Configuration] Navigate to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]

[root@iZ2vcbak4zdvl88razdo1rZ DM]# tiup dmctl --master-addr 127.0.0.1:8261 query-status testdm
Starting component dmctl: /root/.tiup/components/dmctl/v7.6.0/dmctl/dmctl --master-addr 127.0.0.1:8261 query-status testdm
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-02”,
“worker”: “dm-172.25.16.53-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “testdm”,
“stage”: “Paused”,
“unit”: “Load”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 50000,
“ErrClass”: “not-set”,
“ErrScope”: “not-set”,
“ErrLevel”: “high”,
“Message”: “[parser:1115]Unknown character set: ‘utf16’”,
“RawCause”: “”,
“Workaround”: “”
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“load”: {
“finishedBytes”: “0”,
“totalBytes”: “0”,
“progress”: “0.00 %”,
“metaBinlog”: “(mysql-bin.002428, 206670041)”,
“metaBinlogGTID”: “”,
“bps”: “0”
},
“validation”: null
}
]
}
]
}
[root@iZ2vcbak4zdvl88razdo1rZ DM]# tiup dmctl --master-addr 127.0.0.1:8261 binlog skip testdm
Starting component dmctl: /root/.tiup/components/dmctl/v7.6.0/dmctl/dmctl --master-addr 127.0.0.1:8261 binlog skip testdm
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: false,
“msg”: “[code=40056:class=dm-worker:scope=internal:level=high], Message: such operation is only available for syncer, but now syncer is not running. current unit is Load”,
“source”: “mysql-02”,
“worker”: “”
}
]
}
[root@iZ2vcbak4zdvl88razdo1rZ DM]# tiup dmctl --master-addr 127.0.0.1:8261 binlog skip testdm
Starting component dmctl: /root/.tiup/components/dmctl/v7.6.0/dmctl/dmctl --master-addr 127.0.0.1:8261 binlog skip testdm
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: false,
“msg”: “[code=40056:class=dm-worker:scope=internal:level=high], Message: such operation is only available for syncer, but now syncer is not running. current unit is Load”,
“source”: “mysql-02”,
“worker”: “”
}
]
}

| username: hey-hoho | Original post link

Refer to this, same issue

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

The load phase failed, it hasn’t reached the binlog phase yet, so binlog skip can’t be used. It should be due to unsupported character sets. You can try creating the downstream table first.

| username: system | Original post link

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