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