SQL Service stops and restarts - no failover occures.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris (Chris_at_discussions.microsoft.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 14:31:05 -0800

Win2003 SQL2000 Active/Active

On node1 SQL service shuts down and immediately restarts. In the cluster log
on node1 we found the following below at exact time of service stop/start.
Why would a failover not have occured?

Why is CheckQueryProcessorAlive prefixed with ERR SQL Server..., this must
not be part of the cluster service checking node if IsAlive, correct? What is
this?

Thanks in advance for any insight...

000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] OnlineThread: QP is not online.
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Communication link failure
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Communication link failure
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Communication link failure
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Communication link failure
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009e8.00000f70::2004/11/19-16:09:33.840 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Communication link failure
00000518.000009fc::2004/11/19-16:09:52.972 INFO [FM] NotifyCallBackRoutine:
enqueuing event
00000518.00000794::2004/11/19-16:09:52.987 INFO [CP] CppResourceNotify for
resource SQL Server (IHSCDATA)
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL Server\IHSCDATA\Setup
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL Server\IHSCDATA\SQLServerSCP
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL Server\IHSCDATA\PROVIDERS
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL Server\IHSCDATA\MSSQLSERVER
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL Server\IHSCDATA\Cluster
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL
Server\IHSCDATA\SQLserverAgent
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing RNB for Software\Microsoft\Microsoft SQL Server\IHSCDATA\Replication
00000518.00000794::2004/11/19-16:09:53.003 INFO [CP] CppRundownCheckpoints
removing empty group
00000518.000007a8::2004/11/19-16:09:53.018 WARN [FM]
FmpHandleResourceTransition: Resource Name =
115b224b-0925-498b-a5a8-7d2c988e8964 [SQL Server (IHSCDATA)] old state=2 new
state=4
00000518.000007a8::2004/11/19-16:09:53.018 INFO [GUM] GumSendUpdate: queuing
update type 0 context 8
00000518.000007a8::2004/11/19-16:09:53.018 INFO [GUM] GumSendUpdate:
Dispatching seq 30031 type 0 context 8 to node 1
00000518.000007a8::2004/11/19-16:09:53.018 INFO [GUM] GumSendUpdate:
completed update seq 30031 type 0 context 8
00000518.000007a8::2004/11/19-16:09:53.018 INFO [FM]
FmpPropagateResourceState: resource 115b224b-0925-498b-a5a8-7d2c988e8964
failed event.
00000518.000007a8::2004/11/19-16:09:53.018 INFO [FM]
FmpHandleResourceFailure: taking resource
115b224b-0925-498b-a5a8-7d2c988e8964 and dependents offline
00000518.000007a8::2004/11/19-16:09:53.018 INFO [FM] TerminateResource:
df5746e5-0710-4e39-a33d-7c148c2d5e8f depends on
115b224b-0925-498b-a5a8-7d2c988e8964. Terminating first
000009e8.00000f70::2004/11/19-16:09:54.519 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] ODBC sqldriverconnect failed
000009e8.00000f70::2004/11/19-16:09:54.535 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error
= b; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network
error. Check your network documentation.
000009e8.00000f70::2004/11/19-16:09:54.535 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] ODBC sqldriverconnect failed
000009e8.00000f70::2004/11/19-16:09:54.535 ERR SQL Server <SQL Server
(IHSCDATA)>: [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error
= 102; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(PreLoginHandshake()).

Relevant Pages

  • Re: cluster resource in resource group failed
    ... And make sure that the SQL Service account has "log on as a service" rights. ... SQL Server is terminating in response to a 'stop' request from Service ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Service stops and restarts - no failover occures.
    ... That is a cluster service failure detection. ... your SQL server isn't responding to the query. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server service stopping mode on One Cluster Node
    ... It looks like the SQL instance is not responding to the cluster resource "looksAlive" and "IsAlive" checks. ... Try and bring the disk resources online, then the IP, then the network name resources online. ... Then try and bring the SQL Server resource online and see if you get better results or at least better error messages. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Cluster Remove
    ... I need to remove SQL 2000 from an old Windows 2003 Active/ Passive ... Error 422 bringing resource online. ... Screenshot of Cluster administrator is attached. ...
    (microsoft.public.sqlserver.clustering)
  • SQL Cluster Remove
    ... I need to remove SQL 2000 from an old Windows 2003 Active/ Passive ... Error 422 bringing resource online. ... Screenshot of Cluster administrator is attached. ...
    (microsoft.public.sqlserver.clustering)