Note
- This view is available starting with V4.3.3 in V4.3.x.
- This view is available starting with V4.2.3 in V4.2.x.
Purpose
The CDB_OB_LS_REPLICA_TASK_HISTORY view displays the execution history of disaster recovery tasks for all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | |bigint(20) | NO | The tenant ID. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| TASK_TYPE | varchar(64) | NO | The task type. Valid values:
|
| TASK_ID | varchar(200) | NO | The task ID. |
| TASK_STATUS | varchar(2048) | YES | The task status. Valid values:
|
| PRIORITY | varchar(5) | NO | The task priority. Valid values:
|
| TARGET_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the server where the target replica resides. |
| TARGET_REPLICA_SVR_PORT | bigint(20) | YES | The port of the server where the target replica resides. |
| TARGET_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The number of required Paxos member replicas for the log stream. |
| TARGET_REPLICA_TYPE | varchar(16) | YES | The type of the target replica. |
| SOURCE_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the server where the source replica resides. |
| SOURCE_REPLICA_SVR_PORT | bigint(20) | YES | The port of the server where the source replica resides. |
| SOURCE_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The number of required Paxos member replicas for the log stream. |
| SOURCE_REPLICA_TYPE | varchar(16) | YES | The type of the source replica. |
| DATA_SOURCE_SVR_IP | varchar(46) | YES | The IP address of the data source. |
| DATA_SOURCE_SVR_PORT | bigint(20) | YES | The port of the data source. |
| IS_MANUAL | varchar(6) | NO | The source of the disaster recovery task. Valid values:
|
| TASK_EXEC_SVR_IP | varchar(46) | YES | The IP address of the server where the task is executed. |
| TASK_EXEC_SVR_PORT | bigint(20) | YES | The port of the server where the task is executed. |
| CREATE_TIME | datetime | NO | The time when the task was generated. |
| START_TIME | datetime | NO | The time when the task was scheduled. |
| MODIFY_TIME | datetime | NO | The time when the task status was updated. |
| FINISH_TIME | datetime | NO | The time when the task was completed. |
| EXECUTE_RESULT | varchar(2048) | YES | The execution result of the task. |
| COMMENT | varchar(2048) | YES | The remarks about the reason for generating the task. |
| CONFIG_VERSION | varchar(128) | YES | The config_version information of the clog layer when the disaster recovery task was executed.
NoteThis column is available starting with V4.4.0. |
Sample query
Query the execution history of disaster recovery tasks.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY LIMIT 2\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1003
LS_ID: 1
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D80C8-0-0
TASK_STATUS: FAILED
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.243
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
DATA_SOURCE_SVR_IP: 0.0.0.0
DATA_SOURCE_SVR_PORT: 0
IS_MANUAL: FALSE
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
CREATE_TIME: 2025-07-10 11:03:55
START_TIME: 2025-07-10 11:03:55
MODIFY_TIME: 2025-07-10 11:03:55
FINISH_TIME: 2025-07-10 11:03:54
EXECUTE_RESULT: ret:-4766, OB_LS_WAITING_SAFE_DESTROY; elapsed:14686; comment:[storage] fail to send execution rpc;
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
*************************** 2. row ***************************
TENANT_ID: 1003
LS_ID: 1
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D80D6-0-0
TASK_STATUS: COMPLETED
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.243
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
DATA_SOURCE_SVR_IP: 0.0.0.0
DATA_SOURCE_SVR_PORT: 0
IS_MANUAL: FALSE
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
CREATE_TIME: 2025-07-10 11:04:25
START_TIME: 2025-07-10 11:04:05
MODIFY_TIME: 2025-07-10 11:04:25
FINISH_TIME: 2025-07-10 11:04:25
EXECUTE_RESULT: ret:0, OB_SUCCESS; elapsed:20052991;
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
2 rows in set
References
- Query the execution history of disaster recovery tasks for the current tenant: DBA_OB_LS_REPLICA_TASK_HISTORY
- Query the running disaster recovery tasks at the replica level for all tenants: CDB_OB_LS_REPLICA_TASKS