GPFDIST Error "HTTP response code 404" or "404 file not found"

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

gpfdist fails while loading files producing the following error message:

2014/06/23 11:16:06 ERROR> DatabaseObject.pm:40 DatabaseObject::logError -  Can't start copying from external table into staging table table_load :ERROR: http response code 404 from gpfdist (gpfdist://etl01:9108/event-table_v2*.gz): HTTP/1.0 404 file not\
found (url.c:326) (seg12 slice1 sdw3-seg10:40002 pid=4093) (cdbdisp.c:1476)

Environment

Cause

Check the log files for messages as follows:

2014-06-23 11:16:06.390802 UTC,"loader","test",p31729,th-1601935616,"10.10.10.16","34956",2014-06-23 15:09:11 UTC,11203405,con154309,cmd17,seg12,,dx432510,x11203405,sx1,"LOG","00000","Process interrupt for 'query cancel pending'.",,,,,,"
insert into table_load 
[....]
2014-06-23 11:16:06.391043 UTC,"loader","test",p31729,th-1601935616,"10.10.10.16","34956",2014-06-23 15:09:11 UTC,11203405,con154309,cmd17,seg12,,dx432510,x11203405,sx1,"ERROR","25M01","canceling MPP operation",,,,,,"
insert into table_load

This error message dicates that the file that gpfdist is trying to load cannot be found at the specified location. This error causes the INSERT to fail. 

Resolution

1. Ensure the file exists at the specified location.
2. Using any wild character in gpfdist may cause files to be removed. Make sure that there are no files being removed when the loading operation is in progress.