Symptom
Non-Fatal IQ Internal Error "slib/s_barray.cxx:5377" occurred at every execution of a specific batch job.
It worked fine under 16.0 SP10.03 and started occurring after applying IQ patch 16.0 SP10.08.
[problematic query]
SELECT COL001, Y AS COL002, N AS COL003
INTO #TAB001
FROM
(
SELECT T.COL004, T.COL001 , T.COL005, T.COL006, T.COL007, T.COL008, T.COL009
FROM
( select COL004, COL001 , COL005, COL006,
COL007, COL008, COL009
from OWNER001.TAB002
where COL004 = v_COL004
AND ( (COL005 >= V001 or COL006 >=
V001)
OR (COL007 >= V001 or COL008 >= V001
)
OR COL009 >= V001
)
) T
WHERE (ISNULL(T.COL006, 1111-01-01 ) >= V001 AND
ISNULL(T.COL005, 1111-01-01 ) >= V001 AND ISNULL(
T.COL008, 1111-01-01 ) >= V001 AND ISNULL(T.
COL007, 1111-01-01 ) >= V001 AND ISNULL(T.
COL009, 1111-01-01 ) >= V001)
OR (ISNULL(T.COL006, 1111-01-01 ) >= V001 AND ISNULL(
T.COL005, 1111-01-01 ) >= V001 AND ISNULL(T.
COL008, 1111-01-01 ) >= V001 AND ISNULL(T.
COL007, 1111-01-01 ) >= V001 AND ISNULL(T.
COL009, 1111-01-01 ) = 1111-01-01 )
OR (ISNULL(T.COL006, 1111-01-01 ) >= V001 AND ISNULL(
T.COL005, 1111-01-01 ) >= V001 AND ISNULL(T.
COL008, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL007, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL009, 1111-01-01 ) = 1111-01-01 )
OR (ISNULL(T.COL006, 1111-01-01 ) >= V001 AND ISNULL(
T.COL005, 1111-01-01 ) >= V001 AND ISNULL(T.
COL008, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL007, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL009, 1111-01-01 ) >= V001)
OR (ISNULL(T.COL006, 1111-01-01 ) = 1111-01-01 AND ISNULL
(T.COL005, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL008, 1111-01-01 ) >= V001 AND ISNULL(T.
COL007, 1111-01-01 ) >= V001 AND ISNULL(T.
COL009, 1111-01-01 ) = 1111-01-01 )
OR (ISNULL(T.COL006, 1111-01-01 ) = 1111-01-01 AND ISNULL
(T.COL005, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL008, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL007, 1111-01-01 ) = 1111-01-01 AND ISNULL(T.
COL009, 1111-01-01 ) >= V001)
) X
WHERE ISNULL(X.COL005, 1111-01-01 )>= V001
;
[iqmsg]
...
--(Locater:6000003f861786b8,tid:2009)--> IQ Internal error on PrefetchBatchFindPageInLookahead recid: 31404463
--(Locater:6000003f861786b8,tid:2009)--> COL008
--(Locater:6000003f861786b8,tid:2009)--> curPage:0, lookupSize:128, startRecid:32648385, endRecid:32743616
--(Locater:6000003f861786b8,tid:2009)--> _batchPrefetchList:
--(Locater:6000003f861786b8,tid:2009)--> [0]: start_recid:32648385, end_recid:32743616, page_id:16730, sBufPtr:0000000000000000, upper:3161065865084928, lower:1742829009240064, i
sIMPage:0, block:9799832789158216026, pageEndRecid:32743616
--(Locater:6000003f861786b8,tid:2009)--> [1]: start_recid:32743617, end_recid:32838848, page_id:16793, sBufPtr:0000000000000000, upper:3161065865084928, lower:1742829009240064, i
sIMPage:0, block:9799832789158216089, pageEndRecid:32838848
--(Locater:6000003f861786b8,tid:2009)--> [2]: start_recid:32838849, end_recid:32934080, page_id:16852, sBufPtr:0000000000000000, upper:3161065865084928, lower:1742829009240064, i
sIMPage:0, block:9799832789158216148, pageEndRecid:32934080
Recid:0
--(Locater:6000003f861786b8,tid:2009)--> [127]: start_recid:0, end_recid:0, page_id:18446744073709551615, sBufPtr:0000000000000000, upper:0, lower:0, isIMPage:0, block:0, pageEnd
Recid:0
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_barray.cxx:5377 on thread 2009 (TID 2000)
**
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: 3475 SA connID: 59 IQ connID: 0000023004 User: user001
** Time of error: 2016-02-15 16:39:10
** IQ Version: SAP IQ/16.0.102.4/20104/P/sp10.08
** OS info: IQ built on: ITANIUM/HP-UXi 11.31, Executed on: HP-UX/host001/B.11.31/U/ia64
** Command status when error occured: CURSOR ACTIVE
** Command text:
...
[stacktrace]
(0) 0xc00000001f26fff0 _Z13ucstkgentraceii
(1) 0xc00000001f2712e0 _Z23StackTraceForThisThreadPKciS0_S0_S0_
(2) 0xc00000002115a550 _ZN15hs_idxexceptionC1EPKciNS_12hs_idxerrorsEPK7s_indexjS1_S1_
(3) 0xc00000002115a1b0 _Z20hs_ThrowIdxExceptionPKciN15hs_idxexception12hs_idxerrorsEPK7s_indexjS0_S0_
(4) 0xc00000001f3b1360 _ZN15s_bArrayLocater32PrefetchBatchFindPageInLookaheadEyP12s_ridmap_rec
(5) 0xc00000001f3aec30 _ZN15s_bArrayLocater8LoadPageEy
(6) 0xc00000001f3b9f70 _ZN15s_bArrayLocater17LocateTokenRecordEy
(7) 0xc00000001f9fff50 _ZNK10hs_dpfetch10FetchTokenEy
(8) 0xc0000000223b61d0 _ZN12vpp_FindIter13DoOneWorkunitEj
(9) 0xc00000002238a150 _ZN12vpp_FindIter8ExecWorkERij
(10) 0xc00000001f1dd650 _ZN13workAllocator6DoWorkEj
(11) 0xc00000001f1def30 _ZN13workAllocator7sDoWorkEPS_j
(12) 0xc00000001f26c380 _ZN10hos_thread4MainEv
(13) 0xc00000001f06ad40 _ZN10hos_lwtask5StartEPS_
(14) 0xc000000015e02790 _Z15IQWorkerStarterPv
(inlined) _Z21Perform_Version_Checkji at engine/unix/unixmain.c:594
(15) 0xc000000017b73ee0 run_task_body
(16) 0xc0000000167968c0 _ZN8UnixTask8pre_bodyEPv
(17) 0xc00000000013fe80 __pthread_bound_body
Read more...
Environment
IQ 16.0 SP10.08
HP-UXi 11.31
Multiplex
Product
Keywords
SAP IQ, s_barray, _ZN15s_bArrayLocater32PrefetchBatchFindPageInLookaheadEyP12s_ridmap_rec, s_bArrayLocater::PrefetchBatchFindPageInLookahead , 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.