SAP Knowledge Base Article - Preview

3073221 - IQ Aborts on multiplex server with signal 11 - SAP IQ

Symptom

  • Query cause all secondary nodes to crash in a multiplex server:
  • iqmsg file:
    **************************************************
    ***   SAP IQ Abort:
    ***      From:  stcxtlib/st_server.cxx:1951
    ***      PID: 6383
    ***      Message: caught signal 11, program abort
    ***      Thread: XXX  (TID: XXX)
    **************************************************
    Stacktrace shows following modules:

dfjo_HashParaT1LeftOuters
hos_ABORT
dfo_cOrderByParaIn
s_buf*s_bufpartition::FindLogicalBuffer
hc_run::AdvanceBuffer
hc_subfrun::AdvanceBuffer
s_packedRec
hc_seltree::ReplaceChampion
hs_csortRetriever::Retrieve
dfo_cOrderByParaExch
dfo::Fetch
dfjo_MergeOuters::FetchOpus
dfo_cOrderBy:
dfjo_MergeBase::T1_PreFetch
dfo_Join::SourcePreFetch
dfjo_Hash::SourcePreFetch
dfo_Join::SourcePreFetch
dfo_Combiner::SourcePreFe
dfo_Combiner::FetchOpus
dfo_Window::FetchIntoStore
dfo_Window::LoadRecords
dfo_Window::FetchOpus
CLKPROF_NOFREESTKBUF

Disconnect:  SA connHandle: 1000000152  SA connID: 30  IQ connID: 0000000153  User: username
Chk ShutDQPCxt
Chk
ChkDone [NumTxnCP: XXX]
PostChk
CloseDatabase

  • stderr:

While handling one abort, caught signal 11, program abort on thread 1937 (TID 1928)
While handling one abort, caught signal 11, program abort on thread 1721 (TID 1712)
While handling one abort, caught signal 11, program abort on thread 2073 (TID 2064)
...

  • srvlog:

Database server shutdown due to HUP signal


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

CR825050, CR#825050, 825050 , KBA , BC-SYB-IQ , Sybase IQ , 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.