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.