Please advise about the following error:
Cluster resource & # 39; AG1_NAME & # 39; of type & # 39; SQL Server Availability Group & # 39; in the grouped function & # 39; AG1_NAME & # 39; failed & # 39;
According to the failure policies for the resource and the function, the cluster service can try to put the resource online in this node or move the group to another node in the cluster and then restart it. Check the resource and group status using Failover Cluster Manager or the Windows PowerShell Get-ClusterResource cmdlet.
AG1: (Primary = SRV01 DEV1, Secondary = SRV02 DEV1, SRV03 DEV1)
AG2: (Primary = SRV02 DEV2, Secondary = SRV03 DEV2, SRV01 DEV2)
The error occurred when updating the AG2 replicas with SQL SERVER 2016 SP2 CU7 which was SQL Server 2016 SP2 CU4.
Updating the order as follows, and there was no error during the update of the assistant
- Put the failover in manual in SRV01 DEV2
- Updated SRV01 DEV2 – A WSFC error (mentioned above) was noticed here
- Set the failover to Auto in SRV01 DEV2
- Put the failover in manual in SRV03 DEV2
- Updated SRV03 DEV2
- Set the failover to Auto in SRV03 DEV2
- Manual failure from SRV02 DEV2 (Primary) a SRV03 DEV2
- Updated SRV02 DEV2
- Manual of return to SRV02 DEV2 (Primary) of SRV03 DEV2
It is normal to update the second instance of SQL Server, the first instance is interrupted while the server participates in the Availability Groups, or we must follow a particular method in this case to avoid any errors as such.
Fortunately, in particular AG1 and all the WSFC resources worked normally when I look back immediately (after the error) in the WSFC Administrator Functions page. also PowerShell
Get-ClusterResource. but I'm worried about the production update and future updates. Any suggestion would be appreciable. Thank you!