Overview
The oceanbase.DBA_OB_LOB_CHECK_TASKS view is used to record the progress of task scans for LOB consistency verification and recovery in the sys tenant.
Columns
Field |
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 | The 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: system or user |
| STATUS | varchar(10) | NO | Task status.
|
| MISS_CNT | bigint(20) | NO | Number of Missing Data Records in the Auxiliary Table Scanned for Consistency Verification |
| MISMATCH_LEN_CNT | bigint(20) | NO | Number of Data Records with Inconsistent Byte Lengths Scanned in Primary and Secondary Tables |
| ORPHAN_CNT | bigint(20) | NO | Consistency Verification Residual Data Count in Scanned Auxiliary Tables |
| CORRECT_CNT | bigint(20) | NO | Number of Exceptions in Restored Deleted Auxiliary Tables |
| 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;