dm同步任务报错

🪐 TiDB 技术问题 备份&数据迁移
1 
[2020/05/06 18:20:54.493 +08:00] [INFO] [server.go:1913] ["wait op log result"] [task=db1_2_db2] [worker=10.24.74.100:8266] ["operation log ID"=27] [result="meta:<result:true > log:<id:27 task:<op:Stop name:\"db1_2_db2\" > ts:1588760441041826195 > "]

» stop-task db1_2_db2
{
    "op": "Stop",
    "result": true,
    "msg": "",
    "workers": [
        {
            "meta": {
                "result": false,
                "worker": "x.x.x.x:8266",
                "msg": "[code=38033:class=dm-master:scope=internal:level=high] request to dm-worker x.x.x.x:8266 is timeout, but request may be successful, please execute `query-status` to check status\
github.com/pingcap/dm/pkg/terror.(*Error).Generate\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232\
github.com/pingcap/dm/dm/master.(*Server).waitOperationOk\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1923\
github.com/pingcap/dm/dm/master.(*Server).handleOperationResult\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1946\
github.com/pingcap/dm/dm/master.(*Server).OperateTask.func2\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:368\
github.com/pingcap/dm/dm/master.(*AgentPool).Emit\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/agent_pool.go:117\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357"
            },
            "op": "Stop",
            "logID": "27"
        }
    ]
}

任务无法暂停和停止

» query-status db1_2_db2
{
    "result": true,
    "msg": "",
    "workers": [
        {
            "result": true,
            "worker": "x.x.x.x:8266",
            "msg": "",
            "subTaskStatus": [
                {
                    "name": "db1_2_db2",
                    "stage": "Stopped",
                    "unit": "Sync",
                    "result": null,
                    "unresolvedDDLLockID": "",
                    "sync": {
                        "totalEvents": "34686",
                        "totalTps": "0",
                        "recentTps": "0",
                        "masterBinlog": "(, 0)",
                        "masterBinlogGtid": "",
                        "syncerBinlog": "(mysql-bin.000090, 214503492)",
                        "syncerBinlogGtid": "",
                        "blockingDDLs": [
                        ],
                        "unresolvedGroups": [
                        ],
                        "synced": false
                    }
                }
            ],
            "relayStatus": {
                "masterBinlog": "(mysql-bin.000091, 51837190)",
                "masterBinlogGtid": "298296af-88f8-11ea-a558-6c92bf628694:1-7376985,889e9ef0-ffc5-11e9-a6b3-6c92bf64b8b2:1-50349629",
                "relaySubDir": "4f0810cd-88f8-11ea-a559-501d939ca186.000001",
                "relayBinlog": "(mysql-bin.000091, 51837190)",
                "relayBinlogGtid": "",
                "relayCatchUpMaster": true,
                "stage": "Running",
                "result": null
            },
            "sourceID": "db1_2_db2"
        }
    ]
}

» stop-task db1_2_db2
{
    "op": "Stop",
    "result": true,
    "msg": "",
    "workers": [
        {
            "meta": {
                "result": false,
                "worker": "x.x.x.x:8266",
                "msg": "[code=38033:class=dm-master:scope=internal:level=high] request to dm-worker x.x.x.x:8266 is timeout, but request may be successful, please execute `query-status` to check status\
github.com/pingcap/dm/pkg/terror.(*Error).Generate\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232\
github.com/pingcap/dm/dm/master.(*Server).waitOperationOk\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1923\
github.com/pingcap/dm/dm/master.(*Server).handleOperationResult\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1946\
github.com/pingcap/dm/dm/master.(*Server).OperateTask.func2\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:368\
github.com/pingcap/dm/dm/master.(*AgentPool).Emit\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/agent_pool.go:117\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357"
            },
            "op": "Stop",
            "logID": "28"
        }
    ]
}
2

你好，

请提供下 dm-worker 和 dm-master 错误日志，

可否详细描述下操作的细节。

3

找到原因 谢谢

4

你好，

:love_you_gesture:，可否分享下解决过程和原因，方便后面小伙伴搜索

5

8.0的mysql不支持

6

感谢反馈~

7

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