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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.