IBM Support

IT31416: PANIC MAY OCCUR IN HADR TAKEOVER (11.1 M4fp5 only)

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

  • 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:                                              *
    * Db2 Version 11.1 modpack 4 fixpack 5                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.6                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31416

  • 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

    2020-01-06

  • Closed date

    2021-03-22

  • Last modified date

    2021-03-22

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

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

    IT36046

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
23 March 2021