Updated on 2024-03-08 GMT+08:00

Reindexing Fails

Symptom

When an index of the Desc table is damaged, a series of operations cannot be performed. The error information may be as follows:

index \"%s\" contains corrupted page at block %u" ,RelationGetRelationName(rel),BufferGetBlockNumber(buf),
please reindex it.

Cause Analysis

In actual operations, indexes may break down due to software or hardware faults. For example, if disk space is insufficient or pages are damaged after indexes are split, the indexes may be damaged.

Solution

If the table is named pg_cudesc_xxxxx_index (indicating a column-store table), the index table of the Desc table has been damaged. Use the name of the Desc index table to find the OID and table of the corresponding primary table, and run the REINDEX INTERNAL TABLE name statement to reindex the cudesc table.