vCenter's vpxd service will not start. vpxd.log has entries similar to: "ODBC error: (XX000)"

Products

• VMware vCenter Server

Issue/Introduction

vCenter's vpxd service will not start.

vpxd.log will contain entries similar to: 
YYYY-MM-DDTXX:XX:XX.XXX-05:00 error vpxd[06141] [Originator@6876 sub=Default] [VdbStatement] SQLError was thrown: "ODBC error: (XX000) - ERROR: MultiXactId XXXXXXX has not been created yet -- apparent wraparound;
--> Error while executing the query" is returned when executing SQL statement "SELECT ESX_AGENT_VM_STATE,LOCAL_FILE_NAME,AGENT_CNX_STATE,AGENT_ID,IS_TEMPLATE,DISABLED_SNAPSHOT,MEM_SIZE_MB,NUM_VCPU,POWER_STATE,RESOURCE_GROUP_ID,HOST_ID,DATACENTER_ID,ID,FILE_NAME FROM VPX_VM"

Environment

vCenter Server 8.x

Cause

This issue occurs when the postgres DB has corrupted table entries, either due to the database completely filling up, or a sudden storage failure while the vCenter was running. 

Resolution

Restore vCenter from backup