VPXD services fails to start

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• VPXD services fails to start.
• In the vpxd logs you see similar errors to:

YYYY-MM-DDTHH:MM:SS.Z error vpxd[7FA#####800] [Originator@6876 sub=Default] [VdbStatement] Execute result code: -1
YYYY-MM-DDTHH:MM:SS.Z error vpxd[7FA#####800] [Originator@6876 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.Z error vpxd[7FA#####800] [Originator@6876 sub=Default] [VdbStatement] Execution elapsed time: 91 ms
YYYY-MM-DDTHH:MM:SS.Z error vpxd[7FA#####800] [Originator@6876 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 due to hardware or software.

Resolution

To resolve this issue, reindex vPostgres:

1) Log into the vCenter Server as root via SSH or Console.

2) Enter the shell by running the following command:
shell

3) Log into the vPostgres database:
/opt/vmware/vpostgres/current/bin/psql -U postgres VCDB

4) Run the following command to reindex vPostgres:
reindex index <index_name>;

Note: Replace index_name with the name of the index found in the vpxd logs.
Example: reindex index pk_vpx_event_arg_49;

5) Exit vPostgres:
\q

6) Start the vpxd service:
service-control --start vmware-vpxd