Pivotal Knowledge Base

Follow

Connection to gpfdist Server Fails with Connection Refused Error

Environment 

  • Pivotal Greenplum Database (GPDB) 4.3.x
  • Operating System- All supported

Symptom

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

Error Message:

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