Unable to read from or write to external tables using gpfdist in Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

Attempting to read or write to an external table reports results in the following warnings:

WARNING: http://10.10.10.10:8080/gpfdist_dir/data.txt error (7 - Couldn't connect to server) (seg4 sdw1.isus.emc.com:40004 pid=4547)

WARNING: failed to send request to gpfdist (http://10.10.10.10:8080/gpfdist_dir/data.txt), will retry after 64 seconds (seg4 sdw1.isus.emc.com:40004 pid=4547)

Environment

Product Version: 4.3

Resolution

The message "Couldn't connect to server" indicates that the segment server is unable to reach the host running gpfdist service.

Check if there is a firewall between the segment server(s) and the the host running gpfdist.

If there is a firewall, ensure that the required ports are opened between the segment servers and the gpfdist host.