Note
This view is available starting with V4.6.0.
Purpose
The oceanbase.CDB_OB_LOB_CHECK_EXCEPTION_RESULT view is used to display the abnormal tables and tablets that have undergone LOB consistency verification, as well as the exception types, in the sys tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| CREATE_TIME | timestamp(6) | NO | Exception Result Creation Time |
| UPDATE_TIME | timestamp(6) | NO | Modified At of Exceptional Result |
| TABLE_NAME | varchar(256) | NO | Abnormal Table Name |
| TABLE_ID | bigint(20) | NO | ID of the abnormal table object |
| INCONSISTENCY_TYPE | varchar(16) | NO | Exception type.
|
| TABLET_IDS | longtext | YES | Exception partition ID |
Sample query
obclient > SELECT * FROM oceanbase.CDB_OB_EXTERNAL_RESOURCES;