SAP Knowledge Base Article - Preview

2972897 - SAP IQ aborts in hos_attention::_Check and hc_run::CreateBuffer when a query is cancelled

Symptom

IQ aborts with following stacktrace when a query is cancelled

--.iqmsg

 Exception Thrown from slib/s_run.cxx:800, Err# 3, tid 2 origtid 2
    O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -1006120, SQLState: 'QBB20', Severity: 14
 [20358]: The operation has been cancelled - Max_Query_Time exceeded


 **************************************************
 ***   SAP IQ Abort:
 ***      From:  stcxtlib/st_server.cxx:2127
 ***      PID: 23684
 ***      Message: caught signal 11, program abort
 ***      Thread: 140041206503168  (TID: 2)
 **************************************************

     **  Error from IQ connection:  SA connHandle: 6468  SA connID: 28  IQ connID: 0000049078  User: iquser
     **  Time of error:  2020-09-18 13:08:42
     **  IQ Version:  SAP IQ/16.0.110/11876/P/sp11.22
     **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/linuxhost/2.6.32-754.29.1.el6.x86_64/#1 SMP Thu Mar 12 19:09:58 EDT 2020/x86_64
     **  Command status when error occured:  CURSOR ACTIVE
     **  Command text:

===== Thread Number  140041206503168  (IQ connID: 0000049078) =====
pcstkwalk
ucstkgentrace
DumpAllThreads
hos_ABORT
SigHndlr+0x59
_fini+0x1cb03dfc
hs_csort::DoLastRetrieveStats
hs_csort::~hs_csort
hos_ObjectStack::Throw
Throw
hos_attention::_Check
hc_run::CreateBuffer
hc_run::NewBuffer
hc_frun::Append
hs_csort::MergePhase
hs_csort::MergeRuns
hs_csort::MergeMetaRuns
hs_csort::MergeIntoSingleRun
hs_csort::PrepareToRetrieveCommon
hs_csort::PrepareToRetrieve
dfo::FindDistinctsFromSample
dfo::SamplingGroupByColumns
dfo::GetGroupByBestFactorEstimate
dfo_GroupBy::GetCardinalityEstimate
opt_GroupNode::GatherMetaDataAndSelectGroupingAlgorithm
opt_QueryTree::ProcessQueryTree
opt_Select::GenerateDFOs
opt_Select::GenerateDFOs
opt_Select::GenerateDFOs
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor+0x25
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
dfo_Scan::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetch
dfo_Root::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetchRelative
dfo_Root::FetchRelative
DB_Search_fetch
do_move_cursor


Read more...

Environment

  • SAP IQ 16.0 SP11.12
  • SAP IQ 16.0 SP11.19
  • SAP IQ 16.0 SP11.22

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.