Old tasks records prior to the retention policy days are not being purged from VCDB
search cancel

Old tasks records prior to the retention policy days are not being purged from VCDB

book

Article ID: 336285

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

Prevents pile up of task records in VCDB due to insufficient cleanup method.

Symptoms:
In the table VPX_TASK in vcdb, you will see task records prior to the retention policy days.

Environment

VMware vCenter Server 6.7.x

Cause

Insufficient cleanup method.

Resolution

This is a known issue. VMware is working on a solution.

Workaround:
  1. Putty session to vCenter.
  2. Download the attached file to /tmp/cleanup_tasks_PostgreSQL.sql available in the attached file. 
  3. Run below command:
/opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB -f /tmp/cleanup_tasks_PostgreSQL.sql


Attachments

cleanup_tasks_PostgreSQL get_app