DM synchronization tasks frequently interrupted

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

Original topic: dm同步任务经常中断

| username: Hacker007

The dm-worker_stdout.log logs this message every few minutes, what’s going on?

| username: Meditator | Original post link

Does the upstream MySQL have a scheduled “abnormal” connection kill?

| username: wisdom | Original post link

What is the task status of dm query-status?

| username: Hacker007 | Original post link

Later, I found the cause. It was due to frequent data modifications in the upstream database, possibly because the DM buffer was insufficient. It has been fixed now.

| username: Hacker007 | Original post link

The status is normal, but the binlog drift point is not keeping up with the upstream. This was caused by frequent data modifications upstream and has been fixed.

| username: Hacker007 | Original post link

You can see frequent delete and insert statements being logged in the dm-worker.log file.

| username: system | Original post link

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