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.