Avatar of Zack
Zack
Flag for Australia asked on

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

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
Microsoft SQL Server

Avatar of undefined
Last Comment
Raja Jegan R

8/22/2022 - Mon
Raja Jegan R

>> 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..
Zack

ASKER
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 R

>> 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..
Your help has saved me hundreds of hours of internet surfing.
fblack61
Zack

ASKER
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.
Zack

ASKER
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.
ASKER CERTIFIED SOLUTION
Raja Jegan R

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Zack

ASKER
Thank you Raja my apologies for the delay in the acceptance of the answer.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Raja Jegan R

No issues, glad to assist..