9 Replies Latest reply on Apr 15, 2011 10:33 AM by mark.chuman

    VirtualCenter service stops during SQL2005 cluster failover

    ccastellow Novice

       

      I've noticed this on a few occasions, where the VirtualCenter server shuts down during a failover of the SQL2005 cluster that hosts the VC database.  The following events are logged:

       

       

      Event Type:    Error

      Event Source:    VMware VirtualCenter Server

      Event Category:    None

      Event ID:    1000

      Date:        8/7/2009

      Time:        1:15:30 PM

      User:        N/A

      Computer:   

       

       

      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: Error[VdbODBCError] (-1) "ODBC error: (42000) - [SQL Native Client][SQL Server]SHUTDOWN is in progress." is returned when executing SQL statement "UPDATE VPX_ENTITY SET NAME = ? , TYPE_ID = ? , PARENT_ID = ? WHERE ID = ?".

       

       

      ...and then:

       

       

      Event Type:    Information

      Event Source:    VMware VirtualCenter Server

      Event Category:    None

      Event ID:    1000

      Date:        8/7/2009

      Time:        1:15:30 PM

      User:        N/A

      Computer:   

       

       

      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.

       

       

      The service stays down until it is manually restarted.  The service is configured to restart upon a failure, but if the service is being shutdown (technically not a failure, right?) then this does little to help.  Ideas or suggestions would be greatly appreciated.

       

       

      Thanks