error vpxd[7F0A2BF7E700] [Originator@6876 sub=Default opID=HB-host-138705@1388461-4a534d61">opID=HB-host-138705@1388461-4a534d61 ] [VdbStatement] SQLError was thrown: "ODBC error: (23505) - ERROR: duplicate key value violates unique constraint "vpxi_psa_path"
--> Key (host_id, key_val)=(138705, key-vim.host.PlugStoreTopology.Path-vmhba39:C0:T8:L0) already exists.;
--> Error while executing the query" is returned when executing SQL statement "INSERT INTO VPX_PSA_PATH (HOST_ID, PATH_ID, KEY_VAL, LUN_NUMBER, SCSI_LUN_ID, HBA_ID, TAR
GET_ID, LUN_LINK_KEY, ADAPTER_LINK_KEY, TARGET_LINK_KEY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Key (host_id, key_val)=(138705, key-vim.host.PlugStoreTopology.Path-vmhba39:C0:T8:L0) already exists.;
Key (host_id, key_val)=(147971, key-vim.host.PlugStoreTopology.Path-vmhba44:C5:T3:L0) already exists.;
This issue is resolved in vCenter Server 6.5 U2, available for download at VMware Download. For more information, see the vCenter Server 6.5 Update 2 Release Notes.
To workaround this issue, truncate the VPX_PSA_PATH
table.
To truncate the VPX_PSA_PATH
table:
service-control --stop vmware-vpxd
/opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
VPX_PSA_PATH
table by running this command:VPX_PSA_PATH
service-control --start vmware-vpxd