1998531 - Server crashed on db_TxnInfo::GetMode - SAP IQ

• The database fell over ungracefully with a stack trace.
• Every time server restarted, it will run for a few minutes and fell over again with a stack trace.
• The message from iqsmg:

I..  Advice: Convert HG index on IDMI04.MI_D_CUSTOMER_T.CUST_NO to a unique HG 
I.. **************************************************
I.. ***   Sybase IQ Abort:
I.. ***      From:  stcxtlib/st_server.cxx:1539
I.. ***      PID: 28839
I.. ***      Message: caught signal 11, program abort
I.. ***      Thread: 41154880  (TID: 82)
I.. **************************************************

• The stack trace contain the following functions:

pcstkwalk
ucstkgentrace
DumpAllThreads
hos_ABORT
SigHndlr
db_TxnInfo::GetMode
df_Table::OpenForModification
df_Heap::HasTableOpenForModification
dfo::AttachStatsForDFE
dfo::GatherPlanStats

• Options Enabled for user executed the query:

Index_Advisor: ON
Query Plan: ON
Index_Advisor=ON
Revert_To_V15_Optimizer:  ON
Max_Hash_Rows:  25000000  (default: 2500000)
Query_Temp_Space_Limit:  55000  (default: 0)
Infer_Subquery_Predicates:  OFF
Prefetch_Sort_Percent:  50  (default: 20
Query contains : CASE expression and Left Outer Join.

SAP IQ 16.0 SP02

db_TxnInfo, GetMode, df_Table, OpenForModification, HasTableOpenForModification, AttachStatsForDFE, df_heap, dfo, AttachStatsForDFE, CR761033, 761033   , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed