Pivotal Knowledge Base

Follow

Connection to gpfdist server fails with connection refused error

Environment 

Product Version
Pivotal Greenplum (GPDB)  4.3.x
OS  All
Others  

Symptom
Sometimes, when executing a query against an external table, gpfdist will fail with connection refused.
 

Error Message:

The error message is:

ERROR: connection with gpfdist failed for gpfdist://mdw:8091/splunk/SID/20150823/crm/aaa.csv. 
effective url:http://172.28.23.2:8091/splunk/SID/20150823/crm/aaa.csv. error code = 111 (Connection refused)
(seg9 slice1 gpdb02.bbb.sh:40003 pid=233662)


Cause
The IP address or the port number of the gpfdist server in the location string was wrong.

Resolution
With any gpfdist configuration, it is very common to have wrong gpfdist server address or port number. If there are no other error messages, before investigating into any deeper, it is good idea to check IP address and port number of specified gpfdist server in the location string.

In this specific case,  based on the error message you may first check whether 172.28.23.2 can be pingable from seg9, and also whether port 8091 is open on the server 172.28.23.2.

 

 

Comments

  • Avatar
    Gurupreet Singh Bhatia

    check GPFDIST process , it may be killed from given host, or as per resolution may be you are using wrong IP or PORT.

Powered by Zendesk