IKirill
Enthusiast
Enthusiast

Vcenter 5.5 and SQL 2008 - Error in module KERNELBASE.dll

Jump to solution

Hi!

I have VC 5.5u3e on Windows Machine

and have SQL server 2008r2 on another machine

Problem: Vcenter stops after starting

Faulting application name: vpxd.exe, version: 5.5.0.47851, time stamp: 0x57989851

Faulting module name: KERNELBASE.dll, version: 6.3.9600.19178, time stamp: 0x5bc006fd

Exception code: 0xe06d7363

Fault offset: 0x0000000000008e6c

Faulting process id: 0xe40

Faulting application start time: 0x01d551b43fd81620

Faulting application path: C:\Program Files\VMware\Infrastructure\VirtualCenter Server\vpxd.exe

Faulting module path: C:\Windows\system32\KERNELBASE.dll

Report Id: 37609500-bdaa-11e9-80fd-005056927c7b

Faulting package full name:

Faulting package-relative application ID:

some text from vpxd:

2019-08-13T12:10:45.475+03:00 [07560 warning 'win32vpxdOsLayer_win32'] [VpxUnhandledException] Backtrace

--> backtrace[00] rip 000000018018c5da

--> backtrace[01] rip 0000000180105408

--> backtrace[02] rip 000000018010675e

--> backtrace[03] rip 00007ff6141fe0da

------ In-memory logs start --------

mem> ansaction is detected at the end of the batch. The transaction is rolled back.

mem> 2019-08-13T12:10:45.447+03:00 [11604 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-42054 (with vmid 11) on host esx1.ro79.fss.ru for given vmid 11

mem> 2019-08-13T12:10:45.447+03:00 [10636 warning 'Default'] [VdbStatement] Bind parameters:

mem> 2019-08-13T12:10:45.447+03:00 [10636 warning 'Default'] [VdbStatement] datatype: 1, size: 4, arraySize: 23

mem> 2019-08-13T12:10:45.447+03:00 [10636 warning 'Default'] [VdbStatement] value = 64444

mem> 2019-08-13T12:10:45.447+03:00 [10636 warning 'Default'] [VdbStatement] datatype: 1, size: 4, arraySize: 23

mem> 2019-08-13T12:10:45.447+03:00 [10636 warning 'Default'] [VdbStatement] value = 0

mem> 2019-08-13T12:10:45.447+03:00 [10636 warning 'Default'] [VdbStatement] datatype: 3, size: 8, arraySize: 23

mem> 2019-08-13T12:10:45.448+03:00 [10636 warning 'Default'] [VdbStatement] value = 64174248

mem> 2019-08-13T12:10:45.448+03:00 [10636 warning 'Default'] [VdbStatement] datatype: 1, size: 4, arraySize: 23

mem> 2019-08-13T12:10:45.448+03:00 [10636 warning 'Default'] [VdbStatement] value = 3238

mem> 2019-08-13T12:10:45.448+03:00 [10636 error 'Default'] [Vdb::IsRecoverableErrorCode] Unable to recover from 42000:3998

mem> 2019-08-13T12:10:45.448+03:00 [10636 error 'Default'] [VdbStatement] SQLError was thrown: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 11.0][SQL Server]Uncommittable transaction is detected at the end of the batch. The transaction is rolled back." is returned when executing SQL statement "{ call insert_stats_proc(?, ?, ?, ?) }"

mem> 2019-08-13T12:10:45.448+03:00 [10636 error 'clustervpxdMoCluster'] ClusterMo::CollectLocal database error while flushing stats data: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 11.0][SQL Server]Uncommittable transaction is detected at the end of the batch. The transaction is rolled back." is returned when executing SQL statement "{ call insert_stats_proc(?, ?, ?, ?) }"

mem> 2019-08-13T12:10:45.448+03:00 [11840 verbose 'commonvpxTaskInfo' opID=QS-host-51603-5167c51e] [TaskInfoPublisher::IncListeners] host:[host-51603] Return after successful IncListeners (listeners = 2, _connectionGen = 2)

mem> 2019-08-13T12:10:45.448+03:00 [11840 verbose 'commonvpxTaskInfo' opID=QS-host-51603-5167c51e] [TaskInfoListener::TaskInfoListener] copy-constructed. Connection number = 2

mem> 2019-08-13T12:10:45.448+03:00 [10636 verbose 'statsvpxdStatsCollector'] Enter FlushInt()

mem> 2019-08-13T12:10:45.448+03:00 [11840 verbose 'commonvpxTaskInfo' opID=QS-host-51603-5167c51e] TaskInfoChannel created for session[6d8048d0-4b20-14f1-0816-a5ce7d3ea4fd]52c819d4-6e3a-a8c0-579f-8e62044c7fb2

mem> 2019-08-13T12:10:45.448+03:00 [11840 verbose 'commonvpxTaskInfo' opID=QS-host-51603-5167c51e] [TaskInfoPublisher::AddChannel] host:[host-51603] Channel (session[6d8048d0-4b20-14f1-0816-a5ce7d3ea4fd]52c819d4-6e3a-a8c0-579f-8e62044c7fb2) added for task: session[6d8048d0-4b20-14f1-0816-a5ce7d3ea4fd]52c819d4-6e3a-a8c0-579f-8e62044c7fb2

