Symptom
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::CreateDictionary(hs_vdo*)+0x104
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_catObjHelper::GetSIndex()+0x2c
db_AllocationChecker::db_AllocationChecker(hdb_catObj&, hs_xstats*, int, db_dbccIter*)+0x1b1
db_dbccIter::ExecWork(int&, unsigned int)+0x1438
workAllocator::DoWork(unsigned int)+0xba
hos_thread::Main()+0x20a
hos_lwtask::Start(hos_lwtask*)+0x58
IQWorkerStarter(void*)+0x4d
Read more...
Environment
SAP IQ 16 SP11.x
Product
Keywords
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.