Showing posts with label outage. Show all posts
Showing posts with label outage. Show all posts

Sunday, March 25, 2012

Cluster Log error message

Hello to all,
I'm investigating an application outage issue on a 2-node W2K Adv Server
cluster. A Generic Application is running on the cluster in a remote site,
and connects to a UNIX-based Oracle db at my site. There are intermittent
MRxSMB 3019 Event IDs which I'm not too worried about. I just used Q138365
to adjust the autodisconnect value to -1.
But I'm finding this error message in the Cluster log:
Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS PTR
record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status 9005
I can't find anything documented about this error, so I can't tell if this
is something to be concerned about. Is it nothing, a cluster service
problem, DNS registraion problem?
Any thoughts would be greatly appreciated.
Thanks in advance.
Hey I had this error as well when I was setting up my cluster
To fix it:
o Right-click the network connection for your heartbeat adapter, and then
click Properties.
o Click Internet Protocol (TCP/IP), and then click Properties
o On the DNS tab, verify that no values are defined. Make sure that the
Register this connection's address in DNS is cleared.
Hope this helps!!
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:932C28D9-F8C2-4F83-BE57-AA149AF27065@.microsoft.com...
> Hello to all,
> I'm investigating an application outage issue on a 2-node W2K Adv Server
> cluster. A Generic Application is running on the cluster in a remote
site,
> and connects to a UNIX-based Oracle db at my site. There are intermittent
> MRxSMB 3019 Event IDs which I'm not too worried about. I just used
Q138365
> to adjust the autodisconnect value to -1.
> But I'm finding this error message in the Cluster log:
> Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS
PTR
> record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status
9005
> I can't find anything documented about this error, so I can't tell if this
> is something to be concerned about. Is it nothing, a cluster service
> problem, DNS registraion problem?
> Any thoughts would be greatly appreciated.
> Thanks in advance.
sqlsql

Thursday, March 22, 2012

Cluster Fails when lose network...

Hello. We have a SQL Server 2000 Cluster on Windows Server 2003 that is
running great. We had a network outage last week, however, and the
whole cluster went down. We noticed that the Cluster Group "IP Address"
resource went down and that then took the SQL Server services offline.
We reproduced this behavior this morning by unplugging the WAN network
card [while leaving the "heartbeat" connection] and the Cluster Group
failed and took the SQL Cluster group offline as a result. This is a
major flaw. What needs to be configured to work around this? A
stand-alone SQL Server does not fail when unplugged from the network, it
just keeps on running until connectivity is restored.
This isn't a flaw, it is a feature. The cluster service monitors the
service and its underlying resources. When a resource is unavailable, the
cluster tries to find a node where the resource is available. If you unplug
one host from the WAN, the SQL server group should fail over to the other
node as should any other cluster groups. Read a little more about clusters
and you will see why this is happening.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"michael [multnomah]" <wewill@.reclaimourfuture.net> wrote in message
news:g7mdnZS4QJZQaQ3cRVn-iA@.speakeasy.net...
> Hello. We have a SQL Server 2000 Cluster on Windows Server 2003 that is
> running great. We had a network outage last week, however, and the
> whole cluster went down. We noticed that the Cluster Group "IP Address"
> resource went down and that then took the SQL Server services offline.
> We reproduced this behavior this morning by unplugging the WAN network
> card [while leaving the "heartbeat" connection] and the Cluster Group
> failed and took the SQL Cluster group offline as a result. This is a
> major flaw. What needs to be configured to work around this? A
> stand-alone SQL Server does not fail when unplugged from the network, it
> just keeps on running until connectivity is restored.
|||This is correct. The cluster service periodically connects to SQL Server to
verify that it is usable. If it cannot connect it will fail the resource
and attempt to bring it back on line.
Rand
This posting is provided "as is" with no warranties and confers no rights.