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.
SAP Knowledge Base Article - Preview