Tenant Resource Metric not updating when VMs/Vapps are removed

Products

• VMware Cloud Director

Issue/Introduction

Resource utilization shows wrong value even though we have removed VMs/Vapps from OrgVDC

Environment

10.3.x,10.4.x

Cause

Some task \ Job is blocking to run Metric workflow

Resolution

This issue is fixed in Vcloud Director 10.5

Note:

• Take DB backup before executing commands and make sure no tasks are running while executing the command.
• Metric gets refreshed every 5 minutes.

Workaround:

To fix Metric workflow, follow below steps to delete any job stopping the update:

1. 1. Connect SSH to Primary cell
   2. Switch to postgres user

      su postgres

   3. To connect database type a command 

      psql

   4. Switch from "Postgres" DB to "Vcloud" DB 

      \c vcloud

   5. To delete any job which is blocking to run the metric workflow

      truncate table activity;
      truncate table scheduled_activity_jobs;
      truncate table activity_pc_queue;
      truncate table activity_pc_event_queue;
      truncate table fifo_activity_queue;
      truncate table task_activity_queue;
      truncate table vc_activity_queue;

   6. Metric workflow is common parameter which VCD initiates automatically,when the workflow is called, but the metric command is not working for some reasons and the reason might be that another workflow is stopping or causing this problem