Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Killed Process still rolling back Expand / Collapse
Posted Saturday, March 16, 2013 9:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 11, 2016 4:45 AM
Points: 8, Visits: 129
dlautwein (8/22/2012)
I have a similar problem - killed processes still rolling back more than a day later - but a linked MySQL server is involved. Some of the processes that are "stuck" are just Select queries, so I wouldn't think there would be anything to rollback (for example: select * from openquery([MYSQL-WARRANTS],'select * from warranttab'). Kill with statusonly shows that it is 0% complete with 0 seconds remaining. After waiting a day, we rebooted the MySQL server hoping the process might just error out, but it still shows Running and Killed/Rollback. We tried stopping and starting the DTC. Does anyone know of any other way to cancel these processes other than stopping and starting the SQL server and hoping they end?

I also have same problem. My job pull data from teradata. It was running for last 3 days so i killed it 4th day, however now from last 2 days its in recovery. I had disabled daily schedule of job. Dontknow if restart of services will fix it.
Post #1431906
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse