Querying a table fails with the error "index 'xx' contains unexpected zero page at block xxx"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

Querying a table produces the following error message:

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

The index "pg_statlastop_classid_objid_staactionname_index" is having an issue being read.

Environment

Cause

The cause of the issue is bad index pages.

Resolution

Reindex the problematic index to overcome this issue.

Reindex index <schema_name>.<index_name>;

Reindex index pg_catalog.pg_statlastop_classid_objid_staactionname_index;

Contact Pivotal Support in case the shared table index needs to be rebuilt.