DM Synchronization Error

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

Original topic: dm同步报错

| username: TiDBer_QHSxuEa1

An error occurred when using tiup dmctl --master-addr <master-addr> query-status. The query command was normal around 11 AM, but an error was found after noon.

The error in the dm-worker log is as follows:

[failed to update source status] [component="worker controller"] [error="[code=10001:class=database:scope=not-set:level=high]"], message: database driver error, RawCause: context deadline exceeded, workaround: please check the database connection and the database config in the configuration file.
| username: Jolyne | Original post link

Judging by the error, it seems like some configuration changes might have caused it.

| username: 这里介绍不了我 | Original post link

Based on this information, it seems that the data source cannot be connected. Check the configuration file.

| username: tidb菜鸟一只 | Original post link

Is there a problem with the data source?

| username: TiDBer_QHSxuEa1 | Original post link

The configuration hasn’t been changed, only the MySQL data source was restarted once.

| username: TiDBer_QHSxuEa1 | Original post link

A bit confused, not sure which configuration to look at :joy:

| username: TiDBer_QHSxuEa1 | Original post link

The data source had some issues, with a “too many connections” error in the morning, making it impossible to connect. We had no choice but to restart the MySQL service, and by noon, DM synchronization couldn’t be found.

| username: TiDBer_QYr0vohO | Original post link

There is an issue with the data source.

| username: zhaokede | Original post link

Have you checked the data source connection and network stability?

| username: dba远航 | Original post link

The prompt indicates a configuration error. Check if any changes in the configuration caused it.

| username: 随缘天空 | Original post link

It might be that your database has an issue and can’t connect. You can try using a client to connect.

| username: TiDBer_JUi6UvZm | Original post link

Just happened to be studying DM, paying attention.

| username: TiDBer_21wZg5fm | Original post link

Configuration issue?

| username: mono | Original post link

I think you need to use the operation and maintenance tool for this. Restarting the DM task should solve the problem. You can give it a try.

| username: Jolyne | Original post link

I suggest restarting the task. If the problem persists, maybe try deleting and recreating the same task?