Pivotal Knowledge Base

Follow

Querying a Table Fails with the Error "index 'xx' contains unexpected zero page at block xxx"

Environment

Pivotal Greenplum Database (GPDB) all versions

Symptom

Query a table gives the error message.

Error Message:

ERROR:  index "pg_statlastop_classid_objid_staactionname_index" contains unexpected zero page at block 311
HINT:  Please REINDEX it.

Here the index "pg_statlastop_classid_objid_staactionname_index" is having issue being read.

Cause

The cause of the issue is due to bad index pages and is unable to read it.

Resolution

Reindex the problematic index to overcome the issue.

    Reindex index <schema_name>.<index_name>;

so in the above example.

    Reindex index pg_catalog.pg_statlastop_classid_objid_staactionname_index;

In cases of indexes which are standalone please refer to this article which describes how to connect using backend mode and then perform the reindex.

Comments

Powered by Zendesk