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:

2017-09-29T15:39:32.495Z error vpxd[7FAED386C800] [Originator@6876 sub=Default] [VdbStatement] Execute result code: -1
2017-09-29T15:39:32.495Z error vpxd[7FAED386C800] [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 (?))
2017-09-29T15:39:32.495Z error vpxd[7FAED386C800] [Originator@6876 sub=Default] [VdbStatement] Execution elapsed time: 91 ms
2017-09-29T15:39:32.495Z error vpxd[7FAED386C800] [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 us 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