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

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  ******

SAP IQ 16.0 SP11 PL05 Multiplex

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