Search the VMware Knowledge Base (KB)
View by Article ID

VMware vCenter Server 5.1, 5.5 or 6.0 fails after an ESXi host synchronization (2099964)

  • 5 Ratings

Symptoms

  • VMware VirtualCenter Server service fails.
  • In the C:\ProgramData\VMware\VMware VirtualCenter\Logs\vpxd.log file, you see entries similar to:

    • <YYYY-MM-DD>T<TIME>[03556 error 'Default' opID=HB-host-77@115-196633de] [VdbStatement] SQLError was thrown: "ODBC error: (23000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'VMW.VPX_PSA_PATH' with unique index 'VPXI_PSA_PATH'. The duplicate key value is (77, key-vim.host.PlugStoreTopology.Path-fc.20000025b5011129:20000025b501b129-fc.50060160c7207c5c:5006016747207c5c-naa.6006016042902c00d05cadfe4a91e211)." is returned when executing SQL statement "INSERT INTO VPX_PSA_PATH WITH (ROWLOCK) (HOST_ID, PATH_ID, KEY_VAL, NAME, CHANNEL_NUMBER, TARGET_NUMBER, LUN_NUMBER, SCSI_LUN_ID, HBA_ID, TARGET_ID, LUN_LINK_KEY, ADAPTER_LINK_KEY, TARGET_LINK_KEY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

    • <YYYY-MM-DD>T<TIME> [11196 warning 'Default' opID=HB-host-19280@111-6d70601] [VdbStatement] SQL execution failed: INSERT INTO VPX_LUN_TARGET WITH (ROWLOCK) (SCSI_TARGET_ID, SCSI_LUN_ID, L
      UN_VAL, KEY_VAL, LINK_KEY, HOST_ID, UPDATE_KEY) VALUES (?, ?, ?, ?, ?, ?, ?)
      ... <YYYY-MM-DD>T<TIME> [11196 error 'Default' opID=HB-host-19280@111-6d70601] [VdbStatement] SQLError was thrown: "ODBC error: (23000) - [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_LUN_TARGET'. Cannot insert duplicate key in object 'dbo.VPX_LUN_TARGET'. The duplicate key value is (1526, 708)." is returned when executing SQL statement "INSERT INTO VPX_LUN_TARGET WITH (ROWLOCK) (SCSI_TARGET_ID, SCSI_LUN_ID, LUN_VAL, KEY_VAL, LINK_KEY, HOST_ID, UPDATE_KEY) VALUES (?, ?, ?, ?, ?, ?, ?)" <YYYY-MM-DD>T<TIME> [11196 error 'utilvpxdDbSave' opID=HB-host-19280@111-6d70601] [VpxdDbSave::ProcessInsertsInOrder] Failed to insert 1 records into the DB <YYYY-MM-DD>T<TIME> [11196 error 'Default' opID=HB-host-19280@111-6d70601] Alert:false@ d:/build/ob/bora-1123961/bora/vim/lib/vdb/vdb.cpp:3523 --> Backtrace: --> backtrace[00] rip 000000018018aa3a --> backtrace[01] rip 0000000180102b18 --> backtrace[02] rip 0000000180103f3e --> backtrace[03] rip 0000000180099a6a --> backtrace[04] rip 0000000140eba8a4 --> backtrace[05] rip 00000001417b5b35 --> backtrace[06] rip 0000000073e14830 --> backtrace[07] rip 0000000073de3489 --> backtrace[08] rip 0000000073de4f93 --> backtrace[09] rip 0000000073de4b36 --> backtrace[10] rip 0000000073de502b --> backtrace[11] rip 00000000774e9dad --> backtrace[12] rip 00000000774d8a4c --> backtrace[13] rip 00000000772d050e --> backtrace[14] rip 0000000073de5425 --> backtrace[15] rip 0000000073de4220 --> backtrace[16] rip 0000000073de4896 --> backtrace[17] rip 0000000073de4c1d --> backtrace[18] rip 0000000073de502b --> backtrace[19] rip 00000000774e9d2d --> backtrace[20] rip 00000000774d91cf --> backtrace[21] rip 00000000774d97c8 --> backtrace[22] rip 000007fefd72940d --> backtrace[23] rip 0000000073de3bb8 --> backtrace[24] rip 0000000077510c51 --> backtrace[25] rip 00000001401e15e3 --> backtrace[26] rip 00000001401e18f7 --> backtrace[27] rip 0000000140206fdb --> backtrace[28] rip 00000001402074f6 --> backtrace[29] rip 00000001401d8c98 --> backtrace[30] rip 00000001409bda44 --> backtrace[31] rip 00000001409c5af5 --> backtrace[32] rip 0000000140ae1984 --> backtrace[33] rip 00000001409a9e6b --> backtrace[34] rip 00000001409a1c3d

    • <YYYY-MM-DD>T<TIME> [11196 info 'Default' opID=HB-host-19280@111-6d70601] CoreDump: Writing minidump <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe02b04.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b05.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b06.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe02b09.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b10.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [00784 info 'commonvpxLro' opID=c8e24457] [VpxLRO] -- BEGIN task-internal-74485 -- -- vim.LicenseAssignmentManager.queryAssignedLicenses -- 6281c621-ddfa-b44a-16b0-c7097abc4fa4(5201f417-b38b-a197-86fd-c7da825601b2) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b08.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b07.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b13.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b09.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09488 info 'vpxdvpxdVmomi' opID=SWI-62c0b47f] [ClientAdapterBase::InvokeOnSoap] Invoke done (pesxe01b11.ci.org, vpxapi.VpxaService.fetchQuickStats) <YYYY-MM-DD>T<TIME> [09928 info 'vpxdvpxdInvtHostCnx' opID=SWI-1b383ad8] [VpxdIntHost] Missed 2 heartbeats for host pesxe02b04.ci.org <YYYY-MM-DD>T<TIME> [08272 info 'commonvpxLro' opID=HB-host-19280@126-767b81a4] [VpxLRO] -- BEGIN task-internal-74486 -- host-19280 -- VpxdInvtHostSyncHostLRO.Synchronize -- <YYYY-MM-DD>T<TIME> [11196 error 'Default' opID=HB-host-19280@111-6d70601] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (23000) - [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_LUN_TARGET'. Cannot insert duplicate key in object 'dbo.VPX_LUN_TARGET'. The duplicate key value is (1526, 708)." is returned when executing SQL statement "INSERT INTO VPX_LUN_TARGET WITH (ROWLOCK) (SCSI_TARGET_ID, SCSI_LUN_ID, LUN_VAL, KEY_VAL, LINK_KEY, HOST_ID, UPDATE_KEY) VALUES (?, ?, ?, ?, ?, ?, ?)"

      Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.

Cause

This issue occurs when an entry within the vCenter Server is removed within the vCenter Server cache but not committed to the vCenter Server database. When a host synchronizes to the vCenter Server, vCenter Server may attempt to add an entry to the vCenter Server database that already exists and an exception is thrown causing the VMware VirtualCenter Server service to fail.

Resolution

This is a known issue affecting vCenter Server 5.1, 5.5 and 6.0.

This issue is resolved in:

See Also

Update History

07/28/2015 - Added vCenter Server 6.0 01/22/2016 - Added the details of the vCenter Server 6.0 Update 1b resolution.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 5 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 5 Ratings
Actions
KB: