VMware Cloud Community
tdubb123
Expert
Expert

urgent vmware-vpxd on vcsa terminates

any idea?

df -h shows this

Screen Shot 2019-10-10 at 7.01.38 AM.png

0 Kudos
3 Replies
daphnissov
Immortal
Immortal

For urgent "systems down" situations, open a SR with GSS.

0 Kudos
Vijay2027
Expert
Expert

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.

0 Kudos
msripada
Virtuoso
Virtuoso

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

0 Kudos