DM synchronization task suddenly prompts "connection is already closed"

Translated
1

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

Original topic: dm同步任务突然提示connection is already closed

| username: Hacker007

Is this exception due to MySQL not being able to connect or TiDB not being able to connect? Other tasks have no issues.

2
| username: hey-hoho | Original post link

From the error message, it appears that the downstream TiDB connection failed. Please check the following issues:

  1. The load status of the TiDB cluster at that time.
  2. Permissions and password issues of the synchronization account.
  3. Is DM using load balancing to connect to TiDB, and are the connection timeout parameters sufficiently large?
3
| username: Hacker007 | Original post link

This task is configured with two data sources, both corresponding to the same MySQL (to simulate production without using MySQL). One of them is fine, but the other has issues. Now it has been changed to incremental synchronization, and there are no errors, but some data might be lost.

4
| username: system | Original post link

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