SQL Server Performance Forum – Threads Archive

Problem with lock

Hello,
There is a lock that is happening in my server, and when i try to kill it, it does not kill.
I type:
"KILL 61"
and then it shows me a message:
"SPID 61: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds." but I don’t see any progress, every time that I execute it, the progress is 0%,
then I need to restart the server in order to kill it.
"DBCC OPENTRAN" shows me this: Transaction information for database ‘KPST_DATA’. Oldest active transaction:
SPID (server process ID) : 61
UID (user ID) : 1
Name : user_transaction
LSN : (180821:12293:2)
Start time : Sep 1 2004 8:18:35:427AM
DBCC execution completed. If DBCC printed error messages, contact your system administrator. This lock is caused from a web application wich opens this transaction on COM+ side.
I don’t know why SQL Server can not kill this proccess.

Run SP_LOCK & SP_WHO2 for further information Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

yes I ran those commands, I see the objects that are locked, there are 116 objects locked by this process, but I just can not kill this process.

http://www.sql-server-performance.com/reducing_locks.asp
http://www.developerfusion.com/show/1688/
http://techrepublic.com.com/5208-6335-0.html?forumID=15&threadID=150641&start=0
http://www.databasejournal.com/news/article.php/3288411 HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Dont know why your problem exists, but as a short term solution you can probably kill the locks by restarting the COM+ Transaction Server

use DBCC INPUTBUFFER(61) to see what was the last command sent from the client. Also in sysprocesses, you should see changes in CPU / IO if the connection is doing something. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

]]>