Queries failing with error "Temporary failure in name resolution" on Tanzu Greenplum

Products

• VMware Tanzu Greenplum

Issue/Introduction

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.