【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
【复现路径】dm同步数据的时候 ddl出错，用binlog skip跳过报错
【遇到的问题：dm同步数据的时候 ddl出错，用binlog skip跳过报错】
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件：截图/日志/监控】
[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”: “”
}
]
}