Note
This view is available starting with V4.0.0.
Purpose
This view displays the execution progress of tenant-level backup cleanup jobs.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| JOB_ID | bigint(20) | NO | The task ID, which is a monotonic increasing value. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the job in the tenant that initiated the job. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The list of tenants that executed the cleanup task. |
| TYPE | varchar(64) | NO | The cleanup type. Valid value: DELETE OBSOLETE BACKUP, which indicates obsolete cleanup. |
| PARAMETER | timestamp(6) | NO | The cleanup parameter, which records the obsolete time. |
| JOB_LEVEL | varchar(64) | NO | The task initiation level. Valid values: USER_TENANT and SYS_TENANT. USER_TENANT indicates that the task was initiated by a user tenant. SYS_TENANT indicates that the task was initiated by a system tenant. |
| START_TIMESTAMP | timestamp(6) | NO | The current time of the tenant when the task started. |
| END_TIMESTAMP | timestamp(6) | NO | The current time of the tenant when the task ended. |
| STATUS | varchar(64) | NO | The task status. Valid values: INIT, DOING, CANCELING, COMPLETED, FAILED, and CANCELED. INIT indicates the task initialization stage. DOING indicates the task execution stage. CANCELING indicates the task cancellation stage. COMPLETED indicates that the task was executed successfully. FAILED indicates that the task execution failed. CANCELED indicates that the task was successfully canceled. |
| TASK_COUNT | bigint(20) | YES | The number of backup_set/piece tasks. |
| SUCCESS_TASK_COUNT | bigint(20) | YES | The number of backup_set/piece tasks that were executed successfully. |
| RESULT | bigint(20) | NO | The error code. |
| COMMENT | varchar(4096) | YES | The task execution description. |
Sample query
Query the execution progress of all tenant backup cleanup jobs as the system tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_JOBS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
JOB_ID: 7
INCARNATION: 1
INITIATOR_TENANT_ID: 1002
INITIATOR_JOB_ID: 7
EXECUTOR_TENANT_ID: 1002
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2022-05-31 12:09:40.060284
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2022-06-01 12:09:53.389512
END_TIMESTAMP:
STATUS: DOING
TASK_COUNT: 2
SUCCESS_TASK_COUNT: 1
RESULT: 0
COMMENT:
1 row in set
References
Query the execution progress of backup cleanup tasks that are in progress: CDB_OB_BACKUP_DELETE_TASKS
Query the historical information about backup cleanup jobs: CDB_OB_BACKUP_DELETE_JOB_HISTORY
Query the historical information about backup cleanup tasks: CDB_OB_BACKUP_DELETE_TASK_HISTORY
For more information about how to set up automatic cleanup of obsolete backups, see Automatically clear obsolete backups.