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 ***************
..
.. void __cdecl hos_ABORT( ..
.. long __cdecl ExcpFilter( ..
.. UnhandledExceptionFilter + 0x157
.. memset + 0x21b1
.. _C_specific_handler + 0x96
.. _chkstk + 0x11d
.. RtlImageNtHeaderEx + 0x483
.. KiUserExceptionDispatcher + 0x3a
.. memmove + 0x39
.. <unknown>
.. <unknown>
.. private: void __cdecl df_Heap::GenConstList(..
.. private: class df_Evaluable * __ptr64 __cdecl df_Heap::GenInDFP( ..
.. public: class df_Evaluable * __ptr64 __cdecl df_Heap::GenerateDF( ..
.. public: void __cdecl opt_QueryTree::AttachQueryNodesRestrictions( ..
.. public: void __cdecl opt_QueryTree::CreateNextQueryNode( ..
Read more...
Environment
- SAP IQ 16.1
- Windows
Product
Keywords
SYBASE , CR825190, CR#825190, 825190, large IN-List , IN-List , "IN List" , , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.