SAP Knowledge Base Article - Preview

3110661 - IQ server node crashes on df_Heap::GenConstList (large IN-clause) -SAP IQ

Symptom

IQ secondary node crashed on one specific query involving large IN-List ( 14585 values ).

According to IQ Maximum Limits, IQ supports up to 250,000 IN-List values.

Stacktrace generated :
 
0000208644 **************************************************
0000208644 ***   SAP IQ Abort:
0000208644 ***      From:  stcxtlib\st_server.cxx:1114
0000208644 ***      PID: 4592
0000208644 ***      Message: Program Abort
0000208644 ***      Thread: 5776  (TID: 88)
0000208644 **************************************************
0000208644 0000005776 Stacktrace requested from stcxtlib\st_server.cxx:1114 on thread 5776 (TID 88) start stacktrace
0000208644     **  IQ Version:  SAP IQ/16.1.040/14235/P/SP04.06
**  OS info:  IQ built on: MS/Windows 2012 R2,  Executed on: Windows/KMDSAPIQ2006/WinNT/10.0/Build 14393//x86 Family/level 6/Model 85/Stepping 7/20 CPU(s)
0000208644     **  Command status when error occurred:  CURSOR ACTIVE
0000208644     **  Command text: 
select  ... where  col in(......)
0000208644     **  Dump all thread stacks at stcxtlib\st_server.cxx:1114 for PID: 4592
***************** This is the STACKTRACE ***************
0000208644 pc: 0x00007FFE5B778171:  void __cdecl pcpstack(unsigned __int64,unsigned __int64,class db_log * __ptr64,class hos_fd * __ptr64,int) 0000000180668050 f hos_stacktrace.obj +0x121
0000208644 pc: 0x00007FFE5B7768BD:  void __cdecl DumpAllThreads(char const * __ptr64,unsigned int,int,unsigned __int64,unsigned __int64) 0000000180666580 f hos_stacktrace.obj +0x33d
0000208644 pc: 0x00007FFE5B512A1A:  void __cdecl hos_ABORT(char const * __ptr64,unsigned int,char const * __ptr64,char * __ptr64,char * __ptr64,struct sigcontext * __ptr64) 0000000180402660 f hos_abrt.obj +0x3ba
0000208644 pc: 0x00007FFE5BE805ED:  long __cdecl ExcpFilter(struct _EXCEPTION_POINTERS * __ptr64) 0000000180d705b0 f st_server.obj +0x3d
0000208644 pc: 0x00007FFE90A66227:  UnhandledExceptionFilter + 0x157
0000208644 pc: 0x00007FFE944AE431:  memset + 0x21b1
0000208644 pc: 0x00007FFE94496506:  _C_specific_handler + 0x96
0000208644 pc: 0x00007FFE944AA49D:  _chkstk + 0x11d
0000208644 pc: 0x00007FFE9443FD43:  RtlImageNtHeaderEx + 0x483
0000208644 pc: 0x00007FFE944A960A:  KiUserExceptionDispatcher + 0x3a
0000208644 pc: 0x00007FFE6A66C3B9:  memmove + 0x39
0000208644 pc: 0x000001FF7A25A9C0:  <unknown>
0000208644 pc: 0x000000000000000A:  <unknown>
0000208644 pc: 0x00007FFE5B14F669:  private: void __cdecl df_Heap::GenConstList(class hos_vector_noerror & __ptr64,struct an_expr_node * __ptr64,class opt_QueryExp * __ptr64) __ptr64 000000018003f490 f df_Heap.obj +0x1d9
0000208644 pc: 0x00007FFE5B14F17F:  private: class df_Evaluable * __ptr64 __cdecl df_Heap::GenInDFP(struct an_expr_node * __ptr64,class opt_QueryExp * __ptr64) __ptr64 000000018003edf0 f df_Heap.obj +0x38f
0000208644 pc: 0x00007FFE5B126FEF:  public: class df_Evaluable * __ptr64 __cdecl df_Heap::GenerateDF(void * __ptr64,class opt_QueryExp * __ptr64) __ptr64 0000000180016140 f df_GenerateDF.obj +0xeaf
0000208644 pc: 0x00007FFE5B4B6CC0:  public: void __cdecl opt_QueryTree::AttachQueryNodesRestrictions(class opt_QueryNode * __ptr64,class QueryNode * __ptr64,struct a_plist_node * __ptr64) __ptr64 00000001803a6c60 f opt_QueryTree.obj +0x60
0000208644 pc: 0x00007FFE5B4B59F4:  public: void __cdecl opt_QueryTree::CreateNextQueryNode(class opt_QueryNode * __ptr64,class QueryNode * __ptr64) __ptr64 00000001803a45e0 f opt_QueryTree.obj +0x1414


Read more...

Environment

  • SAP IQ 16.1
  • Windows

Product

SAP IQ 16.1

Keywords

SYBASE , CR825190, CR#825190,  825190 , 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.