gp_restore Error "Error executing query SELECT * FROM gp_read_backup_file('db_dumps/##', '##', 2) : ERROR: Backup File ... Type 2 could not be found"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Running gp_restore fails with an error similar to the following:

Error executing query SELECT * FROM gp_read_backup_file('db_dumps/20150528', '201505281####', 2) : ERROR:  Backup File /mnt/data1/primary/gp5/db_dumps/20150528/gp_restore_status_0_7_20150528#### Type 2 could not be found

Cause

gp_restore needs write permissions to the backup directory. gp_restore tries to create/write a status file and if it is not able to, it will fail with the error above.

Resolution

If you see this error, make sure that the user under which GPDB/gp_restore running can write and update files in the backup directory. This is especially important if the backup directory is mounted from another location.

Note- "Type 2" above is simply a notion that the file that could not be found is a gp_restore "status" file. "Type 1" corresponds to a backup "status" file.