SAP Knowledge Base Article - Preview

2584562 - IQ 16.0 server became crash when touching the inconsistent FP index

Symptom

While running DMLs, server encountered inconsistency on a FP index and following errors were appeared when touching the problematic table.

  • main Bufman: Decompression error during Read; from slib/s_buf.cxx:1787

  • Exception Thrown from slib/s_blockmap.cxx:6578, Err# 0, tid 1519 origtid 1519
    OS Err#: 0, ErrID: 2099 (s_decompressionexception); SQLCode: -1009046, SQLState: 'QSA46', Severity: 14
    [20067]:main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb.
    -- (slib/s_blockmap.cxx 6578)

  • slib/s_barray.cxx:11274 - get_suc 0, 0, 201326593 
    ********************************************************
    **
    ** Non-Fatal IQ Internal Error Detected
    ** at slib/s_barray.cxx:11276 on thread xxxxxxxxxxxxxxx (TID xxxx)
    ..
    call "<user_name>"."procedure_name"()
    ...
    ===== Thread Number xxxxxxxxxxxxxxx (IQ connID: 000000xxxx) =====
    pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
    ucstkgentrace(int, int)+0x121
    StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x314
    s_mergeFINALWriter::CompletePage()+0x368
    s_mergeFINALWriter::Complete()+0x4c
    hs_dpInsert::FinishedInsert()+0x3b
    dfiio_FP::FinishedInsert()+0x33
    dfo_IndexInsert::FinalFetchOpus()+0x182
    dfo::FinalFetch()+0x50
    ..

  • main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2928
    expected: btype=14,pbn=26814140308,txn=202842106,sp=16854,nlb=16,npb=16,iscmp=0,uid=172697817,blk=26814140308,mn=67,upmn=67,flgs=0x80000000
    head: btype=13,pbn=26814140308,txn=184235841,sp=354,nlb=16,npb=10,iscmp=1,ctr=136,cta=135,ver=2,pb=197,pus=43428
    buffer: 0x0d0010000a008887944f3f3e060000004137fb0a000000006201000002c5a4a9
    Expected Pad1: 148 (0x94), Pad2: 10457 (0x28d9)
    Got Pad1: 197 (0xc5), Pad2: 43428 (0xa9a4)
    There was an s_buf::Read() error during s_bufman::Find().
    ..
    **************************************************
    *** SAP IQ Abort:
    *** From: slib/s_blockmap.cxx:1271
    *** PID: xxxxxxx
    ..
    ===== Thread Number xxxxxxxxxxxxxxx (IQ connID: 000000xxxx) =====
    pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
    ucstkgentrace(int, int)+0x121
    DumpAllThreads(char const*, unsigned int, int)+0x259
    hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x26a
    s_blockmap::~s_blockmap()+0x141
    s_VersioningBlockmap::~s_VersioningBlockmap()+0x2a
    s_bufman::Rollback(unsigned long long, unsigned int, int)+0x2a0
    st_txncb::Rollback()+0x462
    st_txnMgr::Rollback()+0x174
    st_command::DoCmdThroughResourceGate()+0x82
    st_iqtxn::RollbackTxn(UIConnection*)+0x23
    UIQTxn_RollbackTxn+0x15
    st_SAIQInterfaceInfo::callFunction()+0x26
    st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x1ac
    st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x20a
    saint_iqthresholdtxn::RollbackTxn(IConnection*)+0xbd
    DB_Rollback_Chgs(Connection*)+0x231
    ..

  • DBCC with verify mode report inconsistent index error:
    (DBA)> sp_iqcheckdb 'verify table user_name.table_name';
    ..
    DBCC Verify Mode Report
    ================================================== ============================== ======
    ** DBCC Status Errors Detected ******
    DBCC Status Free list duplicates checking skipped on secondary server
    ** DBCC Decompress Errors 1 ******
    ..
    Index Statistics
    ================================================== ============================== ======
    ** Inconsistent Index user_name.FP_index_name
    ** Non-Completed Index user_name.FP_index_name ******


Read more...

Environment

SAP IQ 16.0 SP11 PL09

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

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.