Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2006-10-26 : 22:17:20
|
| Hi Guys, When you killed a process, and it just hang there. When you run the kill statement again and you see the following:SPID 59: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.and it just hang there with "KILLED/ROLLBACK", it happen to me before, does this happen to you guys as well? Apart from restarting sql services, is there any other way to fix it? How did you guys fix this?Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-26 : 22:43:37
|
| yep, the rollback usually takes 2x or more than the time you try to commitjust allow it to finish, the last time I tried to force it to stop, the server had difficulty recovering and took more than the normal time to recoverit's also not recommended to restart the services as this may pose greater risk of corrupting your server (worst case scenario of course)--------------------keeping it simple... |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-10-26 : 23:00:45
|
| Nah, the job already done, an there is nothing doing for that process.....it just hang pretty much, it never happen to you before Jen? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-27 : 01:46:14
|
| did you kill the process while the job is running?if yes, then it's trying to rollback whatever the job was doing (which appears to be the case)How long has the job been in a hanged state before you killed the process?--------------------keeping it simple... |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-10-27 : 06:57:41
|
| Check in the error log Westley to see how far the recovery process has happened, I had a similar issue a while back which the guys on this forum really helped me out with.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65301&SearchTerms=deleting,old,records |
|
|
|
|
|
|
|
|
Killed process