DM任务all模式load阶段完成了98%结果宕掉,如何续上?

【TiDB 使用环境】生产环境
【TiDB 版本】8.5.1
【操作系统】Rocky Linux 9.4
任务模式是all,全量同步到了load阶段完成了98%结果宕掉了,我要如何重启从原来的位置继续同步?

{
    "result": true,
    "msg": "",
    "sources": [
        {
            "result": true,
            "msg": "",
            "sourceStatus": {
                "source": "dm-source-tengshi",
                "worker": "worker6",
                "result": null,
                "relayStatus": {
                    "masterBinlog": "(mysql-bin.003415, 179013608)",
                    "masterBinlogGtid": "1f464583-5859-11ef-b0e5-1070fd877240:1-698015144",
                    "relaySubDir": "3be12f80-5859-11ef-8a58-b8cef6da051a.000010",
                    "relayBinlog": "(mysql-bin.003357, 137036263)",
                    "relayBinlogGtid": "",
                    "relayCatchUpMaster": false,
                    "stage": "Running",
                    "result": null
                }
            },
            "subTaskStatus": [
                {
                    "name": "dm-task-syc-tengshi",
                    "stage": "Paused",
                    "unit": "Sync",
                    "result": {
                        "isCanceled": false,
                        "errors": [
                            {
                                "ErrCode": 40067,
                                "ErrClass": "dm-worker",
                                "ErrScope": "internal",
                                "ErrLevel": "high",
                                "Message": "waiting for relay to catch up with loader is timeout (exceeding 30s), loader: (mysql-bin.003411, 375027780), relay: (mysql-bin.003357, 137036263)",
                                "RawCause": "",
                                "Workaround": ""
                            }
                        ],
                        "detail": null
                    },
                    "unresolvedDDLLockID": "",
                    "sync": {
                        "totalEvents": "0",
                        "totalTps": "0",
                        "recentTps": "0",
                        "masterBinlog": "(mysql-bin.003415, 179013608)",
                        "masterBinlogGtid": "1f464583-5859-11ef-b0e5-1070fd877240:1-698015144",
                        "syncerBinlog": "(, 4)",
                        "syncerBinlogGtid": "",
                        "blockingDDLs": [
                        ],
                        "unresolvedGroups": [
                        ],
                        "synced": false,
                        "binlogType": "local",
                        "secondsBehindMaster": "0",
                        "blockDDLOwner": "",
                        "conflictMsg": "",
                        "totalRows": "0",
                        "totalRps": "0",
                        "recentRps": "0"
                    },
                    "validation": null
                }
            ]
        }
    ]
}

需要判断下,全量数据是否已经同步完成,已经进阶到了 binlog 阶段

若binlog阶段后,出现断开,只用从 binlog flag 开始即可。

否则,需要重新全量同步,避免出现数据遗漏。


可以参考下官方文档:https://docs.pingcap.com/zh/tidb/stable/relay-log/#dm-接收-binlog-的位置

看看是否帮你解决问题

全量数据是否已经同步完成?如果全量没完成,只能重新开始全量,,,,避免数据遗漏,不能直接续接的啊。

好的。请问一下数据源或者任务的配置修改了之后如何重新加载。我看数据源好像没有重新加载的命令

我理解当前是在 sync 同步阶段了。看起来是拉 binlog 拉不到了?上游 MySQL 日志流程多久的?