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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 869908 Comments
Status Resolved Workarounds
Type Bug Repros 0
Opened 5/8/2014 8:07:42 PM
Access Restriction Public


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. 

Sign in to post a comment.
Posted by Luiz [MSFT] on 9/9/2015 at 11:10 AM
Hi William,

This issue was fixed in the latest release of the JDBC Driver (version 4.2).