DM Binary Installation and Deployment, Starting Synchronization Task, Reports MySQL Syntax Error

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

Original topic: DM binary 安装部署,启动同步任务,报mysql语法错误

| username: 南宫007

【TiDB Usage Environment】Production Environment / Testing / Poc
【TiDB Version】
【Reproduction Path】What operations were performed to cause the issue
/home/dm/dmctl/dmctl --master-addr=192.168.30.40:8261 query-status task1.yaml
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-01”,
“worker”: “worker1”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “shard_merge”,
“stage”: “Paused”,
“unit”: “Load”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 34019,
“ErrClass”: “load-unit”,
“ErrScope”: “not-set”,
“ErrLevel”: “high”,
“Message”: “”,
“RawCause”: “Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘config where Type = ‘tidb’ and name = ‘keyspace-name’’ at line 1”,
“Workaround”: “”
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“load”: {
“finishedBytes”: “0”,
“totalBytes”: “0”,
“progress”: “0.00 %”,
“metaBinlog”: “(mybinlog.000002, 154)”,
“metaBinlogGTID”: “”,
“bps”: “0”
},
“validation”: null
}

【Encountered Issues: Issue Phenomenon and Impact】
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】

| username: 裤衩儿飞上天 | Original post link

Remove the hyphen from the database name.

| username: 南宫007 | Original post link

There is no hyphen.

| username: 南宫007 | Original post link

I know the reason, it is related to the version. The 6.0.0 version does not have this problem, but the 6.5.1 version does.

| username: system | Original post link

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