Drive Locked when testing fail over

#1

Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is on a SAN
attached drive managed by NetApp which is drive x:. When I try to test the
fail over or move from one node to the other x: drive is locked by the first
node and the fail over fails. Can anyone share any pointers why this is
happening.

Thanks

#2

Can you explain what you mean by "locked"? Does the disk ever go offline?
Just wondering if its failing to go offline, or failing to come online on
the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why the disk
is failing to go offline/online. This log is based in UTC time zone, so
you'll need to adjust accordingly when looking through this log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote

Quote:

Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is on a
SAN attached drive managed by NetApp which is drive x:. When I try to test
the fail over or move from one node to the other x: drive is locked by the
first node and the fail over fails. Can anyone share any pointers why this
is happening.

Thanks

#3

basically is failing to offline and switching over to the other node. At
that point the cluster is useless and I have to remote into the server and
start it again. Looking at the cluster.log from yesterday and today I don't
see much.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote

Quote:

Can you explain what you mean by "locked"? Does the disk ever go offline?
Just wondering if its failing to go offline, or failing to come online on
the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why the
disk is failing to go offline/online. This log is based in UTC time zone,
so you'll need to adjust accordingly when looking through this log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:%23ldgNgZqKHA.5940 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is on a
SAN attached drive managed by NetApp which is drive x:. When I try to
test the fail over or move from one node to the other x: drive is locked
by the first node and the fail over fails. Can anyone share any pointers
why this is happening.

Thanks

#4

Are the other resources going offline successfully? Are there any 1069
errors logged in the System event log?

"Amador" <amador (AT) agconsulting (DOT) info> wrote

Quote:

basically is failing to offline and switching over to the other node. At
that point the cluster is useless and I have to remote into the server and
start it again. Looking at the cluster.log from yesterday and today I
don't see much.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote in message
news:uapv4lZqKHA.3464 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Can you explain what you mean by "locked"? Does the disk ever go offline?
Just wondering if its failing to go offline, or failing to come online on
the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why the
disk is failing to go offline/online. This log is based in UTC time zone,
so you'll need to adjust accordingly when looking through this log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:%23ldgNgZqKHA.5940 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is on a
SAN attached drive managed by NetApp which is drive x:. When I try to
test the fail over or move from one node to the other x: drive is locked
by the first node and the fail over fails. Can anyone share any pointers
why this is happening.

Thanks

#5

Yes many 1069.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote

Quote:

Are the other resources going offline successfully? Are there any 1069
errors logged in the System event log?

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:OijshYcqKHA.1936 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
basically is failing to offline and switching over to the other node. At
that point the cluster is useless and I have to remote into the server
and start it again. Looking at the cluster.log from yesterday and today I
don't see much.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote in message
news:uapv4lZqKHA.3464 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Can you explain what you mean by "locked"? Does the disk ever go
offline? Just wondering if its failing to go offline, or failing to come
online on the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why the
disk is failing to go offline/online. This log is based in UTC time
zone, so you'll need to adjust accordingly when looking through this
log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:%23ldgNgZqKHA.5940 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is on
a SAN attached drive managed by NetApp which is drive x:. When I try to
test the fail over or move from one node to the other x: drive is
locked by the first node and the fail over fails. Can anyone share any
pointers why this is happening.

Thanks

#6

John,

Any Ideas on what I should be looking at to get this resolved?

Quote:

news:euAmlI$qKHA.3536 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Are the other resources going offline successfully? Are there any 1069
errors logged in the System event log?

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:OijshYcqKHA.1936 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
basically is failing to offline and switching over to the other node. At
that point the cluster is useless and I have to remote into the server
and start it again. Looking at the cluster.log from yesterday and today
I don't see much.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote in message
news:uapv4lZqKHA.3464 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Can you explain what you mean by "locked"? Does the disk ever go
offline? Just wondering if its failing to go offline, or failing to
come online on the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why the
disk is failing to go offline/online. This log is based in UTC time
zone, so you'll need to adjust accordingly when looking through this
log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:%23ldgNgZqKHA.5940 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is on
a SAN attached drive managed by NetApp which is drive x:. When I try
to test the fail over or move from one node to the other x: drive is
locked by the first node and the fail over fails. Can anyone share any
pointers why this is happening.

