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 ONE Support launchpad (Login required).

Search for additional results

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