VPXD service fails to start in the vCenter

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• VPXD service crashes immediately after starting.
• Under /var/log/vmware/vpxd/vpxd.log, below log snippets are found:

YYYY-MM-DDTHH:MM:SS error vpxd[7FA#####800] [Originator@#### sub=Default] [VdbStatement] Execute result code: -1
YYYY-MM-DDTHH:MM:SS error vpxd[7FA#####800] [Originator@#### sub=Default] [VdbStatement] SQL execution failed: SELECT EVENT_ID, ARG_ID, ARG_TYPE, ARG_DATA, OBJ_TYPE, OBJ_NAME, VM_ID, HOST_ID, COMPUTERESOURCE_ID, DATASTORE_ID, NETWORK_ID, NETWORK_TYPE, DVS_ID, DATACENTER_ID, RESOURCEPOOL_ID, FOLDER_ID, ALARM_ID, SCHEDULEDTASK_ID FROM VPXV_EVENT_ARG WHERE (EVENT_ID IN (?))
YYYY-MM-DDTHH:MM:SS error vpxd[7FA#####800] [Originator@#### sub=Default] [VdbStatement] Execution elapsed time: 91 ms
YYYY-MM-DDTHH:MM:SS error vpxd[7FA#####800] [Originator@#### sub=Default] [VdbStatement] Statement diagnostic data from driver is XX002:0:7:ERROR: index "pk_vpx_event_arg_49" contains unexpected zero page at block 9;

 

 

Cause

This issue is caused by a corrupt index in a specific Table under vPostgres Database, due to abrupt/unexpected reboot of the vCenter.

Resolution

To resolve this issue, follow the steps below:

Note: Take Snapshot of the vCenter (Offline Snapshots if the vCenters are in linked mode).

1. Log into the vCenter Server as root via SSH or Console.
2. Access into the vPostgres database, using below command:
   
   /opt/vmware/vpostgres/current/bin/psql -U postgres VCDB
   
   
3. Run the following command to reindex vPostgres:
   
   reindex index <index_name>;
   
   Note: Replace <index_name> with the name of the index found in the /var/log/vmware/vpxd/vpxd.log.
   Example: reindex index pk_vpx_event_arg_49;


4. Exit vPostgres, using below command and hit Enter:
   \q
   
   
5. Start the vpxd service, using below command:
   
   service-control --start vmware-vpxd