2451940 - IQ server report "main Bufman: Incorrect page header read" error and sometime crashed | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2451940 - IQ server report "main Bufman: Incorrect page header read" error and sometime crashed

Symptom

  1. IQ server crashed while executing 'load table' command with the following messages.

    main Bufman: Incorrect page header read; from slib/s_buf.cxx:2108
    s_blockmap: in use on destruction

     
    **************************************************
    *** SAP IQ Abort:
    *** From: slib/s_blockmap.cxx:1267
    *** PID: 125170
    *** Message: Internal Error
    *** Thread: 140390180284160 (TID: 5)
    **************************************************
    ......................
    ===== Thread Number 140390180284160 (IQ connID: 0000002268) =====
    pcstkwalk()
    ucstkgentrace()
    DumpAllThreads()
    hos_ABORT()
    s_blockmap::~s_blockmap()
    s_VersioningBlockmap::~s_VersioningBlockmap()
    s_bufman::PrivateFlush()
    s_bufman::ReleaseSavepoint()
    st_txncb::ReleaseSavepoint()
    st_txncb::ReleaseSavepoint()
    st_command::DoCmdThroughResourceGate()
    st_iqtxn::ReleaseSavepoint()
    UIQTxn_ReleaseSavepoint
  2. The following error messages can be also been found when accessing the corrupted table.
    1. main Bufman: Decompression error during Read; from slib/s_buf.cxx:1787
    2. main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2928
    3. The following error can be also been found when accessing the corrupted table.
       
      ********************************************************
      **
      ** Non-Fatal IQ Internal Error Detected
      ** at slib/s_blockmap.cxx:13065 on thread 140658448250624 (TID 797)
      ** s_ROBlockmapCursor::Find args: lbn:82024, btype:13, nBlocks:16, translating
      ** Unknown buffer manager internal error

      pcstkwalk()
      ucstkgentrace()
      StackTraceForThisThread()
       s_blockmap::ThrowError()
      s_ROBlockmapCursor::Find()
      s_bArrayCursor::Find()
      s_bArrayLocater::LoadBlock()
      s_bArrayLocater::LoadPage()
      s_bArrayLocater::LocateTokenRecord()
  3. You may see the barray dump for Ridmap in the iqmsg file and it also show the gap in the rid sequence.

    Txn 219908108 0 220397265
    LoadPage, recid=146154075 SRID=146098689 ERID=146154074 BLOCK=1158
    barray t140714472892160 C10 BEGIN dump RidMap:
    ----
    barray t140714472892160 C10 startRecid=145776129 endRecid=145937408 block=1156 hasNBit=1
    barray t140714472892160 C10 startRecid=145937409 endRecid=146098688 block=1157 hasNBit=1
    barray t140714472892160 C10 startRecid=146098689 endRecid=146154074 block=1158 hasNBit=1
    --- missing record id from 146154075 to 201326592
    barray t140714472892160 C10 startRecid=201326593 endRecid=201501312 block=4 hasNBit=1
    barray t140714472892160 C10 startRecid=201501313 endRecid=201676032 block=28 hasNBit=1
    barray t140714472892160 C10 startRecid=201676033 endRecid=201850752 block=42 hasNBit=1

  4. Ran DBCC against the target table. There are inconsistent FP indexes reported and the following message maybe reported.

    ** DBCC Status: Errors Detected ******
    ** DBCC Decompress Errors: 4 ******
    ** DBCC Unknown Exceptions: 3 ******
    ** FP Lookup Table Inconsistencies: 1 ******
    ** Inconsistent Index: user.tab.ASIQ_IDX_T820_C20_FP  ******
    ** Non-Completed Index : user.tab.ASIQ_IDX_T820_C1_FP  ******


Read more...

Environment

SAP IQ 16.0 SP11 PL05 Multiplex

Product

SAP IQ 16.0

Keywords

SAP IQ, IQ, Abort, Crash, CR806914, CR#806914, CR 806914, main Bufman, Incorrect page header read, s_blockmap, in use on destruction, s_VersioningBlockmap, s_bufman, PrivateFlush, CR807838, CR#807838, CR 807838 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.