执行任务出现parse relay log file mysql-bin-xxxx from offset xxx invalid event size 0, must >= 19

为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:

【问题描述】
任务建立已经有一段时间,今早发现一台worker上多个任务都出现了异常,查询几个任务都显示如下错误信息
query-status task_densotde
{
“result”: true,
“msg”: “”,
“workers”: [
{
“result”: true,
“worker”: “10.0.6.147:8265”,
“msg”: “”,
“subTaskStatus”: [
{
“name”: “task_densotde”,
“stage”: “Paused”,
“unit”: “Sync”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“Type”: “UnknownError”,
“msg”: “”,
“error”: {
“ErrCode”: 11038,
“ErrClass”: 2,
“ErrScope”: 3,
“ErrLevel”: 3,
“Message”: “parse relay log file mysql-bin.000445 from offset 436498928 in dir /data/tidb_deploy_dm_worker11/relay_log/c9c22715-a84b-11e9-9455-00163e0eb304.000001: parse relay log file mysql-bin.000445 from offset 0 in dir /data/tidb_deploy_dm_worker11/relay_log/c9c22715-a84b-11e9-9455-00163e0eb304.000001: parse relay log file /data/tidb_deploy_dm_worker11/relay_log/c9c22715-a84b-11e9-9455-00163e0eb304.000001/mysql-bin.000445: invalid event size 0, must \u003e= 19”,
“RawCause”: “invalid event size 0, must \u003e= 19”
}
}
],
“detail”: null
},
“unresolvedDDLLockID”: “”,
“sync”: {
“totalEvents”: “0”,
“totalTps”: “0”,
“recentTps”: “0”,
“masterBinlog”: “(mysql-bin.000447, 596827801)”,
“masterBinlogGtid”: “”,
“syncerBinlog”: “(mysql-bin|000001.000445, 436498928)”,
“syncerBinlogGtid”: “”,
“blockingDDLs”: [
],
“unresolvedGroups”: [
],
“synced”: false
}
}
],
“relayStatus”: {
“masterBinlog”: “(mysql-bin.000447, 596827801)”,
“masterBinlogGtid”: “”,
“relaySubDir”: “c9c22715-a84b-11e9-9455-00163e0eb304.000001”,
“relayBinlog”: “(mysql-bin.000447, 596827801)”,
“relayBinlogGtid”: “00000000-0000-0000-0000-000000000000:0”,
“relayCatchUpMaster”: true,
“stage”: “Running”,
“result”: null
},
“sourceID”: “mysql-replica-11”
}
]
}

查看worker下binlog,目标binlog存在:
image

dump_data信息为节省磁盘空间已经清理了

另补充简短日志信息:
dm-worker.log (4.8 MB)
前一天分段的日志信息,文件较大已经压缩上传到云盘:
链接: 百度网盘-链接不存在 提取码: hkvx
请问下,产生这种问题原因是什么,并且如何解决

强烈建议提问前搜索一下,有相关 FAQ 的

好的,已经解决,binlog文件损坏了

:ok_hand:

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。