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

• 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.

SAP IQ 16.0 SP11.09

Multiplex 4 node ( 1 coordinator + 3 write secondary nodes)

db_IndexDef::CloseSIndex, CloseSIndex, dfe_BaseColumn::CloseCatFieldAndIndexes, dfe_BaseColumn, CloseCatFieldAndIndexes, CR 811079, CR#811079, CR811079 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed