Veritas InfoScale 7.3.1 Release Notes - Windows
- Release notes for Veritas InfoScale
- Limitations
- Deployment limitations
- Cluster management limitations
- Storage management limitations
- Multi-pathing limitations
- Replication limitations
- Solution configuration limitations
- Internationalization and localization limitations
- Interoperability limitations
- Known issues
- Deployment issues
- Cluster management issues
- Cluster Server (VCS) issues
- Cluster Manager (Java Console) issues
- Global service group issues
- VMware virtual environment-related issues
- Cluster Server (VCS) issues
- Storage management issues
- Storage Foundation
- VEA console issues
- Snapshot and restore issues
- Snapshot scheduling issues
- Storage Foundation
- Multi-pathing issues
- Replication issues
- Solution configuration issues
- Disaster recovery (DR) configuration issues
- Fire drill (FD) configuration issues
- Quick recovery (QR) configuration issues
- Internationalization and localization issues
- Interoperability issues
- Miscellaneous issues
- Fibre Channel adapter issues
- Deployment issues
SQL Server service resource does not fault even if detail monitoring fails
This issue may occur when detail monitoring is configured and IMF is enabled for SQL Server agents. (2535806)
If detail monitoring fails (either the database becomes unavailable or there is a failure in the detail monitoring script), the SQL service resources fault and VCS may then fail over the service group if the agent's FaultOnDMFailure attribute is set to 1.
It is observed that when IMF is enabled for SQL Server agents, the SQL service resources does not fault. Instead, the SQL Agent service resource (SQLServerAgent) faults.
This occurs because when detail monitoring fails, the SQL Server service agent invokes the clean function and as a result the SQL database engine service goes for a restart. As the SQL Agent service depends on the database service, the database service first stops the SQL Agent service as part of its own restart process. IMF instantly detects that the SQL Agent service has stopped and as a result the SQL Agent resource (SQLServerAgent) in the service group faults. As the SQL Agent resource has faulted, VCS initiates a fail over of the service group. The SQL Server service resource receives this VCS initiated offline and therefore does not fault in response to the original detail monitoring failure event.
Workaround: There is no known workaround for this issue at this time.