查询DTS任务预检查执行详情
更新时间 2026-06-16 16:54:06
最近更新时间: 2026-06-16 16:54:06
接口功能介绍
查询 DTS 任务预检查执行详情。
接口约束
无
URI
POST /dts/v2/open-api/instance/describeDtsJobPreCheckDetail
路径参数 无
Query参数 无
请求参数
请求头header参数
| 参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|---|
| regionId | 是 | String | 资源池id | 200000001790 |
请求体body参数
| 参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|---|
| dtsInstanceIds | 否 | Array of Strings | 实例id | ["dts_ins_001","dts_ins_002"] | |
| dtsJobId | 是 | Integer | 任务id | 100001 | |
| synchronizationDirection | 否 | String | Forward 正向 Reverse 反向，默认取值Forward，枚举值：Forward,Reverse | Forward |
响应参数
| 参数 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|
| httpStatusCode | Integer | 状态码 | 200 | |
| errCode | String | 错误码 | SUCCESS | |
| errMessage | String | 提示信息 | 操作成功 | |
| success | Boolean | 请求是否成功 | true | |
| requestId | String | 请求id | req-20250905-0001 | |
| data | Object | 响应数据 | PreCheckItemResult |
表 PreCheckItemResult
| 参数 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|
| status | String | 模块状态，枚举值：INIT (初始态),STARTING (启动中),RUNNING (运行中),FAIL (失败),STOP (暂停),RETRY (重试中),DONE (完成) | RUNNING | |
| moduleId | Integer | 模块id | ||
| planModuleType | String | 模块类型，枚举值：PRECHECK (预检查),STRUCT (前置结构迁移),POST_STRUCT (后置结构迁移),FULL (全量迁移),READER (增量读取),WRITER (增量写入),STORE (增量存储),INC_SERVICE (增量服务),MONITOR (监控上报),DATA_CHECK (数据稽查) | PRECHECK | |
| startTime | String | 模块开始时间 | ||
| finishTime | String | 模块结束时间 | ||
| preCheckItems | Array of Objects | 预检查明细 | PreCheckItem | |
| machineIp | String | 模块所在机器 |
表 PreCheckItem
| 参数 | 参数类型 | 说明 | 示例 | 下级对象 |
|---|---|---|---|---|
| id | Integer | id | ||
| planModuleId | Integer | planModuleId | ||
| name | String | name | ||
| content | String | content | ||
| result | String | result | ||
| message | String | message | ||
| solution | String | solution | ||
| gmtCreate | String | gmtCreate | ||
| gmtModified | String | gmtModified | ||
| haveRead | Boolean | haveRead |
枚举参数
无
请求示例
请求url
https://{host}/dts/v2/open-api/instance/describeDtsJobPreCheckDetail
请求头header
无
请求体body
{
"dtsJobId": 383
}
响应示例
{
"httpStatusCode": 200,
"success": true,
"requestId": "00-6a16e1c412779b250d235b5712093c4f-53f82e28156f909e-00",
"data": {
"status": "STARTING",
"moduleId": 1439,
"planModuleType": "PRECHECK",
"startTime": "2026-05-27T12:21:21.000+00:00",
"preCheckItems": [
{
"id": 4378,
"planModuleId": 1439,
"name": "gtid_mode参数检查",
"content": "检查源库gtid_mode参数是否为ON",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4377,
"planModuleId": 1439,
"name": "log_slave_updates参数检查",
"content": "检查源库的log_slave_updates参数是否为ON",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4364,
"planModuleId": 1439,
"name": "lower_case_table_names一致性检查",
"content": "检查源库和目标库的lower_case_table_names变量是否一致",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4372,
"planModuleId": 1439,
"name": "mysql版本检查",
"content": "检查源库和目标库的mysql版本是不是符合要求",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4384,
"planModuleId": 1439,
"name": "sql_mode参数一致性检查",
"content": "检查源库和目标库的sql_mode参数是否一致",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4382,
"planModuleId": 1439,
"name": "任务拓扑检查",
"content": "检查任务的迁移对象是否和历史任务一致",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4385,
"planModuleId": 1439,
"name": "同名对象存在性检查",
"content": "检查目标库中是否存在和待迁移库同名的库，若存在，检查该库下面是否存在同名的表、视图、函数和存储过程",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4386,
"planModuleId": 1439,
"name": "字符集检查",
"content": "检查待迁移库的字符集设置是否在要求范围内",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4373,
"planModuleId": 1439,
"name": "存储引擎检查",
"content": "检查源库中待迁移的表的存储引擎",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4370,
"planModuleId": 1439,
"name": "待迁移表唯一索引检查",
"content": "检查待迁移表是否都存在唯一索引",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4368,
"planModuleId": 1439,
"name": "源库binlog保留时间检查",
"content": "检查源库的binlog保留时间是否满足要求",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4381,
"planModuleId": 1439,
"name": "源库binlog存在性检查",
"content": "查看源库的binlog文件是否被误删除",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4376,
"planModuleId": 1439,
"name": "源库binlog影像类型检查",
"content": "查看源库的binlog_row_image参数是不是FULL",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4367,
"planModuleId": 1439,
"name": "源库binlog是否开启检查",
"content": "查看源库的log_bin参数是不是ON",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4383,
"planModuleId": 1439,
"name": "源库binlog模式检查",
"content": "查看源库的binlog_format参数是不是ROW",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4380,
"planModuleId": 1439,
"name": "源库server_id检查",
"content": "查看源库的server_id是否大于1",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4365,
"planModuleId": 1439,
"name": "源库和目标库时区一致性检查",
"content": "检查源库和目标库的时区设置的值是否一致",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4371,
"planModuleId": 1439,
"name": "源库权限检查",
"content": "检查源库的权限是否满足迁移需求",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4369,
"planModuleId": 1439,
"name": "源库连通性检查",
"content": "检查数据传输服务器能否连通源数据库",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4375,
"planModuleId": 1439,
"name": "目标库为天翼云RDS时，审计是否开启检查",
"content": "检查目标库RDS的审计选项对于DTS是否有风险",
"result": 3,
"message": "目标库RDS已开启审计，在迁移时可能会产生目标库异常导致迁移失败",
"solution": "请评估审计是否会影响迁移，或在控制台关闭目标库RDS的审计",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4379,
"planModuleId": 1439,
"name": "目标库日志包大小检查",
"content": "检查目标库的日志包大小是否符合要求",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4366,
"planModuleId": 1439,
"name": "目标库用户权限检查",
"content": "检查目标库的权限是否满足迁移需求",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
},
{
"id": 4374,
"planModuleId": 1439,
"name": "目标库连通性检查",
"content": "检查数据传输服务器能否连通目标数据库",
"result": 2,
"message": "",
"solution": "",
"gmtCreate": "2026-05-27T12:21:24.530+00:00",
"haveRead": false
}
],
"machineIp": "33.2.6.184"
}
}
状态码
请参考 状态码
错误码
请参考 错误码
