查询DTS任务预检查执行详情(1) 枚举参数 无 请求示例 请求url 请求头header 无 请求体body { "dtsJobId": 383 } 响应示例 { "httpStatusCode": 200, "success": true, "requestId": "006a16e1c412779b250d235b5712093c4f53f82e28156f909e00", "data": { "status": "STARTING", "moduleId": 1439, "planModuleType": "PRECHECK", "startTime": "20260527T12:21:21.000+00:00", "preCheckItems": [ { "id": 4378, "planModuleId": 1439, "name": "gtidmode参数检查", "content": "检查源库gtidmode参数是否为ON", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4377, "planModuleId": 1439, "name": "logslaveupdates参数检查", "content": "检查源库的logslaveupdates参数是否为ON", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4364, "planModuleId": 1439, "name": "lowercasetablenames一致性检查", "content": "检查源库和目标库的lowercasetablenames变量是否一致", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4372, "planModuleId": 1439, "name": "mysql版本检查", "content": "检查源库和目标库的mysql版本是不是符合要求", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4384, "planModuleId": 1439, "name": "sqlmode参数一致性检查", "content": "检查源库和目标库的sqlmode参数是否一致", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4382, "planModuleId": 1439, "name": "任务拓扑检查", "content": "检查任务的迁移对象是否和历史任务一致", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4385, "planModuleId": 1439, "name": "同名对象存在性检查", "content": "检查目标库中是否存在和待迁移库同名的库,若存在,检查该库下面是否存在同名的表、视图、函数和存储过程", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4386, "planModuleId": 1439, "name": "字符集检查", "content": "检查待迁移库的字符集设置是否在要求范围内", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4373, "planModuleId": 1439, "name": "存储引擎检查", "content": "检查源库中待迁移的表的存储引擎", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4370, "planModuleId": 1439, "name": "待迁移表唯一索引检查", "content": "检查待迁移表是否都存在唯一索引", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4368, "planModuleId": 1439, "name": "源库binlog保留时间检查", "content": "检查源库的binlog保留时间是否满足要求", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4381, "planModuleId": 1439, "name": "源库binlog存在性检查", "content": "查看源库的binlog文件是否被误删除", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4376, "planModuleId": 1439, "name": "源库binlog影像类型检查", "content": "查看源库的binlogrowimage参数是不是FULL", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4367, "planModuleId": 1439, "name": "源库binlog是否开启检查", "content": "查看源库的logbin参数是不是ON", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4383, "planModuleId": 1439, "name": "源库binlog模式检查", "content": "查看源库的binlogformat参数是不是ROW", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4380, "planModuleId": 1439, "name": "源库serverid检查", "content": "查看源库的serverid是否大于1", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4365, "planModuleId": 1439, "name": "源库和目标库时区一致性检查", "content": "检查源库和目标库的时区设置的值是否一致", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4371, "planModuleId": 1439, "name": "源库权限检查", "content": "检查源库的权限是否满足迁移需求", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4369, "planModuleId": 1439, "name": "源库连通性检查", "content": "检查数据传输服务器能否连通源数据库", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4375, "planModuleId": 1439, "name": "目标库为天翼云RDS时,审计是否开启检查", "content": "检查目标库RDS的审计选项对于DTS是否有风险", "result": 3, "message": "目标库RDS已开启审计,在迁移时可能会产生目标库异常导致迁移失败", "solution": "请评估审计是否会影响迁移,或在控制台关闭目标库RDS的审计", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4379, "planModuleId": 1439, "name": "目标库日志包大小检查", "content": "检查目标库的日志包大小是否符合要求", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4366, "planModuleId": 1439, "name": "目标库用户权限检查", "content": "检查目标库的权限是否满足迁移需求", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false }, { "id": 4374, "planModuleId": 1439, "name": "目标库连通性检查", "content": "检查数据传输服务器能否连通目标数据库", "result": 2, "message": "", "solution": "", "gmtCreate": "20260527T12:21:24.530+00:00", "haveRead": false } ], "machineIp": "33.2.6.184" } }
来自: