Retour
-
Titre
Change Auditor Coordinator Service will not start after upgrade when the database is involved in a database mirroring session or an availability group -
Description
The Change Auditor Coordinator Service will not start after upgrade. The following error is recorded in the Change Auditor Coordinator log:
2015-08-03 16:09:03.636 [7][INFO][Dell.Data.ExceptionSql.OnExceptionSqlEvent(0)] SQL error(1468): The operation cannot be performed on database "ChangeAuditor" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.ALTER DATABASE statement failed.;command: ALTER DATABASE [%DATABASE_NAME%] SET AUTO_UPDATE_STATISTICS_ASYNC OFF;ALTER DATABASE [%DATABASE_NAME%] SET SINGLE_USER WITH NO_WAIT; -
Cause
Change Auditor does not officially support database mirroring or high availability and is not able to upgrade the database during the Coordinator startup.
-
Résolution
WORKAROUND
- Stop the Coordinator
- Remove the ChangeAuditor database from the database mirroring or high availability group
- Ensure the Coordinator is pointed to the correct SQL node/database location once removed from the high availability group
- Allow the Coordinator to upgrade the database (ensure the Coordinator is fully initialized)
- Stop the Coordinator
- Add the now upgraded ChangeAuditor database back to the high availability group
- Ensure the Coordinator is pointed back to the correct SQL cluster name/database location
- Start the Coordinator
- Upgrade any remaining Coordinators which are part of this install name per normal procedure
Note: This issue and workaround also applies to Azure availability groups as well.
STATUS
Enhancement request TF00374806 has been submitted to Development for consideration in a future release of Change Auditor.
-
Identifiant du défaut
TF00374806