SAP Knowledge Base Article - Preview

2239176 - Crash at s_fetchGroup with GROUP BY HAVING or WHERE - SAP IQ

Symptom

  • SAP IQ 16 systems running queries using the index-based GROUP BY algorithm in combination with a HAVING clause condition, or a WHERE clause condition on one of the GROUP BY columns may cause a server failure from s_fetchGroup::s_fetchGroup
Dump all thread stacks at stcxtlib/st_server.cxx:1709 for PID: 27251
    ***************** This is the STACKTRACE ***************
 ===== Thread Number  824  (IQ connID: 0000000071) =====
pc: 0x0 (0x0, 0x0)
pc: 0xfffffd7f64571187 void DumpAllThreads(const char*,unsigned,int)+0x29f(0xe8, 0xfffffd7f66beff50)
pc: 0xfffffd7f64256cca void hos_ABORT(const char*,unsigned,const char*,char*,char*)+0x1a2(0x7320746867756163, 0x3131206c616e6769)
pc: 0xfffffd7f6522f1e5 SigHndlr+0x41(0xfffffd7f4e1dd120, 0xfffffd7ffd7125e2)
pc: 0xfffffd7ffd71dd16 _fini+0x97208f56(0xfffffd7f4e1dd4d0, 0xb00b8bf5b)
pc: 0xfffffd7ffd7125e2 _fini+0x971fd822(0x0, 0x0)
pc: 0xfffffd7ffd71280e _fini+0x971fda4e(0xb, 0xfffffd7f4e1dd4d0)
pc: 0xffffffffffffffff _fini+0x1284c6f(0x32f0000000c, 0x5c1c495f1)
pc: 0xfffffd7f65499b41 s_fetchGroup::s_fetchGroup #Nvariant 1(const s_bm*,int,s_index**,s_index**,dfp**,unsigned*,unsigned,s_aggInfo*,unsigned,vp_GroupedProjection*,df_Heap*,ThreadTimingStats*)+0x661(0x5c1af6038, 0x1)
pc: 0xfffffd7f654b5450 void vp_GroupedProjection::PrepareFetch(int)+0x2d4(0x1cc2a9eb4000, 0x5c0f73528)
pc: 0xfffffd7f65498190 void vp_Cursor::Execute()+0x94(0x0, 0x5c1b0bac8)
...

Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

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.