Pivotal Knowledge Base

Follow

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

Environment

Product Version
Pivotal Greenplum (GPDB) All Versions
OS RHEL 6.x

Symptom

Running gp_restore fails with error similar to the following:

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

Resolution

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.

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.

 

Comments

Powered by Zendesk