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?
