Fixing Always On Error: 19432, Severity: 16, State: 0

About a day ago while working on a client system I have noticed a message that reads Error: 19432, Severity: 16, State: 0. This message appeared on the system that runs SQL Server 2016 and has Always On Configured on it. The message itself is very clear to understand and that it also says No user action is required but Fixing Always On Error:19432, Severity: 16, State: 0 is a comparatively easy job. Let’s see how the error message looks like in Error log.

Always On Availability Groups transport has detected a missing log block for availability database "AdvancedDB". LSN of last applied log block is (54519:12104:0). Log scan will be restarted to fix the issue. This is an informational message only. No user action is required.
[WARNING] 2017-09-30 20:22:04.81 spid435s Always On Availability Groups connection with primary database established for secondary database 'AdvancedDB' on the availability replica 'SSCSQL013' with Replica ID: {99c0cbd8-d08a-4cb4-b20f-2eb186a5be3d}. This is an informational message only. No user action is required.
[WARNING] 2017-09-30 20:22:04.82 spid435s The recovery LSN (54519:12120:1) was identified for the database with ID 44. This is an informational message only. No user action is required.

Basically what is happening here is, while sending the data to a replica apparently, it is experiencing slow throughput and one will notice HADR_Sync_Commit wait types for the replica. Also, one will notice that intermittent issue with the size of REDO log is increasing. These can happen with multiple databases and can occur randomly. MS recommends applying the latest service pack to your Always on Group. Just in case, if needed here is the document that talks about in what sequence one can patch Always On Availability Group.

Leave a Reply

Your email address will not be published. Required fields are marked *

Hemantgiri Goswami

Hemantgiri Goswami

Throughout my extensive 24-year tenure in the IT industry, I have honed my expertise in SQL Server and cloud technologies. My qualifications include certifications in ITIL, Azure, and Google Cloud, and my professional journey boasts a consistent record of delivering top-notch, dependable, and efficient solutions across diverse clients and domains. In recognition of my dedication and impact, I am honored to have received the Microsoft MVP award for SQL Server on six occasions. Additionally, I actively contribute to various online forums and blogs, acting as a moderator and facilitator of meaningful discussions. My ultimate mission revolves around empowering organizations to enhance the reliability and efficiency of their SQL Server implementations while fostering a culture of continuous learning and growth within the SQL Server community.