Microsoft KB Archive/159339

= FIX: Stack Overflow If a SELECT Statement Is Killed =

Article ID: 159339

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q159339



BUG #: 15658 (sqlbug_65)



SYMPTOMS
If a process is killed while running a SELECT statement in which an aggregate function is used with a DISTINCT keyword, the following error message is displayed in the errorlog:

spid10 ex_testhandle: stack overflow, top=0x10a0ac8, end=0x10a0ac8

In addition, if the table from which the SELECT is run is a temporary table, the following messages are displayed when the process is killed:

kernel udread: Operating system error 6(The handle is invalid.) on

device 'D:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000394).

kernel udwritem: Operating system error 6(The handle is invalid.) on

device 'D:\MSSQL\DATA\MASTER.DAT' (virtpage 0x00000b80).

If the SELECT is placed in a temporary stored procedure and it is selecting from a temp table, then the following error is added to the errors above:

spid10 bufwait: timeout, BUF_IO, bp 0xca1420, pg 0x110, stat

0x1004/0x6, obj 0, bpss 0x109f598

This error message will continue to be entered in the errorlog until either Windows NT or SQL Server is shut down. You will not be able to shut down SQL Server using SQL Service Manager or by performing a "net stop mssqlserver". At this point, the behavior of the server is somewhat unpredictable. You may or may not be able to make new connections to the server, but the existing connections appear to be stable.

However, if tempdb only has its original size of 2 MB on the master device, when the process is killed, you will receive the following error instead:

Error: 1117, Severity: 21, State: 10

Extent chain for object -321 is not correctly linked.



WORKAROUND
Avoid using the Kill command to terminate processes.



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



MORE INFORMATION
The following SELECT statement is an example of a statement that will cause this problem to occur:

select avg (distinct Number) from Table

Additional query words: freeze frozen hung lock err msg errmsg

Keywords: kbbug kbfix kbinterop kbnetwork kbusage KB159339

-

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

© Microsoft Corporation. All rights reserved.