gpbackup gprestore job failing consistently due to missing PXF install file.

Products

• VMware Tanzu Greenplum

Issue/Introduction

+ Regular periodic gprestore job started failing with below error

gprestore:gpadmin:mdw:201115-[CRITICAL]:-ERROR: could not stat file "/usr/local/pxf-gp6/gpextable//pxf--2.1.sql": No such file or directory (SQLSTATE 58P01)

Environment

+ gpbackup version = 1.21.0

+ gprestore version = 1.21.0

+ Greenplum Database Version = 6.25.3 build commit:367edc6b4dfd909fe38fc288ade9e294d74e3f9a

+ Customer has 2 Greenplum clusters - one PROD-BACKEND & disaster recovery(DR) cluster. DR cluster is restored periodically with backup from PROD.

Cause

+ Customer installed PXF on the source cluster (PROD-BACKEND) and taken backup which when tried for restore on the target (DR cluster) started failing as PXF was not installed on the destination/target cluster.

Resolution

+ Installing PXF on the destination (DR cluster) resolved the issue and restore job successfully completed.