When Mariadb enable-gtid=true, executing operation-source create failed

[together-wang]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do? If possible, provide a recipe for reproducing the error.

When Mariadb enable-gtid=true, executing operation-source create failed

2. What did you expect to see?

3. What did you see instead?

[tidb@node5172 conf]$ tiup dmctl  --master-addr 172.16.5.172:8361 operate-source create ./mariadb_source.yaml 
Starting component `dmctl`: /home/tidb/.tiup/components/dmctl/v2.0.0/dmctl/dmctl --master-addr 172.16.5.172:8361 operate-source create ./mariadb_source.yaml
{
    "result": false,
    "msg": "[code=10001:class=database:scope=not-set:level=high], Message: database driver error, RawCause: sql: no rows in result set, Workaround: Please check the database connection and the database config in configuration file.",
    "sources": [
    ]
}

[tidb@node5172 conf]$ cat ./mariadb_source.yaml 
source-id: "mysql-replica-02"
enable-gtid: true

from:
  host: "172.16.5.127"
  port: 3306
  user: "root"
  password: "password"

4. Versions of the cluster

[tidb@node5172 conf]$ tiup dm display dm1               
Starting component `dm`: /home/tidb/.tiup/components/dm/v1.2.5/tiup-dm display dm1
Cluster type:    dm
Cluster name:    dm1
Cluster version: v2.0.0
SSH type:        builtin
ID                 Role        Host          Ports      OS/Arch       Status     Data Dir                           Deploy Dir
--                 ----        ----          -----      -------       ------     --------                           ----------
172.16.5.172:8361  dm-master   172.16.5.172  8361/8391  linux/x86_64  Healthy|L  /tidb/dmwang-data/dm-master-8361   /tidb/dmwang-deploy/dm-master-8361
172.16.4.107:8262  dm-worker   172.16.4.107  8262       linux/x86_64  Free       /tidb/dmwang-data/dm-worker-8262   /tidb/dmwang-deploy/dm-worker-8262
172.16.4.107:3330  grafana     172.16.4.107  3330       linux/x86_64  Up         -                                  /tidb/dmwang-deploy/grafana-3330
172.16.4.107:9390  prometheus  172.16.4.107  9390       linux/x86_64  Up         /tidb/dmwang-data/prometheus-9390  /tidb/dmwang-deploy/prometheus-9390
Total nodes: 4

• Upstream MySQL/MariaDB server version:

[email protected] :(none)>select version();
+-----------------+
| version()       |
+-----------------+
| 10.1.48-MariaDB |
+-----------------+
1 row in set (0.00 sec)

5. current status of DM cluster (execute query-status in dmctl)

6. Operation logs

   • Please upload dm-worker.log for every DM-worker instance if possible
   • Please upload dm-master.log if possible
   • Other interesting logs
   • Output of dmctl's commands with problems

7. Configuration of the cluster and the task

   • dm-worker.toml for every DM-worker instance if possible
   • dm-master.toml for DM-master if possible
   • task config, like task.yaml if possible
   • inventory.ini if deployed by DM-Ansible

8. Screenshot/exported-PDF of Grafana dashboard or metrics' graph in Prometheus for DM if possible