[HAWQ-471] Reindex bug

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Catalog
• Assignee: Ming Li
• Reporter: Dong Li
• Created: 29/Feb/16 07:04
• Updated: 14/Jul/16 18:14
• Resolved: 10/Mar/16 07:58

Description

cr_workload=# reindex index pg_class_relname_nsp_index;
ERROR: index "pg_class_relname_nsp_index" contains unexpected zero page at block 20
HINT: Please REINDEX it.

The index of pg_class_relname_nsp has problem and error out "index "pg_class_relname_nsp_index" contains unexpected zero page at block 20".

But if we reindex it, it errors it out again.
So it is a recurse bug and the index can never be fixed.

Issue Links

• is related to: HAWQ-478 Bug when shut down cluster during recovery pass3