IBM Support

IT22143: No room for retrieved log number xxx in retrieveArray during Rollfoward or Crash recovery

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1. Rollforward might fail with the following messages in the
    db2diag.log if the logs are compressed and the number of log
    files required for Rollforward is higher than 264
    
    EDUID   : 8822                 EDUNAME: db2lfr.0 (W1P) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveStartUse, probe:190
    DATA #1 : <preformatted>
    WARNING: No room for retrieved log number 731930 in
    retrieveArray. Index 18446744073709551615 entryCount 264
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x0900000015C3C4CC pdLogPrintf + 0x28
      [1] 0x09000000123FC008
    sqlpgRetrieveStartUse__FP14sqlpMasterDbcbUiUsPUlUlPCcCUlT5 +
    0x86C
      [2] 0x0900000011E09630
    sqlpgOpenLogExtentAndUncompress__FP9SQLP_DBCBPCcPP9SQLP_LECBCUiU
    l + 0x678
      [3] 0x0900000012400E30
    sqlplfrFMOpenLog__FP12SQLPLFR_DBCBUiP21SQLPLFR_REQ_SCAN_NEXTUlPU
    lPP9SQLP_LECB + 0x15B4
      [4] 0x0900000011E28434
    sqlplfrFMReadLog__FP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQL
    PLFR_SCAN_DATA + 0x4008
      [5] 0x0900000015A0F8D0 RunEDU__9sqpLfrEduFv + 0xB38
      [6] 0x09000000159DD8E4 RunEDU__9sqpLfrEduFv + 0x864
    
    2. Crash recovery might fail with the following:
    
    EDUID   : 33                   EDUNAME: db2lfr.0 (RON)
    FUNCTION: DB2 UDB, data protection services, sqlpRenameStartUse,
    probe:190
    MESSAGE : ZRC=0x071000EA=118489322=SQLPG_EXT_COMPRESSED
              "Log extent is compressed."
    DATA #1 : <preformatted>
    sqlpRenameStartUse error
    
    EDUID   : 33                   EDUNAME: db2lfr.0 (RON)
    FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent,
    probe:7140
    MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
              DIA8526C A fatal error occurred in data protection
    services.
    
    
    EDUID   : 33                   EDUNAME: db2lfr.0 (RON)
    FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:390
    MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
              DIA8526C A fatal error occurred in data protection
    services.
    DATA #1 : <preformatted>
    LFR Scan Num            = 3
    LFR Scan Caller's EDUID = 3182
    Open error on log extnum 266.
    
    EDUID   : 33                   EDUNAME: db2lfr.0 (RON)
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveStartUse, probe:190
    DATA #1 : <preformatted>
    
    WARNING: No room for retrieved log number 266 in retrieveArray.
    Index 18446744073709551615 entryCount 264
    
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00002B8BC1FA96BA pdLogVPrintf + 0x1B8
      [1] 0x00002B8BC1FA9ABF pdLogPrintf + 0xF3
      [2] 0x00002B8BC5DA9C07
    _Z21sqlpgRetrieveStartUseP14sqlpMasterDbcbjtPmmPKctm + 0x1439
      [3] 0x00002B8BC5EBC676
    _Z18sqlpgOpenLogExtentP9SQLP_DBCBPKcPP9SQLP_LECBjm + 0x482
      [4] 0x00002B8BC5F4D505
    _Z16sqlplfrFMOpenLogP12SQLPLFR_DBCBjP21SQLPLFR_REQ_SCAN_NEXTmPmP
    P9SQLP_LECB + 0x262F
      [5] 0x00002B8BC5F2D12A
    _Z16sqlplfrFMReadLogP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQ
    LPLFR_SCAN_DATA + 0x424
      [6] 0x00002B8BC5F3EEAF
    _Z28sqlplfrPrefetchNextFMReadLogP12SQLPLFR_DBCBmP21SQLPLFR_REQ_S
    CAN_NEXT + 0x117
      [7] 0x00002B8BC5F38C09
    _Z17sqlplfrDoScanNextP12SQLPLFR_DBCBP11SQLPLFR_REQ + 0x24A5
      [8] 0x00002B8BC5F3C4D7 _Z10sqlplfrEduP9sqpLfrEdu + 0xB1B
      [9] 0x00002B8BC6172122 _ZN9sqpLfrEdu6RunEDUEv + 0x90
      [10] 0x00002B8BC849E80C _ZN9sqzEDUObj9EDUDriverEv + 0x17C
      [11] 0x00002B8BC849E434 _Z10sqlzRunEDUPcj + 0x26
      [12] 0x00002B8BC5C2222D sqloEDUEntry + 0x971
      [13] 0x00002B8BBFDD2193 /lib64/libpthread.so.0 + 0x6193
      [14] 0x00002B8BCF4F10DD __clone + 0x6D
    
    Conditions to hit this problem:
    In both scenarios
    a) Recovery requires more than 265 logs
    b) Logical logs are compressed
    
    For Crash recovery failure
    
    c) logical logs have been manually copied into the primary path
    (still compressed) and the number of logs is higher than 264
    d) Infinite logging is enabled
    
    
    For rollforward failure
    e) If the overflowlogpath configuration parameter (or the
    "OVERFLOW LOG PATH" on the rollforward command) points to an
    archive log directory that contains compressed archived log
    files and the number of logs is higher than 264.
    

Local fix

  • DB2 will decompress logs as needed if the number of logs to
    decompress is higher than 264 issue the rollforward/ crash
    recovery again.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22143

  • 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

    2017-08-25

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

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

    IT20385

  • 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":"BU053","label":"Cloud & Data Platform"},"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:
19 March 2018