gpbackup on a read-enabled disaster recovery cluster reports ""ERROR","58P01","could not open file ""base/12345/t_9534978"": No such file or directory"

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

With a Greenplum Disaster Recovery(GPDR) configuration the DR cluster can be "read-enabled". This would allow read-only queries to be run on the cluster and backups of databases on the DR cluster.

When running gpbackup to backup the DR cluster/databases can report the error:

"ERROR","58P01","could not open file ""base/12345/t_9534978"": No such file or directory"

Cause

This is caused by the gpbackup reading AO TEMP tables on the DR cluster.

gpbackup should ignore and not try to backup temporary tables.

The error occurs when the option "--leaf-partition-data" is used when backing up the database that has TEMP AO tables.

Resolution

Workaround

Downgrade the gp_toolkit ro 1.16 in all databases in the cluster:

Log into each DB and run:

• DROP EXTERNSION gp_toolkit;
• CREATE EXTENSION gp_toolkit VERSION '1.16';

Fix

As of March 2026 R&D are working on a code fix for the issue.