Cluster Node Hung

[timi11]

I run a SQL2K SP4 on WIN2K Ad Server SP4 in an active/active two node cluster configuration.
node one hung and had to be rebooted.

Cluster Log had the message below
Cluster file sahre resource benthas failed a status check Error Code 64.

Event Log had the messages below.
The message in the Event log is [sqsrvres] Online thread QP is not online.
The message in the Event log is [sqsrvres] CheckQueryProcessorAlive:sqlexecdirect failed.

Please help. What was the cause and how to avoid future occurence.

Thanks.

 

[ChelseaGirl]

timi11

Are you sure everything has come back and is running OK ?
If not check you failover settings (highlight a cluster group, right click, properties) do you allow failback ? It could be the app is trying to run on the other node.....

 

[timi11]

Thanks ChelseaGirl.

All required services are back and running ok. Failback is allowed for all cluster groups.
I look forward to further help.

Thanks.