VMware Cloud Community
jasmeetsinghsur
Enthusiast
Enthusiast

A database error occurred: ODBC error: () - Shutting down VMware VirtualCenter

We have a vCenter that is pointing to an external Database. All of a sudden all vCenter services stopped. vCenter is installed on a Windows 2012 server.

VPXD logs:

--> [backtrace begin] product: VMware VirtualCenter, version: 6.5.0, build: build-9451637, tag: vpxd, cpu: x86_64, os: windows, buildType: release
--> backtrace[00] vmacore.dll[0x001F436A]
--> backtrace[01] vmacore.dll[0x000684C0]
--> backtrace[02] vmacore.dll[0x0006A93E]
--> backtrace[03] vmacore.dll[0x000324F9]
--> backtrace[04] vpxd.exe[0x0073C3E4]
--> backtrace[05] vpxd.exe[0x00239FC2]
--> backtrace[06] vpxd.exe[0x0023AB5D]
--> backtrace[07] vpxd.exe[0x00486547]
--> backtrace[08] vpxd.exe[0x00486D97]
--> backtrace[09] vpxd.exe[0x01195E53]
--> backtrace[10] KERNEL32.DLL[0x000013D2]
--> backtrace[11] ntdll.dll[0x000154F4]
--> [backtrace end]
2019-09-01T13:31:24.716+05:30 info vpxd[38768] [Originator@6876 sub=vpxdVdb] Registry Item DB 5 value is ''
2019-09-01T13:31:24.716+05:30 info vpxd[38768] [Originator@6876 sub=vpxdVdb] Setting VDB delay statements queue size to 10000 transactions for 10 GB RAM dedicated to vpxd.
2019-09-01T13:31:24.716+05:30 info vpxd[38768] [Originator@6876 sub=vpxdVdb] [VpxdVdb::SetDBType] Logging in to DSN: vCenterDB with username SERVICE\adminvDB
2019-09-01T13:31:24.800+05:30 error vpxd[38768] [Originator@6876 sub=Default] A database error occurred: ODBC error: () -
2019-09-01T13:31:24.802+05:30 warning vpxd[38768] [Originator@6876 sub=Main] Database not initialized. Nothing to unlock
2019-09-01T13:31:24.802+05:30 info vpxd[38768] [Originator@6876 sub=Default] Forcing shutdown of VMware VirtualCenter now

Application logs from vCenter server

EVENT 1000: A database error occurred: ODBC error: () -

EVENT 1000: Failed to intialize VMware VirtualCenter. Shutting down

EVENT 1000: A database error occurred: ODBC error: () -

EVENT 1000: Log directory: C:\ProgramData\VMware\vCenterServer\logs\vmware-vpx.

EVENT 1000: Starting VMware VirtualCenter 6.5.0 build-9451637

EVENT 1000: Shutting down VMware VirtualCenter

EVENT 1000: Initiating VMware VirtualCenter shutdown

EVENT 103: svchost (26032) Instance: The database engine stopped the instance (0).

EVENT 327: svchost (26032) Instance: The database engine detached a database (1, C:\ProgramData\Microsoft\Windows\AppRepository\PackageRepository.edb). (Time=0 seconds)

Looking for an expert advice that what could have caused the services to stopped.

Thanks

Jasmeet Singh

Reply
0 Kudos
2 Replies
johncol
VMware Employee
VMware Employee

looks like your DB may have went offline, ergo VC will fall over. Is the DB a vm? was it been backed up, snapshot at the time.? Check the sql logs

Reply
0 Kudos
birend1988
Hot Shot
Hot Shot

Can you provide the entire vpxd.log.I wanted to check the error captured before vpxd written backtrace.

VCIX, NCAP
Reply
0 Kudos