Updated on 2026-08-25 GMT+08:00

Querying a Task for Automatically Killing Sessions

Function

This API is used to query a task for automatically killing sessions.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action

Access Level

Resource Type (*: required)

Condition Key

Alias

Dependencies

das:clouddba:listKillTaskRecord

Read

Instance

-

-

-

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
das:clouddba:listKillTaskRecord	Read	Instance	-	-	-

URI

GET /v3/{project_id}/instances/{instance_id}/auto-flow/query-kill-process-task

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A
instance_id	Yes	String	Definition Unique ID of an instance Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A

Request Parameters

None

Response Parameters

Status code: 200

**Table 2** Response body parameters
Parameter	Type	Description
sql_killing_task_resp_list	List of Table 3 Objects	Definition Tasks for automatically killing sessions Range N/A

**Table 3** Task for automatically killing sessions
Parameter	Type	Description
user	String	Definition Username Range N/A
host	String	Definition Host address Range N/A
db	String	Definition Database Range N/A
command	String	Definition CLI Range N/A
task_id	Long	Definition Task ID Range N/A
end_time	Long	Definition Task ID list Range N/A

Example Requests

GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/bcfa975193f1402fa11a6d4fd6baf5fbin01/auto-flow/query-kill-process-task

Example Responses

Status code: 200

Success.

{
    "sql_killing_task_resp_list": [
        {
            "user": "",
            "host": "",
            "db": "",
            "info": "",
            "command": "",
            "time": 5,
            "task_id": 1,
            "task_type": "auto",
            "task_duration": 30,
            "task_state": 0,
            "start_time": 1754378225000,
            "end_time": 1754378255000
        }
    ]
}

Status Codes

Status Code	Description
200	Success.
400	Client error.
500	Server error.

Error Codes

See Error Codes.

Parent topic: Intelligent O&M