Hi,
On my VC2.5 server (Windows XP using sql2005 express from VC 2.5 install), I am having a problem with the VMware VirtualCenter Server Service stopping. When I see I have been kicked off (from the client error message) I go to the server and see that the service is stopped and I manually start it without a problem. This is causing problems with automated testing we are running.
I get the following, in order:
Event Type: Error
Event Source: VMware VirtualCenter Server
Event Category: None
Event ID: 1000
Date: 7/19/2008
Time: 3:48:24 AM
Description:
The description for Event ID ( 1000 ) in Source ( VMware VirtualCenter Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Check database connectivity before restarting. Error: ErrorVdbODBCError (-1) "ODBC error: (40001) - MicrosoftSQL Native ClientSQL ServerTransaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." is returned when executing SQL statement "SELECT vpx_vm.id FROM vpx_vm LEFT JOIN vpx_ip_address ON vpx_vm.id = vpx_ip_address.entity_id WHERE (vpx_vm.ip_address = ? OR vpx_ip_address.ip_address = ?) AND vpx_vm.is_template = 0".
Then I get:
Event Type: Information
Event Source: VMware VirtualCenter Server
Event Category: None
Event ID: 1000
Date: 7/19/2008
Time: 3:48:24 AM
Description:
The description for Event ID ( 1000 ) in Source ( VMware VirtualCenter Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Forcing shutdown of VMware VirtualCenter now.
Then there are a few MSSQL messages:
Event Type: Information
Event Source: MSSQL$SQLEXP_VIM
Event Category: (2)
Event ID: 2803
Date: 7/19/2008
Time: 3:48:25 AM
Description:
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
Event Type: Information
Event Source: MSSQL$SQLEXP_VIM
Event Category: (2)
Event ID: 2803
Date: 7/19/2008
Time: 3:48:25 AM
Description:
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
Event Type: Information
Event Source: MSSQL$SQLEXP_VIM
Event Category: (2)
Event ID: 2803
Date: 7/19/2008
Time: 3:48:25 AM
Description:
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
Any ideas?
