Database connectivity failure

What is this alert?

Command Center raises an alert if it is unable to connect to the Greenplum Database system. If Command Center is running on the Greenplum Database master host, it is likely that the database is down or not accepting connections.

If Command Center is running on the standby master host, the problem could be that the master host is down, there is a networking issue, or that the database is down or not accepting connections.

Command Center tries to connect to the database three times before issuing an alert.

What to do?

If Command Center is running on the Greenplum Database master host:

  • Run the gpstate command-line utility on the Greenplum master to check the status of the database system. Correct any problems identified in the command output.

If Command Center is running on the Greenplum Database standby master host:

  • Log in to the standby master host as the gpadmin user and then SSH to the master host.

    $ ssh gpadmin@<master-hostname>
    

    Be sure that <master-hostname> matches the hostname column in the gp_segment_configuration system table. If you are unable to reach the master host, make sure the host is running and resolve any networking issues.

  • Run the gpstate command-line utility on the Greenplum master to check the status of the database system. Correct any problems identified in the command output.