Delete statement not responding to Kill session command
8
votes
4
answers
3121
views
Four days ago a user ran the command below on a table with 400,000,000 rows. It's still running and the log file is increasing in size.
delete from [table-name]
This table does have a foreign key constraint which is not enabled for checking and I know that no rows exist in the other table.
The database is running with "Is Read Committed Snapshot On" enabled and in Simple recovery mode.
After this had run for a few hours I issued a kill session command, because we were running out of disk space for the log file. I added another log file to allow the system to continue to function.
The log file is continuing to grow and when I run kill session with statusonly it returns this message:
SPID 123: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
I am at a loss as to what to do about this query to get it to rollback and also just understanding what is going on, can anyone suggest what I can look at?
Asked by David Woakes
(183 rep)
Apr 6, 2020, 01:10 PM
Last activity: Apr 23, 2020, 07:34 PM
Last activity: Apr 23, 2020, 07:34 PM