vohra
Contributor
Contributor

vCenter Server Crash

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.

0 Kudos
2 Replies
marcelo_soares
Champion
Champion

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.

Marcelo Soares
0 Kudos
PaulSvirin
Expert
Expert

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

--- iSCSI SAN software http://www.starwindsoftware.com
0 Kudos