Pivotal Greenplum (GPDB)
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)",
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.
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.
For further information on this type of error when you make changes to the /etc/resolv.conf file, please refer to the following resource: