Aria Suite Lifecycle Manager 8.x cannot fetch any information and excessive slowness

Products

• VMware Aria Suite

Issue/Introduction

• To make sure all requests from Aria Suite Lifecycle Manager 8.x UI are executed without any delay.

Symptoms:

• Aria Suite Lifecycle Manager 8.x UI is unable to fetch any information.
• All operations from Aria Suite Lifecycle Manager 8.x UI are excessively slow and result in a timeout.
• The memory and the CPU utilization remain constantly spiked up on the Aria Suite Lifecycle Manager 8.x appliance.
• Adding more memory or CPU makes no difference.

Environment

Aria Suite Lifecycle Manager 8.x

Resolution

Workaround :

The workaround is to clean up the Aria Suite Lifecycle Manager 8.x database with VACUUM: The workaround is to clean up the Aria Suite Lifecycle Manager 8.x database with VACUUM

1. Take a snapshot of the Aria Suite Lifecycle Manager 8.x appliance from vCenter
2. SSH as root to the Aria Suite Lifecycle Manager 8.x Appliance
3. Connect to the Aria Suite Lifecycle Manager 8.x DB:
   • su - postgres
   • cd /opt/vmware/vpostgres/11/bin
   • ./psql -d vrlcm
4. Run the below query:
   • select count(*) from vm_rs_request where requestname='lcmgenricsetting';
5. to clean up DB:
   • Run VACUUM FULL VERBOSE ANALYZE vm_rs_request;
   • 
6. quit
7. Exit
8. Reboot the Aria Suite Lifecycle Manager 8.x VM.

Additional Information

Impact/Risks:
The issue can slow Aria Suite Lifecycle Manager 8.x performance.