Note
This view is available starting with V4.6.0.
Purpose
The oceanbase.DBA_OB_LOB_CHECK_TASKS view is used to record the progress of LOB consistency verification and task scanning for restoration under the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| LS_ID | bigint(20) | NO | Log Stream ID |
| TABLE_NAME | varchar(256) | NO | Table Name |
| TABLE_ID | bigint(20) | NO | Table ID |
| TABLET_ID | bigint(20) | NO | Partition ID |
| TASK_ID | bigint(20) | NO | ID of the current batch task |
| START_TIME | timestamp(6) | NO | Task Start Time |
| END_TIME | timestamp(6) | NO | End Time |
| TRIGGER_TYPE | varchar(8) | NO | Task trigger type. Valid values: SYSTEM and USER |
| STATUS | varchar(10) | NO | Task status.
|
| MISS_CNT | bigint(20) | NO | Number of Missing Data Records in the Auxiliary Table Scanned by Consistency Verification |
| MISMATCH_LEN_CNT | bigint(20) | NO | Number of Data Records with Inconsistent Byte Lengths Scanned in Primary and Secondary Tables during Consistency Verification |
| ORPHAN_CNT | bigint(20) | NO | Number of Residual Data in Auxiliary Tables Scanned by Consistency Verification |
| CORRECT_CNT | bigint(20) | NO | Number of Abnormalities Restored for Deleted Auxiliary Tables in Consistency Recovery |
| RET_CODE | varchar(512) | NO | Status at Task Completion |
| TASK_TYPE | varchar(10) | NO | TTL Task Type ("LOB_CHECK" or "LOB_CORRECT") |
| TASK_SCOPE | varchar(6) | NO | Task type. Valid values:
|
Sample query
obclient > SELECT * FROM oceanbase.DBA_OB_LOB_CHECK_TASKS;