We help IT Professionals succeed at work.

SQL Server 2012 SP4 Patch Failed on 1 node in AG Cluster.

Zack
Zack asked
on
78 Views
Last Modified: 2018-12-07
Hi EE,

An upgrade to SQL server 2012 SP4 has failed, context:

I'm patching a 2 node AG cluster the first patch has been applied to secondary node successfully:

I then failed over the secondary node.  Then I began patching primary node:

The primary node patch failed I have got no idea why it failed and the SQL instance is no longer accessible.

I restored from a VM snapshot, tried it again and got the same error.  

Looking at these error log files I can't make sense of what went wrong.

Any assistance is appreciated.

Thank you
ERRORLOG.txt
ERRORLOG1.txt
ERRORLOG2.txt
ERRORLOG3.txt
ERRORLOG4.txt
ERRORLOG5.txt
ERRORLOG6.txt
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> The primary node patch failed I have got no idea why it failed and the SQL instance is no longer accessible.

Have you tried restarting the server to see whether it helped or not..

>> I restored from a VM snapshot, tried it again and got the same error.

Instead, can you try re configuring that node and make it as a valid secondary node..
ZackGeneral IT Goto Guy

Author

Commented:
Hi Raja,

Have you tried restarting the server to see whether it helped or not..

- I did the SQL server was unresponsive according to the data logs the master database was corrupt.

Instead, can you try reconfiguring that node and make it as a valid secondary node.

- I made that node the secondary node before I commenced the update.

Any other ideas?

Thank you.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> I did the SQL server was unresponsive according to the data logs the master database was corrupt

Have you tried fixing corrupted master database by rebuilding it or restoring from a backup..

Instead, can you try reconfiguring that node and make it as a valid secondary node.

I mentioned to rebuild the SQL Server instance completely and add it as a new node to your AG group..
ZackGeneral IT Goto Guy

Author

Commented:
Hi Raja,

I did try fixing the corrupted master database by restoring from the backup, but the SQL server was still showing as the same version.

Second query:  I mentioned to rebuild the SQL Server instance completely and add it as a new node to your AG group..

I could try de-attach the node completely:

https://www.mssqltips.com/sqlservertip/4231/how-to-remove-node-from-a-sql-server-failover-cluster/

Then try patch the server.

The question I would have is would the cluster work with only 1 node on it.

Just to reiterate the cluster consists of 2 nodes and 1 witness server.

Thank you.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Raja.

Correcting technical details

I did try fixing the corrupted master database by restoring from the backup, but the SQL server was still showing as the same version.

Second query:  I mentioned to rebuild the SQL Server instance entirely and add it as a new node to your AG group.

I could try de-attach the node completely:

https://www.mssqltips.com/sqlservertip/4619/removing-a-secondary-replica-from-a-sql-server-alwayson-availability-group/

Then try patch the server.

The question I have is would the AG work with only one node on it.

Just to reiterate the cluster consists of 2 nodes and 1 witness server.

Thank you.
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
ZackGeneral IT Goto Guy

Author

Commented:
Thank you Raja my apologies for the delay in the acceptance of the answer.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
No issues, glad to assist..
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.