SAP Knowledge Base Article - Preview

2755380 - Crash message "Could not find key in hashtable" & s_hashtb, - SAP IQ 16.0 &16.1

Symptom

While regular daily loading job was processing, it enountered 's_hashtb.cxx: ... Could not find key in hashtable" and server was crash.

* Error & Stack >>

... Exception Thrown from slib/s_hashtb.cxx:411, Err# 1, tid 40 origtid 1457
... O/S Err#: 0, ErrID: 2059 (s_hashtb_exception); SQLCode: -1009069, SQLState: 'QSA69', Severity: 14
... [20090]: Internal system error. Could not find key in hashtable 
...
... **************************************************
... ***   SAP IQ Abort:
... ***   From: slib/s_hashtb.cxx:411
... ***   Rethrown from: oslib/hos_throw.cxx:278
...

===== Thread Number ... =====
..
.. hos_ABORT(..
.. Throw..
.. s_hashtb::ClearKey..
.. hos_largememAllocator::ReleaseInflexMem..
.. dfo_ColumnVectorBase::~dfo_ColumnVectorBase..
.. dfo_NonCopyColumnVector::~dfo_NonCopyColumnVector..
.. dfo::DestroyLastLeaf..
.. dfo_Root::~dfo_Root..
.. void throwsafe_delete..
.. db_dmlcommand::Shutdown..
.. db_dmlcommand::~db_dmlcommand..
.. db_LoadTable::~db_LoadTable..

Depending on many cases, before the crash , following Non-fatal error 'hos_mem.cxx' appeared repeatedly. But some other cases, server was crash without 'hos_mem.cxx' error.

'hos_mem.cxx' error is not mandatory.

* Error & stack >>

... Exception Thrown from slib/s_hashtb.cxx:411, Err# 1, tid 1254 origtid 1254
... O/S Err#: 0, ErrID: 2059 (s_hashtb_exception); SQLCode: -1009069, SQLState: 'QSA69', Severity: 14
... [20090]: Internal system error. Could not find key in hashtable
...
... MemID= 0 Status=LM_ALLOC Priority=LM_LOW MemSize= 32912 Counter=0 MemAddr=0x7ed905548000 Large Memory Inflexible slib/s_dpidx.cxx:5944
...
... ********************************************************
... **
... **    Non-Fatal IQ Internal Error Detected
... **    at oslib/hos_mem.cxx:2744 on thread 140104098424576 (TID 40)
... **
...
===== Thread Number 140104098424576 (IQ connID: 0013474081) =====
..
.. StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x299
.. hos_largememAllocator::ReleaseInflexMem(unsigned long long, unsigned long, void*)+0x641
.. s_ColumnVector::FreeArrays()+0x17f
.. dfo_ColumnVectorBase::CleanUp()+0x36
.. dfo_ColumnVectorBase::ReleaseShadowResources()+0x85
.. dfo::RecursivelyReleaseShadowResources()+0x29
.. dfo::RecursivelyReleaseShadowResources()+0x7f
.. dfo::RecursivelyReleaseShadowResources()+0x7f
.. dfo_Combiner::ShutdownSink(int)+0x205
.. dfo::PrepareToComplete()+0x69
.. dfo_Root::CompleteAllDFOsBelowRoot()+0x67
.. dfo_Root::Complete()+0x7a
.. db_dmlcommand::ExecuteDFOTree()+0x54e
.. db_LoadTable::Execute()+0xab
...


Read more...

Environment

  • SAP IQ16.0 SP11.x
  • SAP IQ16.1 SP03.02

Keywords

ReleaseInflexMem , FreeArrays , "s_hashtb::ClearKey", ClearKey, hashtable , hos_mem.cxx , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.