ERROR: invalid attribute number 36 for <table name>

Products

• VMware Tanzu Greenplum

Issue/Introduction

When dropping / reindexing / vacuuming a table, the below error was hit:

ERROR: invalid attribute number 36 for <table name> (relcache.c:978) (segxxx sdw1:40001 pid=29108) (cdbdisp.c:1322)

Environment

Product Version: 5.18

Resolution

If the error output does not indicate the affected segment, we can generally get it from pg_log.

Normally, reindexing pg_attribute on the affected segments only should be able to fix this issue.

If reindexing pg_attribute fails to fix it, we can run a gpcheckcat and engage GPDB support for further check.