Share via

SQL Server AG Bug

ahmad rayeji 1 Reputation point
2022-02-18T09:50:13.243+00:00

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

175787-screen-shot-2022-02-18-at-130813.png

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


2 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,756 Reputation points
    2022-02-21T07:38:57.247+00:00

    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.

    Was this answer helpful?

    0 comments No comments

  2. Tom Phillips 17,786 Reputation points
    2022-02-18T21:00:47.653+00:00

    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.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.