IBM Support

IT36046: PANIC MAY OCCUR IN HADR TAKEOVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On Db2 V11.1 modpack4 fixpack 5, a user may experience FODC
    Panic during HADR Takeover.
    
    2019-12-26-20.20.24.454257-300 I160876693E1965       LEVEL:
    Severe
    PID     : 23806                TID : 140277369005824 PROC :
    db2sysc 0
    INSTANCE: db2inst1         NODE : 000            DB   : SAMPLE
    APPHDL  : 0-17               APPID: *LOCAL.DB2.191226132031
    HOSTNAME: test111
    EDUID   : 111                  EDUNAME: db2redom (SAMPLE) 0
    FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
    DATA #1 : <preformatted>
    sqle_panic: Panic/sleep = 0x0, flags = 0x0
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00007FA8C62149CD pdLogPrintf + 0x8D
      [1] 0x00007FA8C9E5CE8D _Z10sqle_panici + 0x52D
      [2] 0x00007FA8CC62245D _Z19sqlra_sqlcache_termP7sqlr_db +
    0x24D
      [3] 0x00007FA8C5ED4C9A
    _Z18hdrCleanupDbCachesP16sqeLocalDatabase + 0xFA
      [4] 0x00007FA8C9FA0D52
    _ZN16sqeLocalDatabase33HdrCleanupCacheInReplayOnlyWindowEP8sqeAg
    ent + 0x6F2
      [5] 0x00007FA8C9F9FE88
    _ZN16sqeLocalDatabase22HdrEndReplayOnlyWindowEP8sqeAgent + 0x68
      [6] 0x00007FA8CBFDFF12
    _Z29sqlpRemoveEntryFromTransTableP8sqeAgentP9SQLP_DBCBRK9SQLP_LS
    N8P11SQLP_TENTRY + 0x302
      [7] 0x00007FA8CBFCC803
    _Z15sqlprProcDPSrecP10SQLPR_PRCBjP20SQLPR_PR_QUEUE_ENTRY + 0x433
      [8] 0x00007FA8CBFF13C5 _Z18sqlprProcDpsQEntryP10SQLPR_PRCBb +
    0x3B5
      [9] 0x00007FA8CC023ED4
    _Z24sqlpshrLogMergeIterationP8sqeAgentP17SQLPSHR_MASTER_CBmPmS3_
    S3_ + 0x14B4
      [10] 0x00007FA8CC01F4C8
    _Z15sqlpshrScanNextPvP8sqeAgentmPP16SQLPR_LOGREC_DISPm + 0xD88
      [11] 0x00007FA8CBFCAF5C
    _Z15sqlpPRecReadLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb +
    0x621C
      [12] 0x00007FA8CBF92F36
    _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca + 0xCA6
      [13] 0x00007FA8C9E4C4DC
    _Z26sqleSubCoordProcessRequestP8sqeAgent + 0x17C
      [14] 0x00007FA8C9E6934E _ZN8sqeAgent6RunEDUEv + 0x5AE
      [15] 0x00007FA8CD79A4BE _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
      [16] 0x00007FA8CBCBB7BA sqloEDUEntry + 0x57A
      [17] 0x00007FA8D38A3EA5 /lib64/libpthread.so.0 + 0x7EA5
      [18] 0x00007FA8C32CC8CD clone + 0x6D
    
    
    Stack #1             Signal #6        Timestamp
    1577409624.498646000
    0        ossDumpStackTraceInternal
    1        ossDumpStackTraceV98
    2        OSSTrapFile::dumpEx
    3        sqlo_trce
    4        sqloEDUCodeTrapHandler
    5        __sigsuspend
    6        gsignal
    7        abort
    8        sqloExitEDU
    9        sqle_panic
    10       sqlra_sqlcache_term
    11       hdrCleanupDbCaches
    12       sqeLocalDatabase::HdrCleanupCacheInReplayOnlyWindow
    13       sqeLocalDatabase::HdrEndReplayOnlyWindow
    14       sqlpRemoveEntryFromTransTable
    15       sqlprProcDPSrec
    16       sqlprProcDpsQEntry
    17       sqlpshrLogMergeIteration
    18       sqlpshrScanNext
    19       sqlpPRecReadLog
    20       sqlpParallelRecovery
    21       sqleSubCoordProcessRequest
    22       sqeAgent::RunEDU
    23       sqzEDUObj::EDUDriver
    24       sqloEDUEntry
    25       pthread_detach
    26       clone
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.5.6 or later                                   *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.5.6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT36046

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-02-25

  • Closed date

    2021-06-09

  • Last modified date

    2021-06-09

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

    IT31416

  • 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

  • RB50 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 December 2021