数据复制服务 DRS-查询租户任务列表:响应示例

时间:2024-05-13 09:09:57

响应示例

状态码: 200

OK

  • 查询实时迁移任务列表响应示例 :
    {
      "jobs" : [ {
        "id" : "24834eb6-be30-464e-a299-f7aa730jb101",
        "name" : "DRS-3999-lws",
        "status" : "INCRE_TRANSFER_FAILED",
        "description" : "",
        "create_time" : "2020-12-21 10:57:49",
        "error_msg" : "service LOGMANAGER failed, cause by: Unable to connect to DBMS: url=jdbc:mysql://172.22.74.56:3306?useUnicode=true&allowLoadLocalInfile=false&characterEncoding=UTF-8&connectTimeout=5000&useSSL=false&allowPublicKeyRetrieval=true&verifyServerCertificate=false&serverTimezone=UTC user=root",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "migration",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action":{
            "available_actions": [
                "CREATE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "FREE_RESOURCE",
                "MODIFY_DB_CONFIG",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "RETRY",
                "RESET",
             ],
             "unavailable_actions": [
                 "START",
                 "CHANGE",
                 "DELETE",
                 "QUERY_PRE_CHECK",
                 "SWITCH_OVER",
                 "MODIFY_SPECIFICATION_ID",
                 "START_INCR",
                 "MODIFY_TASK_NUMBER",
                 "CONTINUE_JOB",
                 "STOP_JOB",
                 "CONTINUE_CAPTURE",
                 "STOP_CAPTURE",
                 "CONTINUE_APPLY",
                 "API_CONFIGURATION_ACTION",
                 "STOP_APPLY",
                 "PAY_ORDER",
                 "UNSUBSCRIBE",
                 "TO_PERIOD",
                 "TO_RENEW",
                 "ORDER_INFO",
                 "CHANGE_FLAVOR",
                 "CLONE"
             ]
        }    
      }, {
        "id" : "140b5236-88ad-43c8-811c-1268453jb101",
        "name" : "DRS-0042-linxiaolu",
        "status" : "CONFIGURATION",
        "description" : "",
        "create_time" : "2020-12-19 16:23:24",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "migration",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "FREE_RESOURCE",
                "MODIFY_DB_CONFIG",
                "API_CONFIGURATION_ACTION"
            ],
            "unavailable_actions": [
                "RETRY",
                "RESET",
                "DELETE",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR",
                 "CLONE"
             ]
         }
      }, {
        "id" : "7f8e6f74-72d2-4ddd-bb8f-6c41397jb101",
        "name" : "DRS-0796",
        "status" : "RELEASE_RESOURCE_COMPLETE",
        "description" : "",
        "create_time" : "2020-12-18 10:48:11",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "non-dbs",
        "db_use_type" : "migration",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "DELETE",
                "PRE_CHECK",
                "CHANGE_MODE",
                "MODIFY_DB_CONFIG",
                "CLONE"
            ],
            "unavailable_actions": [
                "FREE_RESOURCE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "RETRY",
                "RESET",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR"
             ]
         }
      }, {
        "id" : "14d88eeb-ee7e-4d30-a46e-a5ec8eajb101",
        "name" : "masj-mysql_migration_down-1",
        "status" : "INCRE_TRANSFER_STARTED",
        "description" : "[using] api test 2\n1. 本接口是用来配置源库/目标库信息的,选表前必须执行\n2. 配置中的任务修改描述信息成功,202 success\n3. 增量迁移中的任务修改描述信息失败,202 failed DRS.M01504\nAnother operation is being performed on the migration task or the migration task is abnormal. Try again later./",
        "create_time" : "2020-12-15 15:43:02",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : true,
        "job_direction" : "down",
        "db_use_type" : "migration",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action":{
            "available_actions": [
                 "CREATE",
                 "CHOOSE_OBJECT",
                 "PRE_CHECK",
                 "CHANGE_MODE",
                 "FREE_RESOURCE",
                 "MODIFY_DB_CONFIG",
                 "RESET_DB_PWD",
                 "MODIFY_CONFIGURATION",
                 "PAUSE",
             ],
            "unavailable_actions": [
                 "START",
                 "RETRY",
                 "RESET",
                 "CHANGE",
                 "DELETE",
                 "QUERY_PRE_CHECK",
                 "SWITCH_OVER",
                 "MODIFY_SPECIFICATION_ID",
                 "START_INCR",
                 "MODIFY_TASK_NUMBER",
                 "CONTINUE_JOB",
                 "STOP_JOB",
                 "CONTINUE_CAPTURE",
                 "STOP_CAPTURE",
                 "CONTINUE_APPLY",
                 "API_CONFIGURATION_ACTION",
                 "STOP_APPLY",
                 "PAY_ORDER",
                 "UNSUBSCRIBE",
                 "TO_PERIOD",
                 "TO_RENEW",
                 "ORDER_INFO",
                 "CHANGE_FLAVOR",
                 "CLONE"
             ]
        }    
      }, {
        "id" : "d54691d2-f105-434d-a75d-809b017jb101",
        "name" : "masj-2-mysql_migration_down",
        "status" : "CONFIGURATION",
        "description" : "[using] api test 2\n1. 本接口是用来配置源库/目标库信息的,选表前必须执行\n2. 配置中的任务修改描述信息成功,202 success\n3. 增量迁移中的任务修改描述信息失败,202 failed DRS.M01504\nAnother operation is being performed on the migration task or the migration task is abnormal. Try again later./",
        "create_time" : "2020-12-14 21:39:07",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "down",
        "db_use_type" : "migration",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "FREE_RESOURCE",
                "MODIFY_DB_CONFIG",
                "API_CONFIGURATION_ACTION"
            ],
            "unavailable_actions": [
                "RETRY",
                "RESET",
                "DELETE",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR",
                 "CLONE"
             ]
         }
      } ],
      "total_record" : 7
    }
  • 查询实时同步任务列表示例 :
    {
      "jobs" : [ {
        "id" : "7994aac9-0a15-4fdb-bcc5-667f088jb20b",
        "name" : "DRS-8200",
        "status" : "CREATE_FAILED",
        "description" : "",
        "create_time" : "2020-12-21 18:02:36",
        "error_msg" : "system error!",
        "engine_type" : "oracle-to-mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "sync",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "DELETE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "MODIFY_DB_CONFIG",
                "API_CONFIGURATION_ACTION"
            ],
            "unavailable_actions": [
                "FREE_RESOURCE",
                "RETRY",
                "RESET",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR",
                 "CLONE"
             ]
         }
      }, {
        "id" : "f463331d-e079-4689-bbef-4553202jb20b",
        "name" : "DRS-1285",
        "status" : "CONFIGURATION",
        "description" : "",
        "create_time" : "2020-12-21 17:19:38",
        "engine_type" : "oracle-to-mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "sync",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "FREE_RESOURCE",
                "MODIFY_DB_CONFIG",
                "API_CONFIGURATION_ACTION"
            ],
            "unavailable_actions": [
                "RETRY",
                "RESET",
                "DELETE",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR",
                 "CLONE"
             ]
         }
      }, {
        "id" : "7f13c511-c35b-4f82-92ae-83bcbf0jb201",
        "name" : "DRS-9383",
        "status" : "CONFIGURATION",
        "description" : "",
        "create_time" : "2020-12-21 17:18:44",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "sync",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "FREE_RESOURCE",
                "MODIFY_DB_CONFIG",
                "API_CONFIGURATION_ACTION"
            ],
            "unavailable_actions": [
                "RETRY",
                "RESET",
                "DELETE",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR",
                 "CLONE"
             ]
         }
      }, {
        "id" : "7686e879-46a4-4d6b-bda9-5540424jb201",
        "name" : "DRS-9272",
        "status" : "CONFIGURATION",
        "description" : "",
        "create_time" : "2020-12-21 16:53:36",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "sync",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "PRE_CHECK",
                "CHANGE_MODE",
                "FREE_RESOURCE",
                "MODIFY_DB_CONFIG",
                "API_CONFIGURATION_ACTION"
            ],
            "unavailable_actions": [
                "RETRY",
                "RESET",
                "DELETE",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR",
                 "CLONE"
             ]
         }
      }, {
        "id" : "5b2c2ec8-430e-4de0-937b-9d9547ajb201",
        "name" : "DRS-2899",
        "status" : "RELEASE_RESOURCE_COMPLETE",
        "description" : "",
        "create_time" : "2020-12-21 16:24:24",
        "engine_type" : "mysql",
        "net_type" : "eip",
        "billing_tag" : false,
        "job_direction" : "up",
        "db_use_type" : "sync",
        "task_type" : "FULL_INCR_TRANS",
        "node_newFramework" : false
        "job_action": {
            "available_actions": [
                "CREATE",
                "DELETE",
                "PRE_CHECK",
                "CHANGE_MODE",
                "MODIFY_DB_CONFIG",
                "CLONE"
            ],
            "unavailable_actions": [
                "FREE_RESOURCE",
                "START",
                "CHANGE",
                "CHOOSE_OBJECT",
                "RETRY",
                "RESET",
                "QUERY_PRE_CHECK",
                "SWITCH_OVER",
                "MODIFY_SPECIFICATION_ID",
                "RESET_DB_PWD",
                "MODIFY_CONFIGURATION",
                "PAUSE",
                "JUMP_RETRY",
                "START_INCR",
                "MODIFY_TASK_NUMBER",
                "CONTINUE_JOB",
                "STOP_JOB",
                "CONTINUE_CAPTURE",
                "STOP_CAPTURE",
                "CONTINUE_APPLY",
                "STOP_APPLY",
                "PAY_ORDER",
                "UNSUBSCRIBE",
                "TO_PERIOD",
                "TO_RENEW",
                "ORDER_INFO",
                "CHANGE_FLAVOR"
             ]
         }
      } ],
      "total_record" : 18
    }
support.huaweicloud.com/api-drs/drs_03_0138.html