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