Hi!
I have VC 6.0 on windows server..
Today i reboot my VC,
Now the service starts, runs for a while, then goes into a panic.
In windows logs i see this:
The VMware VirtualCenter Server service terminated unexpectedly. It has done this 4 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.
In VPXD log i see this:
2020-01-19T23:06:13.716+03:00 warning vpxd[14044] [Originator@6876 sub=Default opID=9678F612-0000003A-73] [VdbStatement] SQL execution took too long: SELECT EVENT_ID, CHAIN_ID, EVENT_TYPE, EXTENDED_CLASS, CREATE_TIME, USERNAME, CATEGORY, VM_ID, VM_NAME, HOST_ID, HOST_NAME, COMPUTERESOURCE_ID, COMPUTERESOURCE_TYPE, COMPUTERESOURCE_NAME, DATACENTER_ID, DATACENTER_NAME, DATASTORE_ID, DATASTORE_NAME, NETWORK_ID, NETWORK_NAME, NETWORK_TYPE, DVS_ID, DVS_NAME, STORAGEPOD_ID, STORAGEPOD_NAME, CHANGE_TAG_ID FROM VPX_EVENT WHERE HOST_ID=? AND VM_ID IS NULL AND (EVENT_TYPE IN (?,?,?)) AND EVENT_ID<? ORDER BY EVENT_ID DESC
2020-01-19T23:06:13.716+03:00 warning vpxd[14044] [Originator@6876 sub=Default opID=9678F612-0000003A-73] [VdbStatement] Execution elapsed time: 17690 ms
2020-01-19T23:06:50.739+03:00 warning vpxd[16252] [Originator@6876 sub=VpxProfiler opID=ProcessPerfResults-5ca58d21] ProcessPerfResults [TotalTime] took 105288 ms
Any ideas on how to make VC work more stable?
The first thing I would check is the database server and/or vCenter database. Is it up and running? And also performing as it should?
thanks for reply jburen !
I delete snapshots from vc and sql db vms
now service work fine.
I keep watching.
I don't know why you made the snapshots but don't rely on them as a backup. Especially for a database server. And I would plan an upgrade for your vCenter server 😉