SQL Server AG Bug

Question

SQL Server AG Bug

ahmad rayeji 1

Hi
We have issue after upgrade to sql server 2019 latest sql server cumulative update KB5008996 (from sql server 2017) in AG mode

Non-yielding Scheduler

Windows Server Failover Cluster did not receive a process event signal from SQL Server hosting availability group 'XXXX' within the lease timeout period.

this issue happening when taking differential backup

Ronen Ariely 15,221 Reputation points

2022-02-18T16:09:23.803+00:00

Please elaborate what steps did you take to update the instance
Seeya Xi-MSFT 16,756 Reputation points

2022-02-23T01:22:50.08+00:00

Hi @ahmad rayeji ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
ahmad rayeji 1 Reputation point

2022-02-23T04:52:09.807+00:00

Hi @Ronen Ariely
Steps done based on documents,
I did this upgrade for 8 years from older version
this issue just happen when i'm taking diff backup
ahmad rayeji 1 Reputation point

2022-02-23T04:56:47.657+00:00

Hi @Seeya Xi-MSFT

No, problem exists yet

2 answers

Your answer

Ronen Ariely 15,221 Reputation points

2022-02-18T16:09:23.803+00:00

Please elaborate what steps did you take to update the instance
Seeya Xi-MSFT 16,756 Reputation points

2022-02-23T01:22:50.08+00:00

Hi @ahmad rayeji ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
ahmad rayeji 1 Reputation point

2022-02-23T04:52:09.807+00:00

Hi @Ronen Ariely
Steps done based on documents,
I did this upgrade for 8 years from older version
this issue just happen when i'm taking diff backup
ahmad rayeji 1 Reputation point

2022-02-23T04:56:47.657+00:00

Hi @Seeya Xi-MSFT

No, problem exists yet

Answer 1

Seeya Xi-MSFT 16,756

Hi @ahmad rayeji ,

You can refer to this article about some steps during the process of updating.
https://www.sqlshack.com/apply-sql-server-patches-or-cumulative-updates-in-sql-server-always-on-availability-groups/

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 comments

Answer 2

Tom Phillips 17,786

This error is usually related to a code problem in SQL Server. If this is a blocking issue, please contact MS Support directly and they can help you resolve the issue.

ahmad rayeji 1 Reputation point

2022-02-23T04:54:43.143+00:00

Hi @Tom Phillips

Yes it's blocking issue
Microsoft described this issue in KB4541303
But i think it's not fixed
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator

2022-02-23T22:15:41.567+00:00

What does "SELECT @@version" return?

If you have applied that fix, you will need to open a support case to get further. This is not something we can help you with here in the forums.

Share via

SQL Server AG Bug

2 answers

Your answer