Thanks

#7

Which resources are reporting the 1069 errors?

What are the events in the cluster.log at the time of these 1069 errors?

"Amador" <amador (AT) agconsulting (DOT) info> wrote

Quote:

John,

Any Ideas on what I should be looking at to get this resolved?

news:euAmlI$qKHA.3536 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Are the other resources going offline successfully? Are there any 1069
errors logged in the System event log?

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:OijshYcqKHA.1936 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
basically is failing to offline and switching over to the other node.
At that point the cluster is useless and I have to remote into the
server and start it again. Looking at the cluster.log from yesterday
and today I don't see much.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote in message
news:uapv4lZqKHA.3464 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Can you explain what you mean by "locked"? Does the disk ever go
offline? Just wondering if its failing to go offline, or failing to
come online on the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why the
disk is failing to go offline/online. This log is based in UTC time
zone, so you'll need to adjust accordingly when looking through this
log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:%23ldgNgZqKHA.5940 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is
on a SAN attached drive managed by NetApp which is drive x:. When I
try to test the fail over or move from one node to the other x: drive
is locked by the first node and the fail over fails. Can anyone share
any pointers why this is happening.

Thanks

#8

So basically this is what I notice. I have a resource type called SQL Server
(Altiris) and when looking at the under possible owners I only see one node
and not the second node called NY-SQL2, I only see NY-SQL2. All other types
have both nodes as owners.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote

Quote:

Which resources are reporting the 1069 errors?

What are the events in the cluster.log at the time of these 1069 errors?

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:O3f%23Uu%23rKHA.4360 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
John,

Any Ideas on what I should be looking at to get this resolved?

news:euAmlI$qKHA.3536 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Are the other resources going offline successfully? Are there any 1069
errors logged in the System event log?

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:OijshYcqKHA.1936 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
basically is failing to offline and switching over to the other node.
At that point the cluster is useless and I have to remote into the
server and start it again. Looking at the cluster.log from yesterday
and today I don't see much.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote in message
news:uapv4lZqKHA.3464 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Can you explain what you mean by "locked"? Does the disk ever go
offline? Just wondering if its failing to go offline, or failing to
come online on the other node.

On the node where the disk is failing, you'll want to look at the
c:\windows\cluster\cluster.log (assuming Win 2003) file to see why
the disk is failing to go offline/online. This log is based in UTC
time zone, so you'll need to adjust accordingly when looking through
this log.

Regards,
John

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:%23ldgNgZqKHA.5940 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Everyone,

I have configured a SQL 2005 cluster with two nodes. My SQL data is
on a SAN attached drive managed by NetApp which is drive x:. When I
try to test the fail over or move from one node to the other x:
drive is locked by the first node and the fail over fails. Can
anyone share any pointers why this is happening.

Thanks

#9

That will certainly prevent the group containing that resource from failing
over to your NY-SQL2 node.

"Amador" <amador (AT) agconsulting (DOT) info> wrote

Quote:

So basically this is what I notice. I have a resource type called SQL
Server (Altiris) and when looking at the under possible owners I only see
one node and not the second node called NY-SQL2, I only see NY-SQL2. All
other types have both nodes as owners.

#10

John,

Any ideas how I could fix this without having to rebuild the cluster. I will
like to get this resolved but not sure how to tackle it.

"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> wrote

Quote:

That will certainly prevent the group containing that resource from
failing over to your NY-SQL2 node.

"Amador" <amador (AT) agconsulting (DOT) info> wrote in message
news:eD8SKPLsKHA.3536 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
So basically this is what I notice. I have a resource type called SQL
Server (Altiris) and when looking at the under possible owners I only see
one node and not the second node called NY-SQL2, I only see NY-SQL2. All
other types have both nodes as owners.