/storage/seat partition filled 100% and unable to perform vacuumdb or truncate the table in vCenter 8.0U3

Products

• VMware vCenter Server

Issue/Introduction

• /storage/seat partition is full on vCenter server and steps in the KB /storage/seat disk 100% full on vCenter Server Appliance 6.x/7.x/8.x do not help
• df -h displays the following
  
  /dev/mapper/seat_vg-seat                   49G   47G     0 100% /storage/seat

• vCenter services fails to start 
• From VCDB, the below command can be used to list the largest tables in database:
  
  VCDB=# SELECT nspname || '.' || relname AS "relation", pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') AND C.relkind <> 'i' AND nspname !~ '^pg_toast' ORDER BY pg_total_relation_size(C.oid) DESC LIMIT 20;
          relation           | total_size
------------------------------+------------
 vc.vpx_task                  | 29 GB

• Unable to run vacuumdb or truncate table
  
  su -c "/opt/vmware/vpostgres/current/bin/vacuumdb -d VCDB -e -v -f -U postgres > /tmp/vacuumdb.log"
vacuumdb: error: processing of database "VCDB" failed: ERROR: could not extend file "pg_tblspc/16429/PG_14_202107181/16386/12767698": No space left on device

truncate table vc.vpx_task cascade;
ERROR: could not extend file "pg_tblspc/16429/PG_14_202107181/16386/12747948": No space left on device
HINT: Check free disk space.

Environment

VMware vCenter Server 8.0.x

Cause

This is because there is no buffer space to perform the truncate/vacuum on the vCenter server.

Resolution

Workaround

Increase the space for the /storage/seat partition on vCenter server.

If issues continue after expanding the storage partition, contact Broadcom Support for assistance.