上游MySQL重装 DM无法同步

🪐 TiDB 技术问题 备份&数据迁移
1

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。

  • 【TiDB 版本】：v1.0.6

  • 【问题描述】：因上游MySQL损坏 源MySQL全部重装 binlog日志全部被删 然后重新安装mysql 配置同步 删除了 relay_log中的文件 dumped_data中的文件 启动DM报如下错误
    » query-status l-1002
    {
    “result”: true,
    “msg”: “”,
    “workers”: [
    {
    “result”: true,
    “worker”: “192.168.7.100:8264”,
    “msg”: “”,
    “subTaskStatus”: [
    {
    “name”: “l-1002”,
    “stage”: “Paused”,
    “unit”: “Load”,
    “result”: {
    “isCanceled”: false,
    “errors”: [

                          {
                          "Type": "UnknownError",
                          "msg": "",
                          "error": {
                              "ErrCode": 10006,
                              "ErrClass": 1,
                              "ErrScope": 2,
                              "ErrLevel": 3,
                              "Message": "restore data file (md.lab_result.sql) failed: initialize checkpoint: execute statement failed: begin: context canceled",
                              "RawCause": "context canceled"
                          }
                      },
                      {
                          "Type": "UnknownError",
                          "msg": "",
                          "error": {
                              "ErrCode": 10006,
                              "ErrClass": 1,
                              "ErrScope": 2,
                              "ErrLevel": 3,
                              "Message": "restore data file (md.orders.sql) failed: initialize checkpoint: execute statement failed: begin: driver: bad connection",
                              "RawCause": "driver: bad connection"
                          }
                      },
                     
                  ],
                  "detail": null
              },
              "unresolvedDDLLockID": "",
              "load": {
                  "finishedBytes": "0",
                  "totalBytes": "10720906",
                  "progress": "0.00 %",
                  "metaBinlog": "(mysql-bin.000001, 154)"
              }
          }
      ],
      "relayStatus": {
          "masterBinlog": "(mysql-bin.000001, 154)",
          "masterBinlogGtid": "",
          "relaySubDir": "2b0838d0-3e03-11eb-8d2d-20040fecfef3.000001",
          "relayBinlog": "(mysql-bin.000001, 154)",
          "relayBinlogGtid": "",
          "relayCatchUpMaster": true,
          "stage": "Running",
          "result": null
      },
      "sourceID": "replica-1002"

请问此类问题应该如何正常处理

若提问为性能优化、故障排查类问题，请下载脚本运行。终端输出的打印结果，请务必全选并复制粘贴上传。

2

如果要重置 DM 同步任务可以参考：
https://docs.pingcap.com/zh/tidb-data-migration/v1.0/faq#如何重置数据迁移任务

3

非常感谢您的指导 参照您的文档使用 修改任务配置文件以设置 remove-meta 为 true ，然后使用 start-task 重启迁移任务 解决问题

4

:+1::+1: