|Pivotal Greenplum (GPDB)||4.3.x|
Sometimes, when executing a query against an external table, gpfdist will fail with connection refused.
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)
The IP address or the port number of the gpfdist server in the location string was wrong.
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.