VMware Cloud Director Database – Troubleshooting Read Only Primary or Degraded State

Products

• VMware Cloud Director

Issue/Introduction

After increasing the capacity of the embedded PostgreSQL database on VMware Cloud Director Appliance by following the Increase PostgreSQL database disk, Cluster Health shows DEGRADED or READ ONLY PRIMARY

Environment

VMware Cloud Director 10.x

Cause

1. Cluster Health shows DEGRADED when the primary and one of the standby cells are online and operational, but the other standby cell is non-functional. The primary database is functional in this state, but if there is another database failure of either of the operational cells, the primary will become non-functional. The non-functional standby cell must be replaced with a new, functioning standby cell as soon as possible to restore the cluster to a Healthy state. The VMware Cloud Director UI and API are functional.

2. Cluster Health shows READ ONLY PRIMARY when there is an online primary database, but it is READ_ONLY because the environment does not have an operational standby cell. Two new standby cells must be deployed. The VMware Cloud Director UI and API are not available.

Resolution

For assistance, contact technical support and note this Knowledge Article ID (384987) in the problem description. For more information, see How to Submit a Support Request.