Pivotal Knowledge Base


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"


  • Pivotal Greenplum (GPDB) all versions
  • Operating System- Red Hat Enterprise Linux (RHEL) 6.x


Running gp_restore fails with an 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


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.



Powered by Zendesk