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: 
|
username: 
|
username: