GPRESTORE Error when resize-cluster and single-data-file flags are used: Expected to find 2 files on segment but found 1 instead

Products

• VMware Tanzu Greenplum

Issue/Introduction

Attempting to perform a gprestore with the use of resize-cluster for restoring to a different segment-size cluster is failing with the following error. I am using the latest version of This can happen even when  the data has been backed up to external storage which is available on all segment hosts.

 

Command:

gpbackup --backup-dir /mnt/... ... --single-data-file --single-backup-dir

 

Error:

Expected to find 2 file(s) on segment ... on host sdw1, but found 1 instead.

Cause

No records of the toc.yaml files were found on the segment data directories.

 Every data file for a segment should have a corresponding TOC file in the same location as the data file as in the example below:

Example:
gpbackup_1_20250312184345.gz
gpbackup_1_20250312184345_toc.yaml

Resolution

While there may not be an standard cause for this error or the exact cause may not be known, workaround options can be:

1. Rerunning the backup job and ensuring toc files are generated as in the above example

2. Omitting single-data-file flag during backup to remove the need for toc file