Error When Creating Data Source in DM

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

Original topic: dm创建数据源报错

| username: TiDBer_OB4kHrS7

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version] V5.2.2
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Issue Phenomenon and Impact] DM v5.3.2 reports an error when creating TiDB data source
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]
The data source is TiDB, and an error is reported when creating the data source using DM as follows:
[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”: [
]
}

| username: 啦啦啦啦啦 | Original post link

If the upstream is TiDB, then you should use TiCDC. DM is for migrating from MySQL to TiDB.

| username: TiDBer_OB4kHrS7 | Original post link

If there are such restrictions, then it can’t be done.

| username: 啦啦啦啦啦 | Original post link

Yes, with DM, the upstream must be MySQL or MariaDB. According to the error message, it seems that executing commands like SHOW SLAVE HOSTS resulted in an error, as this syntax is not supported.

| username: dba远航 | Original post link

The driver is not supported, indicating a version mismatch.