This topic describes how to destroy OceanBase Data Proxy (ODP) by using obshell.
Note
This API is supported starting with obshell V4.2.6.
API details
Constraints
- The obshell server performs security verification on this API. For more information, see API hybrid encryption.
- The ODP service must be managed in the current obshell session.
Request path
DELETE /api/v1/obproxy
Response parameters
| Parameter | Type | Description |
|---|---|---|
| successful | bool | Indicates whether the request was successful. |
| timestamp | time.Time | The timestamp when the server finishes the request. |
| duration | int | The time taken by the server to process the request, in milliseconds. |
| status | int | The HTTP status code that conforms to the HTTP Status specification. |
| traceId | string | The Trace ID of the request. |
| data | DagDetailDTO | For more information, see the data structure of the DagDetailDTO section below. |
| error | ApiError | The error generated by the request, which contains the following information:
|
The data structure of the DagDetailDTO is as follows:
| Parameter | Type | Description |
|---|---|---|
| id | string | The general ID of the DAG. |
| dag_id | int | The DAG ID, which is the primary key stored in OceanBase Database. |
| name | string | The name of the DAG. |
| stage | int | The current execution stage of the DAG. |
| max_stage | int | The total number of stages in the DAG execution process. |
| state | string | The execution status of the DAG. |
| operator | string | The operation type of the DAG execution. |
| start_time | time.Time | The start time of the DAG execution. |
| end_time | time.Time | The end time of the DAG execution. |
| additional_data | map[string]any | Other data of the DAG. |
| nodes | []NodeDetailDTO | The information of all nodes in the DAG. For more information, see Obtain the details of a node. |
Examples
Request example
DELETE 10.10.10.1:2886/api/v1/obproxy
Response example
{
"successful": true,
"timestamp": "2025-03-20T16:49:01.506125154+08:00",
"duration": 2,
"status": 200,
"traceId": "cd41831d02399bc8",
"data": {
"id": "401949121070808812",
"dag_id": 12,
"name": "Delete obproxy",
"stage": 1,
"max_stage": 4,
"state": "READY",
"operator": "RUN",
"start_time": "2025-03-20T16:49:01.50428353+08:00",
"end_time": "2025-03-20T16:49:01.50428353+08:00",
"additional_data": null,
"nodes": null
}
}
References
In addition to using the CLI to call the API, you can also use the SDK. For more information about how to request the API through obshell-sdk-python, see Destroy ODP.