SAP Knowledge Base Article - Preview

2483739 - Procedure sp_iqcheckdb could fail with a stacktrace [SAP IQ]


Procedure sp_iqcheckdb could fail when executed against a corrupt table. It generates trace below

  :Done ALLOCATION table: DPA001_14022017
  Start ALLOCATION processing index: ASIQ_IDX_T1196_C2_FP
  Start ALLOCATION processing index: ASIQ_IDX_T1196_C3_FP
  main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2928
  expected: btype=4,blk=13,pbn=3582932759,nlb=16,npb=3,uid=46255,txn=25218204,sp=0,mn=19542,upmn=19542,flgs=0x80008018,iscmp=1
  read: btype=13,nlb=16,npb=3,ctr=136,cta=134,pbn=3582932759,txn=25334804,sp=154,ver=2,pb=127,pus=20832 iscmp=1
  Expected Pad1: 175 (0xaf), Pad2: 13 (0x000d)
  Got Pad1: 127 (0x7f), Pad2: 20832 (0x5160)
There was an s_buf::Read() error during s_bufman::Find().
  Non-Fatal IQ Internal Error Detected at slib/s_blockmap.cxx:5790 on thread 140046912108288 (TID 2310)
  ** with Query_Name: distinct_count
  ** s_blockmap::Find args: lbn:13, btype:4, nBlocks:16, translating
  ** Unknown buffer manager internal error
  ** IQ Version: SAP IQ/16.0.110/10361/P/sp11.05
  s_blockmap::ThrowError(s_bufman_errorInfo, char const*, int)+0x155
  s_blockmap::Find(unsigned long long, short, int, s_bufmanCallerStats*)+0x2ae
  hs_btCache::GetFromDisk(unsigned long long, hs_btCacheItemPtr*, int)+0x10b
  hs_btCache::Find(unsigned long long, int, int)+0xee
  s_bt::BTFindEQ(void const*, int, void*, unsigned long long, hs_btcursor*)+0x90
  s_bt::Find(void const*, int, hos_op, void*, hs_btcursor*)+0xc4
  hs_vdo::GetRecID(void const*, int, hs_vdorecid*)+0xa2
  s_dpNBit::Initialize(s_openmode, unsigned long, unsigned long, int)+0x288
  hs_dp::hs_dp(db_IndexDef*, s_openmode, char const*, int, unsigned int, unsigned int, int)+0xf0e
  db_IndexDef::OpenSIndexWithLock(unsigned int)+0x1f7
  db_IndexDef::OpenSIndex(unsigned int)+0x34e
  db_AllocationChecker::db_AllocationChecker(hdb_catObj&, hs_xstats*, int, db_dbccIter*)+0x1b1
  db_dbccIter::ExecWork(int&, unsigned int)+0x1438
  workAllocator::DoWork(unsigned int)+0xba




SAP IQ 16 SP11.x


SAP IQ 16.0


CR805818, CR#805818, CR 805818, sybase, sp_iqcheckdb , , 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 for Me (Login required).

Search for additional results

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