SAP Knowledge Base Article - Preview

2652378 - s_dpNBit::Initialize involved in aborts, lots of threads with ZLock::get - SAP IQ

Symptom

  • Randomly, IQ could crash on a SELECT on a single table with fatal abort, signal 11.
  • DBCC verify table and sp_iqcheckfpconsistency run before and after the crash, and report NO ERROR.
  • The first stack in the stack trace could be different.
  • In the stack trace, many threads could have ZLock::get as in Abort 1 below

ABORT 1

_fini+0x3258be6c

_fini+0x32587c88
UnixTask::wait
CondVar::wait
Worker::do_wait
Worker::wait_ex
Worker::wait
Worker::block
ZLock::get
dbi_lock
oExecuteStmt
db__execute

ABORT 2

_fini+0x4e492e6c
s_bt::BTFindEQ
s_bt::Find
hs_vdo::GetRecID
s_dpNBit::Initialize
hs_dp::CreateDictionary
hs_dp::hs_dp
db_IndexDef::OpenSIndexWithLock
db_IndexDef::OpenSIndex
dfe_BaseColumn::SetupCatalogData
dfe_BaseColumn::TypeCheck
df_Evaluable::DepthFirstTypeCheck
opt_SelectList::GenerateDFEs
opt_Select::InitializeNestedQueries
opt_Driver::GenerateTree

ABORT 3

_fini+0x8e4d4e6c
hs_btcursor::hs_btcursor
s_BTCursorAndBuf::Allocate
s_index::sIndexSanityCheck
s_index::NullCount
s_fetchRow::CreateHandleList
s_fetchRow::InitRowStream
vp_Projections::PrepareFetch
vp_Cursor::Execute
dfo_VerticalLeafCursor::ExecuteVerticalPredsAndPrepareToProject
dfo_VerticalLeafCursor::PrepareOpus
dfo::PrepareChildren
dfo_Cursor::PrepareOpus
dfo::PrepareChildren
dfo::PrepareOpus
dfo_Root::Prepare


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

CR815305 ; CR#815305 ; 815305 ; ZLock::get ; s_dpNBit::Initialize ; hs_dp::CreateDictionary ; s_index::sIndexSanityCheck , 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.