大网数据广告活动
数据库与应用安全

AG remains in the resolving state

· 52CE 我爱测

This article provides a workaround for the problem where Always On Availability Group that contains the SSISDB database remains in the resolving state after a failover in SQL Server.

This article helps you resolve the problem where Always On Availability Group that contains the SSISDB database remains in the resolving state after a failover in SQL Server.

Original product version:   SQL Server
Original KB number:   3139534

Symptoms

Assume that the SSISDB database is a member of an Always On Availability Group, and that Availability Group fails over while a package from SSISDB is executing synchronously. In this situation, the Availability Group may remain in the resolving state on the (now formerly) primary replica until package execution completes.

In this scenario, the failover operation succeeds, but the Availability Group on the (newly) secondary replica remains in the resolving state until package execution completes. During this time, the SQL Server error log displays a message that resembles the following:

Nonqualified transactions are being rolled back in database SSISDB for an Always On Availability Groups state change. Estimated rollback completion: 0%. This is an informational message only. No user action is required.

Querying the session status shows that the session that was used to execute the job is in the KILLED/ROLLBACK state. If or when execution does complete, it may trigger errors such as the following:

Msg 0, Level 11, State 0, Line 6
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 6
A severe error occurred on the current command. The results, if any, should be discarded.

Cause

This issue occurs because the threads that are used to execute the SSIS package are outside the control of the mechanism that's used to kill a SQL Server session. When a package is executed synchronously, this causes the execution of a loop that prevents SQL Server from terminating the session until package execution has completed.

Workaround

To work around this issue, configure the SSIS package to execute asynchronously. Asynchronous package execution is the default behavior.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 09/22/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。