Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to do a failover SQL MSCS

Status
Not open for further replies.

defstar123

Technical User
Jul 21, 2009
1
NL
2 w2003 enterprise edition servers running SQL 2005
Since a long time it is not possible to do a failover to the passive node. No clues what has changed between that time and now.

I will attach the part of the log when i tried to first do a manual failover and then a failover by rebooting the active node.

Any ideas?
 
I'd say your dependencies are a bit messed up,

000004c8.00000f9c::2009/06/25-17:38:37.580 INFO [FM] FmpOfflineResource: SQL Disk S: depends on SQL IP Address1(SQLCLUSTERSERVERNAME). Shut down first.
000004c8.00000f9c::2009/06/25-17:38:37.580 INFO [FM] FmpOfflineResource: SQL Network Name(SQLCLUSTERSERVERNAME) depends on SQL IP Address1(SQLCLUSTERSERVERNAME). Shut down first.
000004c8.00000f9c::2009/06/25-17:38:37.580 INFO [FM] FmpOfflineResource: SQL Disk S: depends on SQL Network Name(SQLCLUSTERSERVERNAME). Shut down first.
000004c8.00000f9c::2009/06/25-17:38:37.580 INFO [FM] FmpOfflineResource: SQL Server depends on SQL Network Name(SQLCLUSTERSERVERNAME). Shut down first.
000004c8.00000f9c::2009/06/25-17:38:37.580 INFO [FM] FmpOfflineResource: VDISPATCH Service depends on SQL Network Name(SQLCLUSTERSERVERNAME). Shut down first.
000004c8.00000f9c::2009/06/25-17:38:37.580 INFO [FM] FmpRmOfflineResource: InterlockedIncrement on gdwQuoBlockingResources for resource b803a691-6e9b-4901-b6c1-a83ae79870dd
000008b8.00000af4::2009/06/25-17:38:37.580 INFO Network Name <SQL Network Name(SQLCLUSTERSERVERNAME)>: Taking resource offline...

IP Address should depend on nothing
Physical disk should depend on nothing
Network name depends on IP address
SQL depends on name and disk.

Other than thaqt, there appears to be a problem with Disk S as well.

000004c8.0000077c::2009/06/25-17:37:46.251 INFO [GUM] GumSendUpdate: completed update seq 30867 type 0 context 11
000008b8.000007f8::2009/06/25-17:37:53.765 ERR Volume Manager Disk Group <SQL Disk S:>: Dg-Guid is Null000008b8.000007f8::2009/06/25-17:37:53.765 INFO Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: Calling OnlineDg API
000008b8.000007f8::2009/06/25-17:38:01.280 ERR Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: *** Unable to bring resource online Error: Unknown disk group
000008b8.000007f8::2009/06/25-17:38:01.280 ERR Volume Manager Disk Group <SQL Disk S:>: GetMountVolumeInfo Error: 1.
000008b8.000007f8::2009/06/25-17:38:01.280 INFO [RM] RmpSetResourceStatus, Posting state 4 notification for resource <SQL Disk S:>
000008b8.000007f8::2009/06/25-17:38:01.280 INFO Volume Manager Disk Group <SQL Disk S:>: LDM_RESOnlineThread: <<< Exiting LDM_RESOnlineThread
000004c8.000008cc::2009/06/25-17:38:01.280 INFO [FM] NotifyCallBackRoutine: enqueuing event
000004c8.0000017c::2009/06/25-17:38:01.280 INFO [CP] CppResourceNotify for resource SQL Disk S:
000004c8.0000017c::2009/06/25-17:38:01.280 INFO [FM] FmpRmDoHandleCriticalResourceStateChange: call InterlockedDecrement on gdwQuoBlockingResources, Resource 8f1f4232-ef39-42d6-9752-0ac8c6997463
000004c8.0000077c::2009/06/25-17:38:01.280 WARN [FM] FmpHandleResourceTransition: Resource Name = 8f1f4232-ef39-42d6-9752-0ac8c6997463 [SQL Disk S:] old state=129 new state=4
000004c8.0000077c::2009/06/25-17:38:01.280 WARN [FM] FmpHandleResourceTransition: Resource failed, post a work item
000004c8.0000077c::2009/06/25-17:38:01.280 INFO [GUM] GumSendUpdate: queuing update type 0 context 8
000004c8.0000077c::2009/06/25-17:38:01.280 INFO [GUM] GumSendUpdate: Dispatching seq 30868 type 0 context 8 to node 1
000004c8.0000077c::2009/06/25-17:38:01.280 INFO [GUM] GumSendUpdate: completed update seq 30868 type 0 context 8
000004c8.0000077c::2009/06/25-17:38:01.280 INFO [FM] FmpPropagateResourceState: resource 8f1f4232-ef39-42d6-9752-0ac8c6997463 failed event.
000004c8.0000077c::2009/06/25-17:38:01.280 INFO [FM] FmpHandleResourceFailure: taking resource 8f1f4232-ef39-42d6-9752-0ac8c6997463 and dependents offline

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top