Connection to gpfdist server fails with "Connection refused" error

Products

• VMware Tanzu Greenplum
• Greenplum
• Pivotal Data Suite Non Production Edition
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

Symptoms:

When executing a query against an external table, gpfdist may fail, producing the error Connection refused.

Error Message:

ERROR: connection with gpfdist failed for gpfdist://mdw:8091/loadfiles/20150823/crm/aaa.csv. effective url:http://192.168.XX.XX:8091/loadfiles/20150823/crm/aaa.csv. error code = 111 (Connection refused) (seg9 slice1 sdw3:40003 pid=233662)

Environment

Cause

There are a number of possible reasons:

• The IP address or the port number of the gpfdist server in the location string is incorrect.
• gpfdist is not up and running
• The may be a firewall between one or more of the segment servers and the host running gpfdist

 

Resolution

1. Verify that gpfdist is running on the host with the specified IP address
2. Verify that the gpfdist os listening on the port specified in external table definition
3. Check that all the segment servers have network access to the host and/or IP address specified. Use "nc -z -v <IP address> <port>" to verify
   Successful connection:
   

   gpadmin@sdw1 $ nc -z -v etl01 8000
   Ncat: Version 7.92 ( https://nmap.org/ncat )
   Ncat: Connected to 10.225.28.105:8000.
   Ncat: 0 bytes sent, 0 bytes received in 0.04 seconds.

   Unsuccessful connection:

   gpadmin@sdw1 $ nc -z -v etl01 8000
   Ncat: Version 7.92 ( https://nmap.org/ncat )
   Ncat: Connection refused.