Customer was trying to apply SQL2014 SP3 in Failover cluster instance. They applied patch to passive node, then failover to that node. Failover failed. Issue occurred every time. They can mitigate failover issues by uninstalling SQL2014 SP3. According to cluster logs, we can see:
00005f04.00005968::2022/10/07-00:06:42.743 INFO [RES] SQL Server <SQL Server (CAxxxxxDB)>: [sqsrvres] Request to bring SQL Server online
00005f04.00005968::2022/10/07-00:06:42.743 INFO [RES] SQL Server <SQL Server (CAxxxxxDB)>: [sqsrvres] SQL Server resource state is changed from ‘ClusterResourceFailed’ to ‘ClusterResourceOnlinePending’
00001554.00003fa4::2022/10/07-00:06:42.745 INFO [RCM] HandleMonitorReply: ONLINERESOURCE for ‘SQL Server (CAxxxxxDB)’, gen(11) result 997/0.
00001554.00003fa4::2022/10/07-00:06:42.745 INFO [RCM] Res SQL Server (CAxxxxxDB): OnlineCallIssued -> OnlinePending( StateUnknown