2235483 - UPDATE or DELETE causes crash in hs_ohc::DoPushDown() or hs_ohc::ForceInsertProbeAll - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2235483 - UPDATE or DELETE causes crash in hs_ohc::DoPushDown() or hs_ohc::ForceInsertProbeAll - SAP IQ

Symptom

UPDATE or DELETE statements may cause a server crash during THG Tier merging in hs_ohc::DoPushDown() or hs_ohc::ForceInsertProbeAll

You will see a stack trace similar to one of the following:

Dump all thread stacks at stcxtlib/st_server.cxx:1707 for PID: 42358
***************** This is the STACKTRACE ***************
===== Thread Number  140269639345920  (IQ connID: 0000000694) =====
...
pc: 0x7f930f26448f SigHndlr+0x4f
pc: 0x395820f710
pc: 0x7f930ee85c26 hs_ohc::ForceInsertProbeAll(unsigned long long*)+0x66
pc: 0x7f930eeb8845 hs_ohc::DoPushDown()+0x25
pc: 0x7f930eeb8dac hs_ohc::CheckTierThreshold()+0x1cc
pc: 0x7f930eeb8b01 hs_ohc::DoMerge()+0x61
...

Dump all thread stacks at stcxtlib/st_server.cxx:1707 for PID: 42358
***************** This is the STACKTRACE ***************
===== Thread Number  140269639345920  (IQ connID: 0000000694) =====
...
.. hs_ohc::CheckTierThreshold()+0x1cc
.. hs_ohc::DoMerge()+0x61
.. hs_ohcUpdate::Complete()+0x589
.. db_UpdateCompleteIterator::CompleteIndex(s_indexUpdate*)+0x64
.. db_UpdateCompleteIterator::ExecWork(int&, unsigned int)+0x85
.. workAllocator::DoWork(unsigned int)+0xba
.. hos_team::StartWork(void (*)+0xce
...   


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

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.