Home Dashboard Directory Help
Search

The suspended process is not ended when time out and can not be killed by William.zhang


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 869908
Opened: 5/8/2014 8:07:42 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

The process which executes a full text index query in sql server 2012 stays at suspended status for three days and the host process of the sql command is terminated by IIS.

Then I run the 'kill @@spid' command, the process switches to killed/rollback status but can not ended. I try detach the database and it keeps loading and loading.

The process should be terminated when timeout.

Details
Sign in to post a comment.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
inputbuffer.PNG 5/8/2014 10 KB
waitresource.PNG 5/8/2014 79 KB
spwho.PNG 5/8/2014 85 KB