2212422 - Non-Fatal stacktrace in s_bArrayLocater::PrefetchBatchFindPageInLookahead - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2212422 - Non-Fatal stacktrace in s_bArrayLocater::PrefetchBatchFindPageInLookahead - SAP IQ

Symptom

In some cases, queries with null-absorbing functions in predicates, such as CASE, COALESCE, IFNULL, will fail in s_bArrayLocater::PrefetchBatchFindPageInLookahead.

Non-Fatal IQ Internal Error will be detected with stacktrace while running certain queries.

I. 08/18 02:24:33. 0000112975     ********************************************************
I. 08/18 02:24:33. 0000112975     **
I. 08/18 02:24:33. 0000112975     **       Non-Fatal IQ Internal Error Detected
I. 08/18 02:24:33. 0000112975     **       at slib/s_barray.cxx:4985  on thread 140423894693632 (TID 491)
I. 08/18 02:24:33. 0000112975     **
...
***************** This is the STACKTRACE ***************
I. 08/18 02:24:33. 0000112975

===== Thread Number  140423894693632  (IQ connID: 0000112975) =====
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707d746d2 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707d74d41 ucstkgentrace(int, int)+0x121
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707d76493 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x313
I. 08/18 02:24:33. 0000112975 pc: 0x7fb70842fd05 hs_ThrowIdxException(char const*, int, hs_idxexception::hs_idxerrors, s_index const*, unsigned int, char const*, char const*)+0x35
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707dcd800 s_bArrayLocater::PrefetchBatchFindPageInLookahead(unsigned long long, s_ridmap_rec*)+0x230
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707de5918 s_bArrayLocater::LoadPage(unsigned long long)+0x528
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707de5d31 s_bArrayLocater::LocateTokenRecord(unsigned long long)+0x111
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707fd80c0 hs_dpfetch::FetchToken(unsigned long long)+0x10
I. 08/18 02:24:33. 0000112975 pc: 0x7fb708a98dd7 vpp_FindIter::DoOneWorkunit(unsigned int)+0xad7
I. 08/18 02:24:33. 0000112975 pc: 0x7fb708a9988b vpp_FindIter::ExecWork(int&, unsigned int)+0x7eb
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707d4cc8a workAllocator::DoWork(unsigned int)+0xba
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707d733e4 hos_thread::Main()+0x20a
I. 08/18 02:24:33. 0000112975 pc: 0x7fb707ce6c98 hos_lwtask::Start(hos_lwtask*)+0x58
I. 08/18 02:24:33. 0000112975 pc: 0x7fb87b899a8d IQWorkerStarter(void*)+0x4d
I. 08/18 02:24:33. 0000112975 pc: 0x7fb87bf859ad run_task_body+0x2d


Read more...

Environment

  • SAP IQ 16 GA and later

Product

SAP IQ 16.0

Keywords

CR788809, CR 796947, CR796947 , KBA , stacktrace , non-fatal , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.