I am using VC 4.0.0 build 208111 (updated to 4.0 U1), ESX 3.5 Build 226117
When ever I try to register a VM having multiple disks and having snapshots, then the vCenter Server
crashes with following error message:
ODBC
error: (23000) - [SQL Native Client][SQL Server]Cannot
insert duplicate key row in object 'dbo.VPX_VM_FLE_SNAPSHOT_DISK' with
unique index 'VPX_VM_FLE_SNAPSHOT_DISK_U1'." is returned when executing
SQL statement "INSERT INTO VPX_VM_FLE_SNAPSHOT_DISK WITH (ROWLOCK) (ID,
SNAPSHOT_ID, DISK_KEY, VM_ID,UPDATE_KEY) VALUES (?, ?, ?, ?, ?)
and only way to start vCenter Server is to remove the VM by connecting directly to ESX host.
I went through KB Article: 1012333, and made sure that my VM's virtual disks are all located with VM in the same datastore
and also renamed the disks using vmkfstools to have unique names using prescribed procedure. Any ideas will be appreciated.
Maybe some sort of CID conflict... can't imagine a thing like that, but anyway. I would be calling VMware Support for analyzing this one. If possible, to resolve the issue partially, you could consolidate the disk using "vmkfstools -i".
Also, if you could compare the content of this table and all CID's from your VM snapshots, you could determine if there is any conflict, and then change the parent and child CID, but this is a very sensible operation.
Marcelo Soares
VMWare Certified Professional 310/410
Virtualization Tech Master
Globant Argentina
Consider awarding points for "helpful" and/or "correct" answers.
Strange. Release notes report that this is solved in 208156 . Make sure that your release number is 100% greater. Then call to support.
---
iSCSI SAN software
http://www.starwindsoftware.com