August 25, 2009 at 11:03 pm
Hi,
We have a/a/p cluster setup of SQL Server 2005. Node1- active, Node2- passive Node3 Active. We had a fail over in the middle of business hours. The Node3 resources were fail over to Node2.
So now I'm trying to find out the cause of this fail over. I did not get much idea But I found the below warning messages from event viewer and the information form the cluster log file ClCfgSrv.log located at C:\WINDOWS\system32\LogFiles\Cluster
Event Type:Warning
Event Source:ClusSvc
Event Category:Node Mgr
Event ID:1123
Date:8/24/2009
Time:13:08:12 PM
User:N/A
Computer:Node3
Description:
The node lost communication with cluster node 'Node2' on network 'Public'.
Event Type:Warning
Event Source:ClusSvc
Event Category:Node Mgr
Event ID:1123
Date:8/24/2009
Time:13:08:12 PM
User:N/A
Computer:Node3
Description:
The node lost communication with cluster node 'Node2' on network 'Private'.
2009-08-24 13:08:12.277 (ABC\cluster)
*
2009-08-24 13:08:12.277 [INFO] [CConnPointEnum::HrAddConnection] punk 0x179f40 added to the connection point enumerator. (hr=00000000)
2009-08-24 13:08:12.355 [INFO] [CConnPointEnum::HrAddConnection] punk 0x17a120 added to the connection point enumerator. (hr=00000000)
2009-08-24 13:08:12.511 [INFO] [SN] Trying to create an event named 'Global\Microsoft Cluster Configuration Post Configuration Completion Event'.
2009-08-24 13:08:12.605 [INFO] [IISCLUSCFG] Entering startup notify... (hr = 00000000)
2009-08-24 13:08:12.668 [INFO] [IISCLUSCFG] Could not delete resource type "IIS Server Instance" because the resource type was not found. Trying the next resource type in the table... (hr = 0x800713d6)
2009-08-24 13:08:12.714 [INFO] [IISCLUSCFG] Could not delete resource type "SMTP Server Instance" because the resource type was not found. Trying the next resource type in the table... (hr = 0x800713d6)
2009-08-24 13:08:12.746 [INFO] [IISCLUSCFG] Could not delete resource type "NNTP Server Instance" because the resource type was not found. Trying the next resource type in the table... (hr = 0x800713d6)
2009-08-24 13:08:12.793 [INFO] [IISCLUSCFG] Could not delete resource type "IIS Virtual Root" because the resource type was not found. Trying the next resource type in the table... (hr = 0x800713d6)
2009-08-24 13:08:12.840 [INFO] [IISCLUSCFG] Could not delete resource type "Time Service" because the resource type was not found. Trying the next resource type in the table... (hr = 0x800713d6)
2009-08-24 13:08:12.871 [INFO] [IISCLUSCFG] Leaving startup notify... (hr = 00000000)
2009-08-24 13:08:12.933 [INFO] [SN] Sending of cluster startup notifications complete. (hr = 00000000)
From the above information what will be the cause of Failover? Could you please advice me...
thank you
August 26, 2009 at 11:09 am
Could you please give some info on the above cluster fail over. And aslo here Node3 resources should only move to Node2 but not to Node1 (thats the way we configured). But I can see in the below message saying INS1(which is a instance on Node3) is failing from Node1(which should not be) to Node2?
Event Type:Information
Event Source:ClusSvc
Event Category:Failover Mgr
Event ID:1154
Date:8/25/2009
Time: 1:10:30 PM
User:N/A
Computer:Node2
Description:
Cluster service is attempting to failback the Cluster Resource Group 'INS1' from node Node1 to node Node2.
Please advice..
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply