SAP Knowledge Base Article - Preview

2786467 - Detected another IPHR case with s_dpidx.cxx:7758 with stack at hs_dp::CheckIndexConsistency -- SAP IQ

Symptom

Customer, on IQ 16.1 SP03 PL04 Linux simplex server, created from new (i.e. not upgraded from an earlier version). They have been 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.Checkdb of two involved tables reported inconsistencies on a number of FP and HG indexes.  It's regarded ad new IPHR issue and will be investigated.

>> *.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

SAP IQ 16.1

Keywords

's_dpidx.cxx:7758',  'hs_dp::CheckIndexConsistency' , IPHR , , 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 ONE Support launchpad (Login required).

Search for additional results

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