DM Data Migration: Migration Task Paused Due to Upstream and Downstream Table Structure Adjustments, Error Code 10006

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

Original topic: DM数据迁移,因上下游调整表结构,导致DM迁移任务暂停,错误代码10006。

| username: 希希希望啊

[TiDB Usage Environment] Production Environment
[TiDB Version] 7.5.1
[Reproduction Path] DM data migration, task paused due to upstream and downstream table structure adjustments, error code 10006.
[Encountered Problem: Phenomenon and Impact]

  1. The resume-task operation is not feasible, which is understandable since the existing task has already encountered an error.
  2. After stop-task and then start-task, it still reports error 10006. Why doesn’t it reset the task but continues from the previous task? What’s the difference between stop and resume then?
  3. The final solution was to create a new task with a different name and start the new task to resolve the issue.
    [Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
    [Attachments: Screenshots/Logs/Monitoring]