VMware Tanzu Greenplum command center raises an alert if it is unable to connect to the VMware Greenplum system. If Tanzu Greenplum command center is running on the VMware Greenplum coordinator host, it is likely that the database is down or not accepting connections.
If Tanzu Greenplum command center is running on the standby coordinator host, the problem could be that the coordinator host is down, there is a networking issue, or that the database is down or not accepting connections.
Tanzu Greenplum command center tries to connect to the database three times before issuing an alert.
If Tanzu Greenplum command center is running on the VMware Greenplum coordinator host:
gpstate
command-line utility on the Greenplum coordinator to check the status of the database system. Correct any problems identified in the command output.If Tanzu Greenplum command center is running on the VMware Greenplum standby coordinator host:
Log in to the standby coordinator host as the gpadmin user and then SSH to the coordinator host.
$ ssh gpadmin@<coordinator-hostname>
Be sure that <coordinator-hostname> matches the hostname
column in the gp_segment_configuration
system table. If you are unable to reach the coordinator host, make sure the host is running and resolve any networking issues.
Run the gpstate
command-line utility on the Greenplum coordinator to check the status of the database system. Correct any problems identified in the command output.