none
SQL server AOAG fail, please advise RRS feed

  • Question

  • AOAG fail with the below text, can help to confirm is the heavy report queries caused the resource drain and hit the AOAG to fail
    also the were more that 5 queries were running but one was captured in log exec reportrun_Step2 so does it mean sql server says it is the issue query?

    Message
    Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000934E16CBB0, type 4, Task 0x00000194ABC47C28 : 28, waittime 300 seconds, flags

    0x1a, owning task 0x0000036D3ACC5468. Continuing to wait.


    Message
    Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000934E16CBB0, type 4, Task 0x0000002F5E16C108 : 26, waittime 300 seconds, flags

    0x1a, owning task 0x0000036D3ACC5468. Continuing to wait.

    Message
    Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000934E16CBB0, type 4, Task 0x000005FE7B5BA108 : 24, waittime 300 seconds, flags

    0x1a, owning task 0x0000036D3ACC5468. Continuing to wait.

    Message
    Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000934E16CBB0, type 4, Task 0x00000101020108C8 : 30, waittime 300 seconds, flags

    0x1a, owning task 0x0000036D3ACC5468. Continuing to wait.

    Message
    Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000934E16CBB0, type 4, Task 0x0000016D3DC228C8 : 23, waittime 300 seconds, flags

    0x1a, owning task 0x0000036D3ACC5468. Continuing to wait.

    Using 'dbghelp.dll' version '4.0.5'
    **Dump thread - spid = 437, EC = 0x000003B4E519A160

    ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\LOG\SQLDump0008.txt
    BEGIN STACK DUMP:03/06/17 16:36:04 spid 173064
    Latch timeout
    Input Buffer 102 bytes
    exec reportrun_Step2

    Short Stack Dump
    Stack Signature for the dump is 0x0000000112285B07
     [INFO]          Identity             Begin               End |        State                  Result     Error  Speculate   Prepared LazyCommit   ReadOnly |      

    Transaction         Database          ThreadId |   ReadSet  WriteSet   ScanSet Savepoint LogSizeRq | CommitDep TotalComm       Dependent 0       Dependent 1       

    Dependent 2       Dependent 3       Dependent 4       Dependent 5       Dependent 6       Dependent 7 |            Area  Location |
      Timeout waiting for external dump process 184740.

    Best Regards Moug

    Monday, March 6, 2017 12:23 PM

All replies

  • You say AGAO fails, but what you are posting here looks like a stack dump from the SQL Server error log. What do you see in your Always On dashboard?

    You may find that with Always On that queries on your secondary get blocked by the redo threads. Do you know if you were encountering this issue when you got this stack dump?

    Monday, March 6, 2017 12:30 PM
  • Moug,

    What is output of select @@version. This is not an AOAG issue but either some bug in SQL server because may be you have not patched SQL Server to latest SP or some really poor query running. 

    What queries were running when you got this message. Can you also show me the part of sql server errorlog when you got this message I mean few lines before and after this message 


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, March 7, 2017 5:12 AM
    Moderator