dbTalk Databases Forums  

3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this???

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Barry Lynch
 
Posts: n/a

Default 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? - 07-26-2004 , 06:50 AM






OK - Hi all
I have an irritating problem with a cluster and perhaps some of you can
short circuit it for me...

Environment
Windows Server 2003
Sql Server 2000 EE - SPK 3
3 node stretch cluster - only 3rd node is stretched

Problem Summary...
Node 1 (lets say 10.0.0.1) is ocassionally losing it ability to repond to
ping/name resolve. Trace route is failing one hop before reaching it.
However if we fail over to node 2 and back again all is ok for a random
period of time and then it fails to respond again
We are now leaving Node 2 as the Active node and witing to see if it happens
on node 2 also - if it does then I imagine the stakes will rise considerably
;-(

Things to Date...
All resources seem to be correctly configured and assigned to the correct
groups
The IP address is correct and unique for the SQL V Server resource
All n/w cards are functional
Nothing obvious in the event logs
The node responds to a ping locally (that is from Node1 over an RDP
session) without resorting to failover even though it is failing from an
external ping.

Other...
Not sure if this is related but at installation time I could not build the 3
nodes at once. I had to build Node 1 then add Node 2, then add Node 3.
Probably a red herring

Anyone ever have this or shed any light.
Should I be talking to the networking geniuses?

Thanks in advance

Barry Lynch




Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? - 07-26-2004 , 08:32 AM






What are you using to stretch the cluster?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Barry Lynch" <allspammustdie (AT) yahoo (DOT) com> wrote

Quote:
OK - Hi all
I have an irritating problem with a cluster and perhaps some of you can
short circuit it for me...

Environment
Windows Server 2003
Sql Server 2000 EE - SPK 3
3 node stretch cluster - only 3rd node is stretched

Problem Summary...
Node 1 (lets say 10.0.0.1) is ocassionally losing it ability to repond to
ping/name resolve. Trace route is failing one hop before reaching it.
However if we fail over to node 2 and back again all is ok for a random
period of time and then it fails to respond again
We are now leaving Node 2 as the Active node and witing to see if it
happens
on node 2 also - if it does then I imagine the stakes will rise
considerably
;-(

Things to Date...
All resources seem to be correctly configured and assigned to the correct
groups
The IP address is correct and unique for the SQL V Server resource
All n/w cards are functional
Nothing obvious in the event logs
The node responds to a ping locally (that is from Node1 over an RDP
session) without resorting to failover even though it is failing from an
external ping.

Other...
Not sure if this is related but at installation time I could not build the
3
nodes at once. I had to build Node 1 then add Node 2, then add Node 3.
Probably a red herring

Anyone ever have this or shed any light.
Should I be talking to the networking geniuses?

Thanks in advance

Barry Lynch






Reply With Quote
  #3  
Old   
Rodney
 
Posts: n/a

Default Re: 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? - 07-26-2004 , 03:17 PM




Quote:
-----Original Message-----
What are you using to stretch the cluster?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Barry Lynch" <allspammustdie (AT) yahoo (DOT) com> wrote in message
news:ce2r7102pv5 (AT) news1 (DOT) newsguy.com...
OK - Hi all
I have an irritating problem with a cluster and perhaps
some of you can
short circuit it for me...

Environment
Windows Server 2003
Sql Server 2000 EE - SPK 3
3 node stretch cluster - only 3rd node is stretched

Problem Summary...
Node 1 (lets say 10.0.0.1) is ocassionally losing it
ability to repond to
ping/name resolve. Trace route is failing one hop
before reaching it.
However if we fail over to node 2 and back again all is
ok for a random
period of time and then it fails to respond again
We are now leaving Node 2 as the Active node and witing
to see if it
happens
on node 2 also - if it does then I imagine the stakes
will rise
considerably
;-(

Things to Date...
All resources seem to be correctly configured and
assigned to the correct
groups
The IP address is correct and unique for the SQL V
Server resource
All n/w cards are functional
Nothing obvious in the event logs
The node responds to a ping locally (that is from Node1
over an RDP
session) without resorting to failover even though it
is failing from an
external ping.

Other...
Not sure if this is related but at installation time I
could not build the
3
nodes at once. I had to build Node 1 then add Node 2,
then add Node 3.
Probably a red herring

Anyone ever have this or shed any light.
Should I be talking to the networking geniuses?

Thanks in advance

Barry Lynch





.
Barry,
I saw this problem before and it was because a client had
the properties of the NIC set to update the DNS of the IP
information & the servers were behind a BIgIP (NAT). This
was hell on resolving and pings!

Good Luck, Rodney


Reply With Quote
  #4  
Old   
Barry Lynch
 
Posts: n/a

Default Re: 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? - 07-26-2004 , 04:34 PM



Hi Rodney et al
That's very interesting - I will check tomorrow and let you know how I get
on
Thanks
Barry
"Rodney" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
-----Original Message-----
What are you using to stretch the cluster?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Barry Lynch" <allspammustdie (AT) yahoo (DOT) com> wrote in message
news:ce2r7102pv5 (AT) news1 (DOT) newsguy.com...
OK - Hi all
I have an irritating problem with a cluster and perhaps
some of you can
short circuit it for me...

Environment
Windows Server 2003
Sql Server 2000 EE - SPK 3
3 node stretch cluster - only 3rd node is stretched

Problem Summary...
Node 1 (lets say 10.0.0.1) is ocassionally losing it
ability to repond to
ping/name resolve. Trace route is failing one hop
before reaching it.
However if we fail over to node 2 and back again all is
ok for a random
period of time and then it fails to respond again
We are now leaving Node 2 as the Active node and witing
to see if it
happens
on node 2 also - if it does then I imagine the stakes
will rise
considerably
;-(

Things to Date...
All resources seem to be correctly configured and
assigned to the correct
groups
The IP address is correct and unique for the SQL V
Server resource
All n/w cards are functional
Nothing obvious in the event logs
The node responds to a ping locally (that is from Node1
over an RDP
session) without resorting to failover even though it
is failing from an
external ping.

Other...
Not sure if this is related but at installation time I
could not build the
3
nodes at once. I had to build Node 1 then add Node 2,
then add Node 3.
Probably a red herring

Anyone ever have this or shed any light.
Should I be talking to the networking geniuses?

Thanks in advance

Barry Lynch





.
Barry,

I saw this problem before and it was because a client had
the properties of the NIC set to update the DNS of the IP
information & the servers were behind a BIgIP (NAT). This
was hell on resolving and pings!

Good Luck, Rodney



Reply With Quote
  #5  
Old   
Allan Hirt
 
Posts: n/a

Default Re: 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? - 07-27-2004 , 01:14 PM



To do a geographically dispersed cluster, you need to have
a solution that is in the Windows Catalog. How is the
third connected to a SAN? I assume it is mirrored ...

Reply With Quote
  #6  
Old   
BarryLynch
 
Posts: n/a

Default Re: 3-Node Stretch SQL Cluster - Node 1 Ping/Name resolution failure - ANyone ever get this??? - 07-27-2004 , 09:03 PM



"Allan Hirt" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
To do a geographically dispersed cluster, you need to have
a solution that is in the Windows Catalog. How is the
third connected to a SAN? I assume it is mirrored ...
Hi there Allan
The cluster is implemented as a VLAN over fibre so long as the ping
time to the stretched node is under 1500 ms (If I remember correctly
could be a differnt value - its 3am) then the cluster is viable - this
part works perfectly

With regard to this problem I'm beginning to work round to a mixture
of DNS and AD upgrade issues
Regards

Barry


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.