SAP Knowledge Base Article - Preview

2342105 - A query encountered server crash with stack symbol 's_fhashtb::InsertKey' -- SAP IQ

Symptom

While running a select query, suddenly IQ server was aborted with symbol 's_fhashtb::InsertKey'. In a certain case, the select query was a daily job.
Following is stack traces of reported Cases.

  • Abort stack in CR-826727 ;

...
.. hos_ABORT ..
.. s_fhashtb::InsertKey(s_fhProber&)+0x346
.. s_phash::InsertAndAggregateWithinQuota()+0x410
.. dfo_GroupByUnordered::FirstFetchWithNullsOrVarchar()+0x152
.. dfo_GroupByUnordered::FirstFetch()+0x36e
.. dfo_GroupByUnordered::FetchOpus()+0xb5
.. dfo_cOrderBy::PrefetchAndSort()+0x58e
.. dfo_cOrderBy::FetchOpus()+0x10c
.. dfo_GroupByOrdered::FetchOpus()+0x16a
.. dfjo_Hash::Fetch_T2_IntoHash()+0x68a
..

  • Abort stack in CR-800309 ;

...
.. hos_ABORT ..
.. s_fhasht::InsertKey ..
.. s_phash::Insert ..
.. dfjo_Hash::Fetch_T2_IntoHash ..
.. dfjo_Hash::SourcePreFetch ..
.. dfo_Join::SourcePreFetch ..
.. dfo_cOrderByParaIn15PrefetchAndSort ..
.. dfo_cOrderBy::SourcePreFetch ..
.. dfo_SourcePreFetch ..
..


Read more...

Environment

  • SAP IQ16.0 SP10.15
  • SAP IQ16.1 SP04.11

Product

SAP IQ 16.0

Keywords

"fast hash" ; "s_fhashtb::InsertKey" ;CR800309; 800309 ; CR826727, , 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.