FIX: Issuing KILL on Running SQL Web Task Stops SQL Server

ID: Q186979

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 17219 (SQLBUG_65)

SYMPTOMS

Case 1

When a KILL statement is issued against a running SQL Web task, SQL Server stops.

Case 2

Under stress testing using Microsoft SQL Server version 6.5 Service Pack 3 (SP3) and later, the Web Assistant may cause the SQL Server process to terminate. This occurs when sp_makewebtask and other Web Assistant stored procedures are running simultaneously. The error handler in the Web Assistant forces an EXIT Process and subsequently causes the SQL Server process to be exited.

This means that SQL Server will be shut down whenever dbopen fails in WebGetBoundConnection. Dbopen can fail simply because the server is too busy to accept additional connections.

This problem occurs when you are running a workload with many connections and many Web Assistant extended procedure calls on a system that lacks sufficient resources.

CAUSE

Code in the error handler returns a value of INT_EXIT when the connection is lost.

WORKAROUND

There is currently no workaround available for this problem.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5 Service Pack 2 and later. This problem has been corrected in the latest U.S. Service Pack for SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: sp sp5 prodsql


Keywords          : SSrvWeb kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 4, 1999