Storage Profiles Slow or Fail to Load in VCD UI

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:
When accessing pages in the vCloud Director UI that load Storage Profile items; those items do not load or take several minutes to load.

This issue can also affect API calls that load the same Storage Profile items.  This will cause API calls to fail or take several minutes to complete.

Environment

VMware Cloud Director 10.x

Cause

This issue is caused by the lack of an index in the database.

Resolution

This issue is resolved in Cloud Director version 10.3 or higher.

Workaround:

If the issue is occurring in 10.3 execute the following:

1. Execute the database backup as per documentation Backup and Restore of VMware Cloud Director Appliance
2. Run the following on the primary node: sudo -u postgres psql vcloud -c "ANALYZE;"

To manually add the index on vCloud Director versions 10.1 and 10.2

1. Execute the database backup as per documentation Backup and Restore of VMware Cloud Director Appliance
2. Login as root to the primary database node.
3. Login the postgres user with the command: su postgres
4. Connect to PostgreSQL with the command: psql vcloud
5. Create the needed index with the command: CREATE INDEX uq_spinv_vc_id_moref ON storage_profile_inv (vc_id, moref);
6. Exit PostgreSQL with the command: \q