Note
This view was introduced in OceanBase Database V4.2.3.
Purpose
The oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY view displays the execution history of disaster recovery tasks in the current tenant.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| TASK_TYPE | varchar(64) | NO | The type of the task. Valid values:
|
| TASK_ID | varchar(200) | NO | The ID of the task. |
| TASK_STATUS | varchar(2048) | YES | The status of the task. Valid values:
|
| PRIORITY | varchar(5) | NO | The priority of the task. Valid values:
|
| TARGET_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the OBServer node where the destination replica resides. |
| TARGET_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the OBServer node where the destination replica resides. |
| TARGET_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The quorum of the destination Paxos group of the log stream. |
| TARGET_REPLICA_TYPE | varchar(16) | YES | The type of the destination replica. |
| SOURCE_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the OBServer node where the source replica resides. |
| SOURCE_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the OBServer node where the source replica resides. |
| SOURCE_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The quorum of the source Paxos group of 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 number of the data source. |
| IS_MANUAL | varchar(6) | NO | The source of the task. Value values:
|
| TASK_EXEC_SVR_IP | varchar(46) | YES | The IP address of the OBServer node where the task is executed. |
| TASK_EXEC_SVR_PORT | bigint(20) | YES | The port number of the OBServer node 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 last updated. |
| FINISH_TIME | datetime | NO | The end time of the task. |
| EXECUTE_RESULT | varchar(2048) | YES | The task execution result. |
| COMMENT | varchar(2048) | YES | The reason why the task was generated. |
Sample query
View the execution history of the disaster recovery tasks in the current tenant and display the first two records.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY limit 2;
The query result is as follows:
+-------+----------------------+------------------------------------+-------------+----------+-----------------------+-------------------------+-----------------------------+---------------------+-----------------------+-------------------------+-----------------------------+---------------------+--------------------+----------------------+-----------+------------------+--------------------+---------------------+---------------------+---------------------+---------------------+-----------------------------------+----------------------------------+
| LS_ID | TASK_TYPE | TASK_ID | TASK_STATUS | PRIORITY | TARGET_REPLICA_SVR_IP | TARGET_REPLICA_SVR_PORT | TARGET_PAXOS_REPLICA_NUMBER | TARGET_REPLICA_TYPE | SOURCE_REPLICA_SVR_IP | SOURCE_REPLICA_SVR_PORT | SOURCE_PAXOS_REPLICA_NUMBER | SOURCE_REPLICA_TYPE | DATA_SOURCE_SVR_IP | DATA_SOURCE_SVR_PORT | IS_MANUAL | TASK_EXEC_SVR_IP | TASK_EXEC_SVR_PORT | CREATE_TIME | START_TIME | MODIFY_TIME | FINISH_TIME | EXECUTE_RESULT | COMMENT |
+-------+----------------------+------------------------------------+-------------+----------+-----------------------+-------------------------+-----------------------------+---------------------+-----------------------+-------------------------+-----------------------------+---------------------+--------------------+----------------------+-----------+------------------+--------------------+---------------------+---------------------+---------------------+---------------------+-----------------------------------+----------------------------------+
| 1 | REMOVE PAXOS REPLICA | Y13CE64586BD4-000614A074B90E52-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5072 | 5 | FULL | NULL | 0 | 5 | NULL | NULL | NULL | FALSE | xx.xx.xx.xx | 5070 | 2024-03-27 16:57:55 | 2024-03-27 16:57:55 | 2024-03-27 16:57:55 | 2024-03-27 16:57:55 | ret:0, OB_SUCCESS; elapsed:87128; | remove permanent offline replica |
+-------+----------------------+------------------------------------+-------------+----------+-----------------------+-------------------------+-----------------------------+---------------------+-----------------------+-------------------------+-----------------------------+---------------------+--------------------+----------------------+-----------+------------------+--------------------+---------------------+---------------------+---------------------+---------------------+-----------------------------------+----------------------------------+
1 row in set
References
View the execution history of all tenant disaster recovery tasks: CDB_OB_LS_REPLICA_TASK_HISTORY
View all running disaster recovery tasks in all tenants: CDB_OB_LS_REPLICA_TASKS
View all running disaster recovery tasks in the current tenant: DBA_OB_LS_REPLICA_TASKS