IBM Support

IT26775: HADR STANDBY HUNG AFTER LOSING CONNECTION WITH THE PRIMARY

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • A timing issue can cause the db2hadrs EDU to self deadlatch when
    it detects the lost of connection with the primary database
    while in the middle of requesting new log file to be created.
    The following output from db2pd -stack of the db2hadrs EDU can
    confirm the problem:
    
    <Stack>
        0x090000000922BDA8 sqloXlatchConflict + 0x888
        0x0900000009BA0780 sqlpgPostLogAlloc__FP9SQLP_DBCBCUl +
    0x460
        0x090000000AA13130 hdrCloseConn__FP8HDR_DBCBUi + 0x990
        0x090000000AA12360
    hdrSendMsg__FP8HDR_DBCBiP13HDR_RQST_COMMbP14SqlzDB2Version +
    0x680
        0x090000000AA11B5C
    hdrWrapAndSendMsg__FP8HDR_DBCB9HDR_RTYPEUiPclT3PP13HDR_RQST_COMM
    + 0x2DC
        0x090000000AA30774 hdrSendHeartBeat__FP8HDR_DBCBCUl + 0x794
        0x090000000AA8CD20
    hdrSendHeartBeatAndUpdateReceiveTime__FP8HDR_DBCB + 0x20
        0x090000000AA4DBA4
    hdrWaitWithHeartBeat__FP16SQLO_EDUWAITPOSTPUiP8HDR_DBCB + 0xA4
        0x0900000009B9FFF8
    sqlpgWaitForLogAllocPostback__FP9SQLP_DBCB + 0x98
        0x0900000009BA061C sqlpgPostLogAlloc__FP9SQLP_DBCBCUl +
    0x2FC
        0x090000000A9E0AF4
    hdrSPostLogallocToCreateLogFile__FP9SQLP_DBCBUiCb + 0x254
        0x090000000A9E40E8
    hdrHandleXhdrMsg__FP8HDR_DBCBP11HDR_HDR_MSGPb + 0x1E28
        0x090000000AA75E88 hdrEduS__6hdrEduFPUl + 0x1A88
        0x090000000AA7FC18 hdrEduEntry__6hdrEduFv + 0x1438
        0x090000000AA8BC90 RunEDU__6hdrEduFv + 0x30
        0x09000000092BEBC0 EDUDriver__9sqzEDUObjFv + 0x300
        0x09000000091ADB14 sqloEDUEntry + 0x374
    </Stack>
    <LatchInformation>
    
    Waiting on latch type: (SQLO_LT_SQLP_DBCB__sqlp_logalloc_sem) -
    Address: (0xa0003000009b9a0), Line: 1016, File: sqlpgpst.C
    
    Holding Latch type: (SQLO_LT_SQLP_DBCB__sqlp_logalloc_sem) -
    Address: (0xa0003000009b9a0), Line: 1016, File: sqlpgpst.C
    HoldCount: 1
    </LatchInformation>
    
    This problem was first introduced in V10.5 fixpak 5.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26775

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-29

  • Closed date

    2020-01-18

  • Last modified date

    2020-01-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 January 2020