Symptom
- IQ aborts with following stacktrace when canceling a query.
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
Keywords
KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.