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:
- Putty session to vCenter.
- Download the attached file to /tmp/cleanup_tasks_PostgreSQL.sql available in the attached file.
- Run below command:
/opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB -f /tmp/cleanup_tasks_PostgreSQL.sql
Feedback
thumb_up
Yes
thumb_down
No