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 job ID, which is a monotonic incrementing value. |
| INCARNATION | bigint(20) | NO | The incarnation ID. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID that initiated the job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID of 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 values: expired, specified backup_set/round/piece, or canceled. |
| PARAMETER | timestamp(6) | NO | The content of the parameter is as follows: |
| JOB_LEVEL | varchar(64) | NO | The job initiation level. Valid values: USER_TENANT, CLUSTER, and SYS_TENANT. |
| START_TIMESTAMP | timestamp(6) | NO | The current time of the tenant when the job started. |
| END_TIMESTAMP | timestamp(6) | NO | The current time of the tenant when the job ended. |
| STATUS | varchar(64) | NO | The job status. Valid values: |
| 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 description of the job execution. |
Sample query
Query the execution progress of all tenant-level backup cleanup jobs in the sys 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