Error: This operation is not allowed because the system lock is held by #### operation in progress in SDDC Manager UI

Products

• VMware SDDC Manager / VCF Installer

Issue/Introduction

• Unable to decommission hosts or delete clusters in the SDDC Manager UI, the Delete Cluster option is greyed out.
  
  
• The task fails with: Failed with Fetch remove ESXi host(s) data from the SDDC manager inventory.

Environment

• VMware Cloud Foundation 4.x
  
  
• VMware Cloud Foundation 5.x

Cause

This issue occurs when a stale lock entry remains in the SDDC Manager platform database from a previous or interrupted operation, preventing new lifecycle tasks from acquiring the necessary resource lock.

Resolution

To resolve this issue, manually clear the stale lock from the SDDC Manager database.

1. Take a snapshot of the SDDC Manager VM.
   
   
2. Log in to the SDDC Manager via SSH as vcf and switch to root.
   
   
3. Identify the stale lock by running the following command:
   
   /usr/pgsql/13/bin/psql -h localhost -U postgres -d platform -c "select * from lock;"
   
    
4. Note the id of the lock related to the failed operation.
   
   
5. Delete the stale lock using the specific ID:
   
   /usr/pgsql/13/bin/psql -h localhost -U postgres -d platform -c "delete from lock where id='####';"
   
    
   (Replace #### with the actual lock ID found in step 3)
   
   
6. Retry the decommission or cluster deletion task from the SDDC Manager UI.

Additional Information

For further assistance Contact Broadcom Support.