为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.8 DM V2.0
- 【问题描述】:源数据从mysql8.0.14全量+增量同步数据到TiDB集群中,全量同步完之后报错,现在无法实时同步数据。错误如下所示,ERROR 1236 (HY000): Could not find first log file name in binary log index file,请问要如何操作呢?
[root@localhost soft]# tiup dmctl --master-addr 192.168.137.135:8261 query-status mediamz
Starting component dmctl
: /root/.tiup/components/dmctl/v2.0.0/dmctl/dmctl --master-addr 192.168.137.135:8261 query-status mediamz
{
“result”: true,
“msg”: “”,
“sources”: [
{
“result”: true,
“msg”: “”,
“sourceStatus”: {
“source”: “mysql-replica-01”,
“worker”: “dm-192.168.137.135-8262”,
“result”: null,
“relayStatus”: null
},
“subTaskStatus”: [
{
“name”: “mediamz”,
“stage”: “Paused”,
“unit”: “Sync”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“ErrCode”: 50000,
“ErrClass”: “not-set”,
“ErrScope”: “not-set”,
“ErrLevel”: “high”,
“Message”: “ERROR 1236 (HY000): Could not find first log file name in binary log index file”,
“RawCause”: “”,
“Workaround”: “”
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“sync”: {
“totalEvents”: “0”,
“totalTps”: “0”,
“recentTps”: “0”,
“masterBinlog”: “(binlog.000001, 3532)”,
“masterBinlogGtid”: “”,
“syncerBinlog”: “(binlog.000001, 3532)”,
“syncerBinlogGtid”: “”,
“blockingDDLs”: [
],
“unresolvedGroups”: [
],
“synced”: true,
“binlogType”: “remote”
}
}
]
}
]
}
任务配置文件:dm-task.yaml (1.6 KB)
日志文件:dm-worker (2).log (41.8 KB)