Error "Still referenced from table “vpx_compute_res_user_hb_ds”

Products

• VMware vCenter Server

Issue/Introduction

Unable to delete Cluster, receiving an error of "The operation is not allowed in the current state. Cluster destroy is not allowed on * Cluster when it is acting as remote vSAN client cluster.

Environment

vCenter 8.0.3

Cause

The vSAN storage was disabled and all the host removed from the cluster.

Yet, the postgres DB still has a couple of entries that will need to manually deleted.

Resolution

The postgres DB will needs to be edited.

We worked through KB Manually deleting a cluster from the vCenter Server database 

       https://broadcomcms-software-agent.wolkenservicedesk.com/wolken/esd/knowledge-base-view/view-kb-article?articleNumber=322840&isLocationBackOnHome=true&hideTabs=true 

• In looking at KB 322840
• If you see an output with the following, it will need to be addressed first before trying to remove the cluster.

         

• Run the following for the above message: 

  # SELECT * FROM vpx_compute_res_user_hb_ds WHERE comp_res_id = *****

• Then run the following to delete it:

         # DELETE FROM vpx_compute_res_user_hb_ds WHERE comp_res_id = ******;

       

• Then run the following to delete the cluster:

        # delete from vpx_entity where name = ‘cluster name’;