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.


1
0
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

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. 

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).

Thanks