SAP Knowledge Base Article - Preview

2542496 - IQ server got crashed with "db_IndexDef::CloseSIndex" in IQ 16.0.

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
......................................
......................................
pc: 0x7fd891e0269a hos_ABORT(...............
pc: 0x7fd892babe6f SigHndlr+0x4f
pc: 0x362ca0f7e0
pc: 0x362ca09470
pc: 0x7fd892c5b7d6 db_IndexDef::CloseSIndex(...............
pc: 0x7fd891987ee2 dfe_BaseColumn::CloseSIndex(...............
pc: 0x7fd891987a80 dfe_BaseColumn::CloseCatFieldAndIndexes(...............
pc: 0x7fd891988010 dfe_BaseColumn::~dfe_BaseColumn(...............
pc: 0x7fd892069005 hos_vector_noerror::ClearAndDestroy(...............
pc: 0x7fd89196f218 df_Table::~df_Table(...............
pc: 0x7fd89192d320 df_Heap::~df_Heap(...............
pc: 0x7fd891b8dc9a dfo_Root::Complete(...............
pc: 0x7fd892b5fde3 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


......................................
......................................
pc: 0x7f83c09d82a6 hos_ABORT(...............
pc: 0x7f83c0c3dd51 Throw(hos_exception const&)+0x3e1
pc: 0x7f83c18318b8 db_IndexDef::CloseSIndex(...............
pc: 0x7f83c055dee2 dfe_BaseColumn::CloseSIndex(...............
pc: 0x7f83c055da80 dfe_BaseColumn::CloseCatFieldAndIndexes(...............
pc: 0x7f83c055e010 dfe_BaseColumn::~dfe_BaseColumn(...............
pc: 0x7f83c0c3f005 hos_vector_noerror::ClearAndDestroy(...............
pc: 0x7f83c0545218 df_Table::~df_Table(...............
pc: 0x7f83c0503320 df_Heap::~df_Heap(...............
pc: 0x7f83c0763c9a dfo_Root::Complete(...............
pc: 0x7f83c1735de3 st_cursorIQtoSA::Complete(...............

  • The problematic queries were same except the referenced tables and the referenced two tables have the very similar structures.
    And, DBCC against the tables didn't 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 , Problem

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.