any idea?
df -h shows this
For urgent "systems down" situations, open a SR with GSS.
You will need cleanup /storage/seat mount. This has to be done by logging into VCDB.
Log into DB:
/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
List top 20 tables by disk usage (https://wiki.postgresql.org/wiki/Disk_Usage 😞
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;
and truncate any events or tasks.
in vSphere 6.5 and above, vcenter server has a algorithm where it will shutdown vpxd service automatically if the db/seat partition is 95% to avoid failures. In your case it is /storage/seat which is 95%.. Please increase the /storage/seat disk using the kb VMware Knowledge Base
Increase for 5GB post that start vpxd service and then contact GSS to do cleanup
Thanks,
MS