Vcenter keeps crashing. Virtual center service stops

[samlouis55]

Hello,

I am doing lab with vmware virtual san using vmware workstation 11 with vmware vpshere 6. Whenever i simulate a failure of two nodes, when stardwinds starts synchronizing the vcenter service stops. I rebuilds my vcenter from scratch with the same issue. Here is the log of the vcenter:

The description for Event ID 1000 from source VMware VirtualCenter Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (23505) - ERROR: duplicate key value violates unique constraint "vpxi_psa_path"
Key (host_id, key_val)=(28, key-vim.host.PlugStoreTopology.Path-vmhba33:C0:T1: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, TARGET_ID, LUN_LINK_KEY, ADAPTER_LINK_KEY, TARGET_LINK_KEY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

the message resource is present but the message is not found in the string/message table


Please advise.

[darklight]

Where do the files of your VCenter Appliance reside? If they are stored on SW device, then it is an obvious behavior.

[samlouis55]

I am using Vcenter running under Windows server 2012. It is stored as a virtual machine running with vmware workstation 11. It is not stored under SW device.

[darklight]

Looks like it's a VCenter issue.
Maybe take a look here: http://kb.vmware.com/selfservice/micros ... Id=2099964

[samlouis55]

Well but that happens only i refresh the storage scan to appear the SW datastore after a reboot. If I don't use starwind, I never have this type of error. Why even i shutdown all the datastores gracefully and hosts, when i restart again, i have to manually synchronize in the starwind console and sometimes do a manual storage rescan to make appear the datastores.

[Oles (staff)]

Hello Samlouis55!

Unfortunately I do not know how can StarWind affect vCentre if its not using StarWind devices for its *.vmdk.

As for storage rescan and manual synchronization:
1) Storage rescan is required because StarWind service fires up after ESXi did his startup rescan. In order to avoid manual rescan, we have designed a script which triggers a rescan after StarWind sercive is up. Script and guidance for its configuration can be found in this document:
https://www.starwindsoftware.com/starwi ... re-vsphere
2) In case when 2 nodes go down, we meaningly not start automatic synchronization. I will provide an example where it leads to huge data loss. Example: You have 2 nodes hyper-converged cluster, some day 1 node goes offline and you never notice that because the system is fault tolerant and everything stays up and running. After a week, the second node goes offline as well and you definitely notice that. The first you usually do, is to bringing your production up, so you boot up first and second one. Then automatic synchronization bashes in and your data gets rolled back on 1 week.

Please let me know if you have any questions left. Thank you.