SAP Knowledge Base Article - Preview

3159564 - Double aborts with no stacktrace during running a simple query statement using "group by" clause -- SAP IQ

Symptom

IQ aborts with no stacktrace during running a simple query statement using "group by" clause.

--.iqmsg
I. 03/11 23:03:52. 0000000199 Collation EUC_KOREA, Case Respect, Blank Padding On, Comparisons are Conditioned
I. 03/11 23:03:52. 0000000199 Txn 70 0 70
I. 03/11 23:03:52. 0000000199 Connect: SA connHandle: 4 SA connID: 13 IQ connID: 0000000199 User: dba
...
I. 03/11 23:03:52. 0000000199 Txn 74 0 74
I. 03/11 23:03:52. 0000000199
I. 03/11 23:03:52. 0000000199
I. 03/11 23:03:52. 0000000199 **************************************************
I. 03/11 23:03:52. 0000000199 *** SAP IQ Abort:
I. 03/11 23:03:52. 0000000199 *** From: /home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64/gitsrc/cm/iqa/include/hos_canary.h:74
I. 03/11 23:03:52. 0000000199 *** Rethrown from: oslib/hos_throw.cxx:316
I. 03/11 23:03:52. 0000000199 *** PID: 12820
I. 03/11 23:03:52. 0000000199 *** Exception Location: 0x0x7fa7c5362640
I. 03/11 23:03:52. 0000000199 *** Error ID: 533, Exception Type: hos_assertexception
I. 03/11 23:03:52. 0000000199 *** Thread: 140358544942848 (TID: 2, Original TID: 2)
I. 03/11 23:03:52. 0000000199 *** Error #: 3, O/S Error #: 0
I. 03/11 23:03:52. 0000000199 *** Argument:
-- (/home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64/gitsrc/cm/iqa/include/hos_canary.h 74)
I. 03/11 23:03:52. 0000000199 **************************************************
I. 03/11 23:03:52. 0000000199
I. 03/11 23:03:52. 0000000199 140358544942848 Stacktrace requested from /home/iqabuild/views/links/r16.1.0_sp04_nbld_linux_64/gitsrc/cm/iqa/include/hos_canary.h:74 on thread 140358544942848 (TID 2) start stacktrace
I. 03/11 23:03:52. 0000000199 ** Error from IQ connection: SA connHandle: 4 SA connID: 13 IQ connID: 0000000199 User: dba
I. 03/11 23:03:52. 0000000199 ** Time of error: 2022-03-11 23:03:52
I. 03/11 23:03:52. 0000000199 ** IQ Version: SAP IQ/16.1.040/16220/P/SP04.11
I. 03/11 23:03:52. 0000000199 ** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/HOSTNAME/4.8.6-300.fc25.x86_64/#1 SMP Tue Nov 1 12:36:38 UTC 2016/x86_64
I. 03/11 23:03:52. 0000000199 ** Command status when error occurred: CURSOR ACTIVE
I. 03/11 23:03:52. 0000000199 ** Command text:
select "SUM"("DDLAF_LN_BAC")/100000000 as "bac",
case when "BND_PSV_C" in( '2','3' ) then
'1_sinyong'
else '2_dambo'
end as "a_gbn"
from "TEST_TB"
where "a_gbn" like '1%'
group by "BND_PSV_C"

I. 03/11 23:03:52. 0000000199 While handling one abort, encountered another abort from the same thread.
I. 03/11 23:03:52. 0000000199 Calling emergency shutdown.

Incompleted Stacktrace dumping due to double abort processing,

$ cat stktrc-20220311-230352_1.iq
** Error from IQ connection: SA connHandle: 4 SA connID: 13 IQ connID: 0000000199 User: dba
** Time of error: 2022-03-11 23:03:52
** IQ Version: SAP IQ/16.1.040/16220/P/SP04.11
** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/HOSTNAME/4.8.6-300.fc25.x86_64/#1 SMP Tue Nov 1 12:36:38 UTC 2016/x86_64
** Command status when error occurred: CURSOR ACTIVE
** Command text:
select "SUM"("DDLAF_LN_BAC")/100000000 as "bac",
case when "BND_PSV_C" in( '2','3' ) then
'1_sinyong'
else '2_dambo'
end as "a_gbn"
from "TEST_TB"
where "a_gbn" like '1%'
group by "BND_PSV_C"


Read more...

Environment

  • SAP IQ 16.1 SP04.11 Linux_x86-64
  • SAP IQ 16.1 SP05.01 Linux_x86-64

Product

SAP IQ 16.1

Keywords

 hos_assertexception , another abort , double abort , CR826320, 826320 , LF, HG, index , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

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.