Error in DM Synchronization

Translated
1

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

Original topic: dm同步出错

| username: wisdom

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed to cause the problem
【Problem Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module’s Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs from 1 hour before and after the problem)

“Message”: "mydumper/dumpling runs with error, with output (may be empty): ",
“RawCause”: “sql: FLUSH TABLES WITH READ LOCK: Error 1045: Access denied for user ‘root’@‘%’ (using password: YES)”,

image
image1400×433 9.56 KB

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results and upload them.

2
| username: ShawnYan | Original post link

Test environment, right? The password is incorrect.

3
| username: notebook385 | Original post link

The password is probably incorrect, or it contains special characters.

4
| username: db_user | Original post link

Incorrect password or permissions. Is the upstream a cloud database? Can you execute the flush tables command?

5
| username: cheng | Original post link

Check if your DM account does not have the “flush table with read lock” permission.

6
| username: buchuitoudegou | Original post link

It can be confirmed that it is a permissions issue because some precheck operations are performed using the provided username and password before exporting. Before the actual export (i.e., before the SQL in the image), Dumpling will attempt to connect to the database. If the username or password is incorrect, an error will be reported at that time.

7
| username: wisdom | Original post link

Unified reply, it is not caused by incorrect password or insufficient permissions.

8
| username: buchuitoudegou | Original post link

Could you please explain in detail? This way, other students who encounter the same situation will also know how to solve it. :pray:

9
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.