FIX: SQL Server service stopped when IsAlive fails to connect (185806)
The information in this article applies to:
- Microsoft SQL Server, Enterprise Edition 6.5
This article was previously published under Q185806
BUG #: Windows NT: 17812 (6.50)
SYMPTOMS
A SQL Server computer that is enabled for clustering with Microsoft Cluster
Server (MSCS), may experience sudden stops of the SQL Server service and
subsequent restarts of the service. The last error log terminates
with the following message:
SQL Server terminating due to 'stop' request from Service
Control Manager
CAUSE
The Resource DLL for the SQL Server service exports two functions used by
the MSCS Cluster Manager to check for availability of the SQL Server
resource at predefined intervals. There is a simple check, LooksAlive, that
queries the service status through the Windows NT Service Control Manager,
and a more stringent check, IsAlive, that connects to SQL Server as user
"probe" and performs a simple query to the system catalog. By default,
LooksAlive is fired every 5 seconds and IsAlive is fired every 60 seconds.
IsAlive uses a fixed login time-out of 15 seconds to connect to SQL Server.
In situations where the server is very busy, SQL Server may fail to respond
to the IsAlive login request within this interval. Thus IsAlive returns
FALSE to the Cluster Manager, which issues a Terminate request and a
subsequent Online request to SQL Server and the SQL Executive Resource DLL
which causes both services to be stopped and restarted.
WORKAROUND
Increase the polling interval for SQL Server's IsAlive test in MSCS Cluster
Administrator to decrease the chance for this to happen.
STATUS
Microsoft has confirmed this to be a problem in SQL Server
6.5. This problem has been corrected in U.S. Service Pack 5a
for Microsoft SQL Server 6.5. For information about
how to download and install the latest SQL Server Service Pack, see
the following Microsoft Web site:
For more information, contact your primary support provider.
| Modification Type: | Minor | Last Reviewed: | 1/5/2006 |
|---|
| Keywords: | kbBug kbfix KB185806 |
|---|
|