SAP Knowledge Base Article - Preview

2280121 - "slib/s_barray.cxx:5377" Internal Error

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

SAP IQ 16.0

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.