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

• 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

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

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed