config 'gpcc_host' must be of coordinator or standby when 'gpcc_external=<false/empty>'

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

When attempting to install Greenplum Command Center (GPCC) with an internal deployment (gpcc_external set to false or left empty), the following error is encountered:

config 'gpcc_host' must be of coordinator or standby when 'gpcc_external=<false/empty>'

Environment

• All versions of Greenplum Command Center

• Internal (non-external) GPCC deployment

• Greenplum Database cluster with a defined coordinator and optional standby

Cause

The error typically occurs when the hostname specified in the GPCC configuration (app.conf) does not resolve to the coordinator or standby host. Possible causes include:

• Mismatched hostnames between app.conf, /etc/hostname, and /etc/hosts

• Hostname resolving to an external or non-cluster IP address

• Misconfigured DNS or host resolution

• Inconsistent entries in the gp_segment_configuration table

Resolution

1. Verify GPCC Host Setting
   Ensure that the gpcc_host value in app.conf is set to the coordinator or standby hostname.

2. Check Hostname Consistency
   Confirm the hostname listed in:

   • /etc/hostname

   • /etc/hosts

   • app.conf
     
     All should match and refer to the same node that serves as the coordinator or standby.

3. Validate Hostname Resolution
   Run:

    

   getent hosts <gpcc_host>

   or

    

   nslookup <gpcc_host>

   and confirm that the IP address resolves internally to the cluster's coordinator or standby node.

4. Check gp_segment_configuration
   Ensure the hostname and address fields in gp_segment_configuration include the coordinator and/or standby, and match the value used in gpcc_host.

    

   1. SELECT dbid, role, hostname, address FROM gp_segment_configuration WHERE content = -1;

 

 

Additional Information

/etc/hostname traditionally only includes a machine (or short) name. For example:

'gp1'

Instead of:

'gp1.organization.com'