mem> 2019-08-13T12:10:45.448+03:00 [11604 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-42050 (with vmid 21) on host esx1.ro79.fss.ru for given vmid 21

mem> 2019-08-13T12:10:45.448+03:00 [11840 verbose 'commonvpxTaskInfo' opID=QS-host-51603-5167c51e] [TaskInfoChannel::GetTaskInfo] task: session[6d8048d0-4b20-14f1-0816-a5ce7d3ea4fd]52c819d4-6e3a-a8c0-579f-8e62044c7fb2 setup for async notification

mem> 2019-08-13T12:10:45.448+03:00 [11604 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-42052 (with vmid 25) on host esx1.ro79.fss.ru for given vmid 25

mem> 2019-08-13T12:10:45.448+03:00 [11604 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-44865 (with vmid 26) on host esx1.ro79.fss.ru for given vmid 26

mem> 2019-08-13T12:10:45.448+03:00 [11604 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-42058 (with vmid 27) on host esx1.ro79.fss.ru for given vmid 27

mem> 2019-08-13T12:10:45.449+03:00 [12780 verbose 'PropertyProvider'] RecordOp ASSIGN: disabledMethod, vm-333961

mem> 2019-08-13T12:10:45.449+03:00 [07560 verbose 'Default' opID=task-internal-1-2244a405-64-81-3a-1f] [JrnlFilePersistenceProvider::DeleteJournal] Deleting C:\ProgramData\VMware\VMware VirtualCenter\journal\1565687249.39.

mem> 2019-08-13T12:10:45.450+03:00 [13152 verbose 'Default' opID=525C109D-000000CD-70] [VpxVmomi] Invoke done: vmodl.query.PropertyCollector.waitForUpdates session: 182ffcf7-eaa2-4130-9ace-f5406219632f

mem> 2019-08-13T12:10:45.450+03:00 [13152 verbose 'SoapAdapter.HTTPService' opID=525C109D-000000CD-70] HTTP Response: Complete (processed 1214 bytes)

mem> 2019-08-13T12:10:45.451+03:00 [12976 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-46214 (with vmid 3) on host 10.58.105.133 for given vmid 3

mem> 2019-08-13T12:10:45.451+03:00 [05168 verbose 'Default' opID=72fe638f] [VpxVmomi] Invoking [retrievePropertiesEx] on [vmodl.query.PropertyCollector:propertyCollector] session [8224ffd4-b241-b0dd-cb73-6086c5720462(527742e8-d692-67db-ecc6-c5b610603cad)]

mem> 2019-08-13T12:10:45.451+03:00 [13152 info 'commonvpxLro' opID=72fe638f] [VpxLRO] -- BEGIN task-internal-70159 --  -- vmodl.query.PropertyCollector.retrievePropertiesEx -- 8224ffd4-b241-b0dd-cb73-6086c5720462(527742e8-d692-67db-ecc6-c5b610603cad)

mem> 2019-08-13T12:10:45.452+03:00 [11208 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-32075 (with vmid 2) on host esx1.f09.ro2.fss.ru for given vmid 2

mem> 2019-08-13T12:10:45.452+03:00 [11208 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-32074 (with vmid 3) on host esx1.f09.ro2.fss.ru for given vmid 3

mem> 2019-08-13T12:10:45.452+03:00 [11208 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-32076 (with vmid 4) on host esx1.f09.ro2.fss.ru for given vmid 4

mem> 2019-08-13T12:10:45.452+03:00 [12976 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-46215 (with vmid 4) on host 10.58.105.133 for given vmid 4

mem> 2019-08-13T12:10:45.452+03:00 [11604 verbose 'vpxdvpxdMoHost'] [HostMo::GetLinkedVmInt] Getting linked vm vm-465025 (with vmid 28) on host esx1.ro79.fss.ru for given vmid 28

mem> 2019-08-13T12:10:45.453+03:00 [01912 info 'vpxdvpxdVmomi' opID=HB-host-28758@347601-497fe794] [ClientAdapterBase::InvokeOnSoap] Invoke done (esx1.ro51.fss.ru, vmodl.query.PropertyCollector.cancelWaitForUpdates)

mem> 2019-08-13T12:10:45.453+03:00 [07560 error 'commonvpxLro' opID=task-internal-1-2244a405-64-81-3a-1f] [VpxLRO] Unexpected Exception: vmodl.fault.SystemError

mem> 2019-08-13T12:10:45.453+03:00 [07560 verbose 'commonvpxLro' opID=task-internal-1-2244a405-64-81-3a-1f] [VpxLRO] Backtrace:

mem> --> backtrace[00] rip 000000018018c5da

mem> --> backtrace[01] rip 0000000180105408

mem> --> backtrace[02] rip 000000018010675e

Any Ideas?

0 Kudos
1 Solution

Accepted Solutions
MartinGustafsso
VMware Employee
VMware Employee

There seems to be an issue with the database, "SQLError was thrown: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 11.0][SQL Server] Uncommittable transaction is detected at the end of the batch. The transaction is rolled back." is returned when executing SQL statement "{ call insert_stats_proc(?, ?, ?, ?) }".

Is the database fully operational? Has there been any changes recently? Did it ever work? Do you have any backups?

Note that vCenter 5.5 is no longer covered by general support.

View solution in original post

0 Kudos
2 Replies
MartinGustafsso
VMware Employee
VMware Employee

There seems to be an issue with the database, "SQLError was thrown: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 11.0][SQL Server] Uncommittable transaction is detected at the end of the batch. The transaction is rolled back." is returned when executing SQL statement "{ call insert_stats_proc(?, ?, ?, ?) }".

Is the database fully operational? Has there been any changes recently? Did it ever work? Do you have any backups?

Note that vCenter 5.5 is no longer covered by general support.

0 Kudos
IKirill
Enthusiast
Enthusiast

Thx Martin for answer!

You are rignt!

I go to sql management studio and see that no space for DB!

After add more space the error go away!

0 Kudos