oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO

2025-12-09 07:09:36  Updated

Feature

This view shows the information about column checksum inconsistencies between the index table (including global and local indexes) and the primary table.

Fields

Field Type Nullable Description
TENANT_ID bigint(20) NO The ID of the tenant.
FROZEN_SCN bigint(20) unsigned NO The SCN of the current compaction.
INDEX_TYPE varchar(12) NO The type of the index table.Valid values:
  • 0: indicates a local index table.
  • 1: indicates a global index table.
  • DATA_TABLE_ID bigint(20) NO The ID of the primary table.
    INDEX_TABLE_ID bigint(20) NO The ID of the global or local index table.
    DATA_TABLET_ID bigint(20) NO The TABLET ID with inconsistent checksum on the primary table (only for the check between the local index table and the primary table)
    INDEX_TABLET_ID bigint(20) NO The TABLET ID with inconsistent checksums on the index table (only for verification between the local index table and the primary table).
    COLUMN_ID bigint(20) NO The ID of the column with the checksum error.
    DATA_COLUMN_CHECKSUM bigint(20) NO The checksum value of the column in the primary table.
    INDEX_COLUMN_CHECKSUM bigint(20) NO The checksum value of the column in the index table.

    Contact Us