Always On Availability Groups transport has detected a missing log block…

Spread the love

If you are running SQL Server 2016 (especially before CU3) you have received this error:

DATE/TIME:    8/21/2017 11:24:53 AM

DESCRIPTION:    Always On Availability Groups transport has detected a missing log block for availability database "Database". LSN of last applied log block is (99939:95847:0). Log scan will be restarted to fix the issue. This is an informational message only. No user action is required.

COMMENT:    (None)

JOB RUN:    (None)

Image result for missing block

I’ve talked with the product team about it, and its just something that happens, and is more of an informational message. Based on some discussions I’ve have on #sqlhelp on Twitter, it may be related to not enough network bandwidth between nodes. But if you see these sporadically, relax, it’s nothing major.

1 thought on “Always On Availability Groups transport has detected a missing log block…

  1. dallasbikr

    Hi Joey…this is happening on a system of mine and is sending the database into and through recovery on the Secondary. Its supposedly fixed in both CU 8 and 20 for SQL 2017. I’m looking at an emergency patch and drop/re-add the DB (800GB). Just FYI for you and future readers –Kevin3NF

    Reply

Leave a Reply to dallasbikr Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.