FIX: Alpha: SELECT INTO with Kills Can Cause Process Hangs (132503)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q132503
BUG# NT: 9871 (4.21a - NTAlpha)
SYMPTOMS
When you issue a kill on a spid, it will not kill the specified process,
and subsequent kills issued against the spid will not work.
When you perform a SELECT * from sysprocesses on the server, it will show
spid 3 stuck in a command of DUMP TRAN in dbid 2 (tempdb), and one or more
user processes stuck in a command of INSERT. These user processes will not
respond to the kill command.
This problem is usually only encountered when you perform a stress test
that includes SELECT INTO a temp table and repeated kills of all processes.
WORKAROUND
Once the problem occurs, the only solution is to shut down SQL Server with
nowait. To avoid or minimize the problem, do not perform excessive KILL
commands on processes doing SELECT INTO commands into tempdb.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 4.21a for Alpha. This problem was corrected in the latest U.S.
Service Pack for SQL Server version 4.21a. For information on obtaining the
Service Pack, please contact your primary support provider.
| Modification Type: | Major | Last Reviewed: | 3/24/2000 |
|---|
| Keywords: | kbbug KB132503 |
|---|
|