SAP Knowledge Base Article - Preview

3484784 - sp_iqcheckdb stacktraces when running against corrupted index - SAP IQ

Symptom

The following stack trace is generated when running sp_iqcheckdb against a corrupted object.

********************************************************
**
**       Non-Fatal IQ Internal Error Detected
**       at /home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h:467 on thread 139511986321152 (TID 3972)
**
**       Please report this to SAP IQ support
**       with the following diagnostic information,
**       and, if possible, with the user's command.
**
**  Error from IQ connection:  SA connHandle: 25  SA connID: 6  IQ connID: 0000000332  User: DBA
**  Time of error:  2024-06-18 09:10:02
**  IQ Version:  SAP IQ/16.1.050/11137/P/SP05.04
**  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/cad-ocbplhyb002/4.18.0-513.5.1.el8_9.x86_64/#1 SMP Fri Sep 29 05:21:10 EDT 2023/x86_64
**  Command status when error occurred:  COMMAND ACTIVE
**  Command text:  
call "sp_iqcheckdb"('check table MECH.NON_FIN_TXN')
 
***************** This is the STACKTRACE ***************

===== Thread Number 139511986321152 (IQ connID: 0000000332) =====
<unknown>
pcstkwalk
ucstkgentrace
StackTraceForThisThread
hs_ulcontainerexception::hs_ulcontainerexception
v2s_bmcontext::bmlfblkget
v2s_bmcontext::bmver
v2s_bmcontext::bmverify
s_bm::GatherStatistics
hs_dp::GatherStatistics
db_IndexDef::GatherStatistics
db_Statistics::db_Statistics
db_dbccIter::ExecWork
workAllocator::DoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
run_task_body
UnixTask::pre_body
<unknown>
<unknown>
 
******************* End of STACKTRACE ******************
**
**       End of stack trace from Non-Fatal IQ Internal Error /home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h:467
**
********************************************************

Exception Thrown from /home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h:467, Err# 1, tid 3972 origtid 3972
    O/S Err#: 0, ErrID: 2087 (hs_ulcontainerexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
[20189]: Unit List Internal Inconsistency: 
-- (/home/iqabuild/views/links/r16.1.0_sp05_nbld_linux_64/gitsrc/cm/iqa/include/s_unitList.h 467)  (1,1,0)
\{139511986321152\} DBCC: Statistics check detected exception from  INDEX { MECH.NON_FIN_TXN.ASIQ_IDX_T1326454_C304_FP }


Read more...

Environment

SAP IQ 16.1 SP05.04

Product

SAP IQ 16.1

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.