1998531 - Server crashed on db_TxnInfo::GetMode - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

SAP IQ 16.0 SP02

 

Product

SAP IQ 16.0

Keywords

db_TxnInfo, GetMode, df_Table, OpenForModification, HasTableOpenForModification, AttachStatsForDFE, df_heap, dfo, AttachStatsForDFE, CR761033, 761033   , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.