Microsoft KB Archive/186979

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

Article ID: 186979

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q186979



BUG #: 17219 (SQLBUG_65)



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: kbbug kbfix kbsqlserv650sp5fix KB186979

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.