ERROR","42P01","relation not found (OID *********) in VMware Tanzu Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

While trying to run a pg_dump of a schema, it fails with the following error:

ERROR","42P01","relation not found (OID 46991100)","
This can be validly caused by a concurrent delete operation on this object.",,,,,
"SELECT pg_get_partition_def('46991100'::pg_catalog.oid, true, true) ",0,,"heapam.c",947,

Validate the existence of the OID with or without indexes. Also validate any FATAL, ERRORS, or PANICs relating to this in the logs.

Environment

Product Version: 5.28

Resolution

This is functioning as designed. As the error explains, this can be validly caused by a concurrent delete operation on this object. 

The resolution to this issue is to run the pg_dump operation at a time where there are no delete operations being run on the scheme that you are trying to backup.