vRealize Suite Lifecycle Manager 8.x cannot fetch any information and excessive slowness
search cancel

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

book

Article ID: 345992

calendar_today

Updated On:

Products

VMware Aria Suite

Issue/Introduction

  • To make sure all requests from vRLCM UI are executed without any delay.


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


Environment

VMware vRealize Suite Lifecycle Manager 8.x

Resolution

See workaround section.

Workaround:
  • The workaround is to clean up the vRLCM database with VACUUM:The workaround is to clean up the vRLCM database with VACUUM
  1. Take a snapshot of the vRLCM appliance from vCenter
  2. SSH as root to the vRLCM Appliance
  3. Connect to the vRLCM 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:
    • Ran VACUUM FULL VERBOSE ANALYZE vm_rs_request;
    • image.png
  6. quit
  7. Exit
  8. Reboot the vRLCM VM.
 


Additional Information

  • https://dba.stackexchange.com/questions/126258/what-is-table-bloating-in-databases


Impact/Risks:
The issue can slow vRealize Suite Lifecycle Manager performance.