【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】V5.2.2
【复现路径】做过哪些操作出现的问题
【遇到的问题：问题现象及影响】DM v5.3.2 创建tidb数据源报错
【资源配置】
【附件：截图/日志/监控】
数据源为tidb 用dm创建数据源时报错如下
[tidb@production source]$ cat tidb_history.yaml
source-id: “tidb_history”
enable-gtid: true
from:
host: “10.8.123.9”
port: 4000
user: “tidb_query”
password: “XXXXXXX”
relay log purge strategy
purge:
interval: 3600
expires: 24
remain-space: 15
[tidb@production source]$ tiup dmctl --master-addr 10.8.94.18:8261 operate-source create tidb_history.yaml
tiup is checking updates for component dmctl …
Starting component dmctl: /home/tidb/.tiup/components/dmctl/v5.3.2/dmctl/dmctl --master-addr 10.8.94.18:8261 operate-source create tidb_history.yaml
{
“result”: false,
“msg”: “[code=10001:class=database:scope=upstream:level=high], Message: database driver error, RawCause: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 10 near "SLAVE HOSTS" , Workaround: Please check the database connection and the database config in configuration file.”,
“sources”: [
]
}