Pivotal Knowledge Base

Follow

Queries failing with error "Temporary failure in name resolution"

 

Environment

Product Version
Pivotal Greenplum (GPDB)  

Symptom

Queries or application connections are failing with the following error message:

ERROR","XX000","could not translate host name ""appserv.loading.local"", port ""8000"" to address: Temporary failure in name resolution (cdbutil.c:754) (seg64 slice1 sdw11:40004 pid=13673) (cdbdisp.c:1489)",

Cause

The query or application is trying to connect to the FQDN name "appserv.loading.local". However, the system is not able to resolve the Fully Qualified Domain Name (FQDN) to an IP address.

Resolution

When you ping the IP address for the server whose name resolves to appserv.loading.local, the ping is successful. However, a ping using the FQDN to appserv.loading.local is failing. To resolve this issue, ensure that the FQDN name appserv.loading.local is added to the /etc/hosts file on the server that is trying to connect to "appserv.loading.local".

If the server is using a DNS server to resolve the FQDN to an IP address, then ensure that the DNS server is set up correctly to resolve the IP to the FQDN.

Additional Information

For further information on this type of error when you make changes to the /etc/resolv.conf file, please refer to the following resource:

https://discuss.zendesk.com/hc/en-us/articles/203100247-Change-to-DNS-configuration-resolv-conf-is-not-detected-by-Greenplum-Database-DCA-v1-

Comments

  • Avatar
    Brendan Stephens

    Note: When using a hosts file for resolution, be sure that the hosts contains both the hostname: `appserv` and the fully qualified domain name: `appserv.loading.local`.

Powered by Zendesk