Secondary Databases Not Recovering

%3CLINGO-SUB%20id%3D%22lingo-sub-1295670%22%20slang%3D%22en-US%22%3ESecondary%20Databases%20Not%20Recovering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1295670%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20had%20a%20fail%20over%20last%20night%20due%20to%20Windows%20patches%20being%20applied.%26nbsp%3B%20Most%20databases%20were%20fine%20but%20we%20had%20a%20few%20that%20were%20stuck%20in%20Initializing%20%2F%20In%20Recovery.%26nbsp%3B%20From%20the%20logs%20I%20see%20the%20following%20for%20the%20databases%20in%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Availability%20database%20'dbname'%2C%20which%20is%20in%20the%20secondary%20role%2C%20is%20being%20restarted%20to%20resynchronize%20with%20the%20current%20primary%20database.%20This%20is%20an%20informational%20message%20only.%20No%20user%20action%20is%20required.%3C%2FP%3E%3CP%3E-Nonqualified%20transactions%20are%20being%20rolled%20back%20in%20database%20Administrator%20for%20an%20Always%20On%20Availability%20Groups%20state%20change.%20Estimated%20rollback%20completion%3A%20100%25.%20This%20is%20an%20informational%20message%20only.%20No%20user%20action%20is%20required.%3C%2FP%3E%3CP%3E-State%20information%20for%20database%20'dbname'%20-%20Hardened%20Lsn%3A%20'(20363%3A176333%3A1)'%20Commit%20LSN%3A%20'(20363%3A176332%3A1)'%20Commit%20Time%3A%20'Apr%208%202020%207%3A42PM'%3C%2FP%3E%3CP%3E-Always%20On%20Availability%20Groups%20connection%20with%20primary%20database%20established%20for%20secondary%20database%20'dbname'%20on%20the%20availability%20replica%20'nodename'%20with%20Replica%20ID%3A%20%7B...%7D.%20This%20is%20an%20informational%20message%20only.%20No%20user%20action%20is%20required.%3C%2FP%3E%3CP%3E-6%20transactions%20rolled%20forward%20in%20database%20'dbname'%20(5%3A0).%20This%20is%20an%20informational%20message%20only.%20No%20user%20action%20is%20required.%3C%2FP%3E%3CP%3E-Always%20On%20Availability%20Groups%20connection%20with%20primary%20database%20established%20for%20secondary%20database%20'dbname'%20on%20the%20availability%20replica%20'nodename'%20with%20Replica%20ID%3A%20%7B...%7D.%20This%20is%20an%20informational%20message%20only.%20No%20user%20action%20is%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThose%20logs%20lead%20me%20to%20believe%20the%20recovery%20process%20completed%20but%20the%20databases%20never%20actually%20recovered%2C%20syncing%20did%20not%20start%20back%20up.%26nbsp%3B%20What%20else%20can%20I%20look%20at%20to%20troubleshoot%20this%20issue%3F%26nbsp%3B%20Is%20this%20a%20bug%3F%26nbsp%3B%20We%20would%20like%20to%20figure%20out%20the%20root%20cause%20so%20this%20does%20not%20occur%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESQL%20Server%20version%2013.0.5598.27%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1295670%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eavailability%20groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERestores%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

We had a fail over last night due to Windows patches being applied.  Most databases were fine but we had a few that were stuck in Initializing / In Recovery.  From the logs I see the following for the databases in question.

 

-Availability database 'dbname', which is in the secondary role, is being restarted to resynchronize with the current primary database. This is an informational message only. No user action is required.

-Nonqualified transactions are being rolled back in database Administrator for an Always On Availability Groups state change. Estimated rollback completion: 100%. This is an informational message only. No user action is required.

-State information for database 'dbname' - Hardened Lsn: '(20363:176333:1)' Commit LSN: '(20363:176332:1)' Commit Time: 'Apr 8 2020 7:42PM'

-Always On Availability Groups connection with primary database established for secondary database 'dbname' on the availability replica 'nodename' with Replica ID: {...}. This is an informational message only. No user action is required.

-6 transactions rolled forward in database 'dbname' (5:0). This is an informational message only. No user action is required.

-Always On Availability Groups connection with primary database established for secondary database 'dbname' on the availability replica 'nodename' with Replica ID: {...}. This is an informational message only. No user action is required.

 

Those logs lead me to believe the recovery process completed but the databases never actually recovered, syncing did not start back up.  What else can I look at to troubleshoot this issue?  Is this a bug?  We would like to figure out the root cause so this does not occur again.

 

SQL Server version 13.0.5598.27

 

 

0 Replies