IT26775: HADR STANDBY HUNG AFTER LOSING CONNECTION WITH THE PRIMARY

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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 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