This weekend; I came back home and found my vCenter was crashing. I investigated and was able to solve this error. While this is not a full root cause analysis it will gives you an idea on how to fix the issues if you encounter the same issue.
My VCMA was still fully functional working, but I found one services was not starting:
VPXD ( Listed in VCMA as “VMWare vCenter Server”)
So I started by SSHing into my Appliance and running the below tail command:
tail /var/log/vmware/vxpd/vpxd.log -f
I restarted the service via. The VCMA and monitored. When the crash happened, I scanned the log I found the error was coming from:
"INSERT INTO VPX_TASK (TASK_ID,NAME,DESCRIPTIONID,ENTITY_ID,ENTITY_TYPE,ENTITY_NAME,LOCKED_DATA,COMPLETE_STATE,CANCELLED,CANCELLABLE,ERROR_DATA,RESULT_DATA,REASON_DATA,QUEUE_TIME,EVENT_CHAIN_ID,USERNAME,DESCRIPTION) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" 2021-04-03T18:49:18.001-05:00 panic vpxd
I found a similar issue, but unfortunately it was for an older vCenter Version, but it was good starting point.
I connected to the Postgres DB and truncated the table mentioned in the error. I did this by running the following two commands.
/opt/vmware/vpostgres/12/bin/psql -d VCDB Postgres
TRUNCATE TABLE vpx_task CASCADE;
I started the service and my vCenter is up and humming. If you have this same issue, hope this post helps you resolve it.