March 8, 2020 at 5:48 pm
There was a glitch on a network which made DBs to go out of sync whcih are part of DAG. Now 15 out of 16 DBs have been synchronizing except 1 DB which is stuck at 21% for past 4 hours. Nonqualified transactions are being rolled back in database for an Always On Availability Groups state change. Estimated rollback completion: 21%. I ran sp_who2 and there is a block session. SO I ran a command 'Kill 226 with statusonly' which shows me what I ready know. "SPID 226: transaction rollback in progress. Estimated rollback completion: 21%. Estimated time remaining: 61663 seconds." Any help is highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 9, 2020 at 12:10 pm
If im not mistaken, you'll have to wait, you can't stop rollbacks, if you restart the instance it'll start rolling back again or pick up where it left.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply