IBM Support

IT08988: HADR STANDBY LOG REPLAY OR ROLLFORWARD RECOVERY CAN FAIL DUE TO SQLB_BAD_PAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During HADR replay or roll forward recovery, an insert may fail
    due to a bad page being returned from disk.  You will see
    messages in the db2diag.log similar to the following.
    
    2015-05-12-21.32.51.442700+480 I847140A6049   LEVEL: Warning
    PID     : 3473428           TID : 19020       PROC : db2sysc 0
    INSTANCE: db2inst1          NODE : 000        DB   : MYDB
    APPHDL  : 0-9               APPID: *LOCAL.DB2.150509115048
    HOSTNAME: myHost
    EDUID   : 19020             EDUNAME: db2redow (MYDB) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbGetPageFromDisk,
    probe:932
    MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
    Header"
              DIA8547C An error occurred in a database page header.
    DATA #1 : String, 39 bytes
    Page from disk doesn't match obj or BPD
    DATA #2 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
    pageHead: {tbspSeed:8;obj:5142;type:0} PPNum:793865 OPNum:793865
      begoff:                      48
      datlen:                    4048
      pagebinx:               2146491
      revnum:                    1280
      pagelsn:     0000000F3EA2F29E
      flag:                        2a
      future32:                    0
      cbits1to31:            1769af10
      cbits32to63:           3f06533b
    DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 256 bytes
        Pagekey: {pool:8;obj:5142;type:0} PPNum:801673
      objectPageNum:                    793865
      bucketGroupHashIndex:             279638
      hashnext:             0x0000000000000000
      hashprev:             0x0000000000000000
      bpdLatch:
    
       SXLatch :
    {
       state         = 0x0000000000010000
                     = {
                           held X: 1
                           reserved for X: 0
                           shared holders: 0
                           firstSharIndex: 0x0
                           firstExclIndex: 0x0
                       }
       starve X mode = true
       xWaitCount    = 0
       requestCount  = 0
       identity      = SQLB_BPD::bpdLatch_SX (253)
    }
       ULatch :
    {
       state         = 0x0000000000000000
                     = {
                           held X: 0
                           reserved for X: 0
                           shared holders: 0
                           firstSharIndex: 0x0
                           firstExclIndex: 0x0
                       }
       starve X mode = true
       xWaitCount    = 0
       requestCount  = 0
       identity      = NO_IDENTITY (0)
    }
      UFlags:                                0
      onDirtyListType:                       0
      isPageDirty:                           0
      pageAgeFlags:                          0
      pageStatusFlag:                        0
      permanentState:                        0
      transientState:                        0
      fixcount:                              1
      bpp:                  0x0a00030240b1b000
      pinCount:
    0x0A000300257F7C54 : 0000 0000
    ....
      weight:       00
      clnrPosCount:                          0
      dirtyprev:            0x0000000000000000
      dirtynext:            0x0000000000000000
      blockDesc:            0x0000000000000000
      pminlsn:              0000000000000000
      hatenext:             0x0000000000000000
      hateprev:             0x0000000000000000
      onWhichHateList:                   65535
      permanentHateList:                    21
      inMemoryChecksum:                      0
      newbpdidx:                    3221225472
      diskRelativePageID:              6251337
      lastLsnWARed:           0000000000000000
      LRB ptr:                   0x0000000000000000
      pendingReclaim:                             0
      pageGBPDependency:
    SQLB_PAGE_GBP_DEPENDENCY_NEVER_SHARED
      pageReclaimCount:                           0
      pageReclaimXCount:                          0
      pageReclaimXHoldingXCount:                  0
      indexLeafPageReclaimCount:                  0
      indexSMPPageReclaimCount:                   0
      XI_vectorIndex:                             0
      pageIsValid:                                0
    DATA #4 : Fix control block, PD_TYPE_SQLB_FIX_CB, 200 bytes
      accessMethod:  SQLB_POOL_RELATIVE
      fixMode:                        3   SQLBX | SQLBOLD
      buffptr:       0x0000000000000000
      bpdPtr:        0x0000000000000000
      pageLsnOnXLatch: 0000000000000000
      dmDebugHdl:                     0
      objectPageNum:         4294967295
      empDiskPageNum:         4294967295
      unfixFlags:                     0
      dirtyState:    SQLBCLEAN
      fixInfoFlags:                   1
      regEDUid:      0
        Pagekey: {pool:8;obj:5142;type:0} PPNum:801673
          Obj: {pool:8;obj:5142;type:0} Parent={8;5142}
      lifeLSN:       0000000F524A81A3
      tid:           0 0  0
      extentAnchor:                1600
      initEmpPages:                   0
      poolPage0:                      0
      poolflags:                    122
      objectState:                   27
      lastSMP:                        0
      pageSize:                    4096
      extentSize:                    64
      bufferPoolID:                   1
      partialHash:            336986120
      objDescAttributes:                  0
      bufferPool:    0x0a00020049f09440
      pdef:          0x0a0002004bd34200
      glob:          0x0000000111e9a340
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000000459EE1C sqlbGetPageFromDisk__FP11SQLB_FIX_CBi +
    0x950
      [1] 0x09000000064C8654 sqlbfix__FP11SQLB_FIX_CB + 0x1724
      [2] 0x09000000087BC578
    @113@sqldRedoUpsert__FP13SQLD_DFM_WORKP15SQLD_INSINFO_LRP9SQLP_L
    SN8Ul + 0x2780
      [3] 0x09000000087A08A8
    sqldRedo__FP8sqeAgentP8SQLD_LRHP9SQLP_LSN8UlN24 + 0x87C
      [4] 0x0900000008AE759C
    sqldmrdo__FP8sqeAgentUsP9SQLP_LSN8PcUlN35P8SQLP_TIDP15SQLD_RECOV
    _INFO + 0x5E8
      [5] 0x0900000008F3CA4C
    sqlpRecDbRedo__FP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcbP10SQLP_FRA
    PPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0x928
      [6] 0x0900000005282300
    sqlpPRecProcLog__FP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 0xBCC
      [7] 0x090000000527E4C4
    sqlpParallelRecovery__FP8sqeAgentP5sqlca + 0x1918
      [8] 0x0900000007331D74 sqleSubCoordProcessRequest__FP8sqeAgent
    + 0x198
      [9] 0x0900000006858724 RunEDU__8sqeAgentFv + 0x6FC
      [10] 0x0900000006855ACC EDUDriver__9sqzEDUObjFv + 0x13C
      [11] 0x0900000006855954 sqlzRunEDU__FPcUi + 0x10
      [12] 0x0900000006868CD8 sqloEDUEntry + 0x264
      [13] 0x0900000000839E10 _pthread_body + 0xF0
      [14] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    
    2015-05-12-21.32.51.479896+480 I853190A530    LEVEL: Severe
    PID     : 3473428           TID : 19020       PROC : db2sysc 0
    INSTANCE: db2inst1          NODE : 000        DB   : MYDB
    APPHDL  : 0-9               APPID: *LOCAL.DB2.150509115048
    HOSTNAME: myHost
    EDUID   : 19020             EDUNAME: db2redow (MYDB) 0
    FUNCTION: DB2 UDB, data management, sqldRedo, probe:8503
    RETCODE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
    Header" DIA8547C An error occurred in a database page header.
    
    2015-05-12-21.32.51.480241+480 I853721A648    LEVEL: Severe
    PID     : 3473428              TID : 19020    PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000     DB   : MYDB
    APPHDL  : 0-9                  APPID: *LOCAL.DB2.150509115048
    HOSTNAME: myHost
    EDUID   : 19020                EDUNAME: db2redow (MYDB) 0
    FUNCTION: DB2 UDB, data management, sqldmrdo, probe:1250
    MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
    Header" DIA8547C An error occurred in a database page header.
    DATA #1 : String, 25 bytes
    Error during REDO of LSN:
    DATA #2 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes
    0000000F7EF0221B
    
    2015-05-12-21.32.51.490418+480 E854370A594    LEVEL: Error
    PID     : 3473428           TID : 19020       PROC : db2sysc 0
    INSTANCE: db2inst1          NODE : 000        DB   : MYDB
    APPHDL  : 0-9               APPID: *LOCAL.DB2.150509115048
    HOSTNAME: myHost
    EDUID   : 19020             EDUNAME: db2redow (MYDB) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbSetPoolState,
    probe:3604
    MESSAGE : ADM12512W  Log replay on the HADR standby has stopped
    on table space "HIS_DATA_TBS" (ID "8") because it has been put
    into "ROLLFORWARD PENDING" state.
    

Local fix

  • If hit on the standby machine in an HADR pair, then reinitialize
    the standby database from the primary database.  If hit during
    crash recovery or rollforward recovery, contact IBM DB2 Support
    or restore a backup and rollforward to an earlier point in time.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 10.1.0.5.                             *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 version 10.1.0.5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT08988

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-19

  • Closed date

    2015-07-10

  • Last modified date

    2015-07-10

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

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

    IT09018

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"10.1"}]

Document Information

Modified date:
25 September 2021