gp_check_function - gp_move_orphaned_files orphan file processing error

Products

• VMware Tanzu Data Suite

Issue/Introduction

gp_check_function - gp_move_orphaned_files orphan file processing error

dbname=# SELECT * FROM gp_move_orphaned_files('/data01/orphaned');
WARNING:  file "/data1/primary/gpseg14/base/16384/70301" is not accessible: No such file or directory  (seg6 slice3 192.168.1.21:40000 pid=30947)
WARNING:  file "/data1/primary/gpseg14/base/16384/70302" is not accessible: No such file or directory  (seg6 slice3 192.168.1.21:40000 pid=30947)
WARNING:  file "/data1/primary/gpseg14/base/16384/70303" is not accessible: No such file or directory  (seg6 slice3 192.168.1.21:40000 pid=30947)
WARNING:  file "/data1/primary/gpseg14/base/16384/70300" is not accessible: No such file or directory  (seg6 slice3 192.168.1.21:40000 pid=30947)

Environment

GPDB 6.28.0

 

Resolution

Check the gp_check_function version being used - it can be checked by \dx

If it is less than version 1.2, drop & create gp_check_functions extension:

drop extension gp_check_functions;
create extension gp_check_functions;