Symptom
- On an IQ 16.1 SP03 PL04 Linux simplex server:
- Created from new IQ server (Not upgraded from an earlier version).
- While loading data and running testing for a number of weeks
- Before running into 'token count mismatch' -- s_llhtable.cxx:3684
- Followed by Non-Fatal at s_dpidx.cxx:7758 with stack at hs_dp::CheckIndexConsistency
- While loading into two tables.
- sp_iqcheckdb of two involved tables reported inconsistencies on a number of FP and HG indexes.
>> *.iqmsg ;
.. t140372026242816: token=0 offset=0
.. s_TokenTable Dump Token Counter, maxToken=0
.. t140372026242816: token=0 count=10360
.. _hashTab->_gToken,_numUnusedTokens,_scale,MemId=1,0,0,0
.. slib/s_llhtable.cxx:3684 datatype varchar not supported yet.
..
.. ********************************************************
.. **
.. ** Non-Fatal IQ Internal Error Detected
.. ** at slib/s_dpidx.cxx:7758 on thread 140372026242816 (TID 609)
.. **
...
===== Thread Number 140372026242816 (IQ connID: 0001136846) =====
.. pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x38
.. ucstkgentrace(int, int)+0x13d
.. StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x299
.. hs_dp::CheckIndexConsistency(int)+0x34ba
.. hs_dpInsert::Complete()+0x183
.. dfiio_FP::PostFetchOpus()+0x6c
.. dfo_IndexInsert::PostFetchOpus()+0x9a
.. df_CombinerFinalFetchHelper::ExecWork(int&, unsigned int)+0xd42
..
.. {140372114634496} main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:3093 into buffer 0x4f2adc0
.. {140372114634496} expected: btype=14,pbn=254113309,txn=64731587,sp=1,nlb=16,npb=16,iscmp=0,uid=35836159,...
...
.. There was an s_buf::Read() error during s_bufman::Find().
.. The following exception is from GetBlockmapEntryInfo
.. Blockmap Member Variables for 0x95aed2b8
.. From slib/s_dpidx.cxx:640
..
.. Exception Thrown from slib/s_blockmap.cxx:7287, Err# 0, tid 443 origtid 443
.. O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
.. [20060]: 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.
..
Read more...
Environment
SAP IQ16.1 SP03.04
Product
Keywords
's_dpidx.cxx:7758', 'hs_dp::CheckIndexConsistency' , IPHR , , 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.
SAP Knowledge Base Article - Preview