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

Search for additional results

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