Pivotal Knowledge Base

Follow

Partition error: failed to re-find parent key in index "xxx" for split pages yyy/zzz (nbtinsert.c:1527)

Environment

Pivotal Greenplum

Symptom

When attempting to create a new partition, you get an error ERROR: failed to re-find parent key in index.

Error Message:

ERROR: failed to re-find parent key in index "pg_attribute_relid_attnum_index" for split pages 6424/6425 
(nbtinsert.c:1527) (seg4 VIDHOLXPGPNAP01:40004 pid=64486) (cdbdisp.c:1326)

Cause

The index is likely corrupted.

Resolution

Reindex the problematic table (based on error - pg_attribute in this example)

REINDEX TABLE pg_catalog.pg_attribute;

Comments

Powered by Zendesk