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
Product
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.
SAP Knowledge Base Article - Preview