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?
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.
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.
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!