Symptom
- A secondary node got crashed with "db_IndexDef::CloseSIndex" and the two stacktraces were almost identical except the error messages.
- [1st crash]
select top 100000 "COL001","DATEADD"("second","COL002","COL001") ...................
Dump all thread stacks at stcxtlib/st_server.cxx:1926 for PID: 9151
......................................
......................................
hos_ABORT(...............
SigHndlr
db_IndexDef::CloseSIndex(...............
dfe_BaseColumn::CloseSIndex(...............
dfe_BaseColumn::CloseCatFieldAndIndexes(...............
dfe_BaseColumn::~dfe_BaseColumn(...............
hos_vector_noerror::ClearAndDestroy(...............
df_Table::~df_Table(...............
df_Heap::~df_Heap(...............
dfo_Root::Complete(...............
st_cursorIQtoSA::Complete(............... - [2nd crash]
select top 100000 "COL001","DATEADD"("second","COL002","COL001") ........................
Dump all thread stacks at /remote/rip/iqbuild/views/links/r16.0.0_sp11_git_linux_64/gitsrc/cm/iqa/include/hos_mutex_inline.h:316 for PID: 9180
......................................
......................................
hos_ABORT(...............
Throw(hos_exception const&)
db_IndexDef::CloseSIndex(...............
dfe_BaseColumn::CloseSIndex(...............
dfe_BaseColumn::CloseCatFieldAndIndexes(...............
dfe_BaseColumn::~dfe_BaseColumn(...............
hos_vector_noerror::ClearAndDestroy(...............
df_Table::~df_Table(...............
df_Heap::~df_Heap(...............
dfo_Root::Complete(...............
st_cursorIQtoSA::Complete(...............
- The problematic queries were same except the referenced tables and the referenced two tables have the very similar structures.
- DBCC against the tables did not detect any error.
Read more...
Environment
SAP IQ 16.0 SP11.09
Multiplex 4 node ( 1 coordinator + 3 write secondary nodes)
Product
SAP IQ 16.0
Keywords
db_IndexDef::CloseSIndex, CloseSIndex, dfe_BaseColumn::CloseCatFieldAndIndexes, dfe_BaseColumn, CloseCatFieldAndIndexes, CR 811079, CR#811079, CR811079 , 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.