SAP Knowledge Base Article - Preview

2075410 - IQ15.4 - DQP worker crash in OpenSIndex during duplicate key removal

Symptom

IQ 15.4 ESD 3 and below will have a crash with following stack,

-----
I. 09/27 00:51:21. 0000000000 **************************************************
I. 09/27 00:51:21. 0000000000 *** Sybase IQ Abort:
I. 09/27 00:51:21. 0000000000 *** From: st_server.cxx:1430
I. 09/27 00:51:21. 0000000000 *** PID: 36589
I. 09/27 00:51:21. 0000000000 *** Message: caught signal 11, program abort
I. 09/27 00:51:21. 0000000000 *** Thread: 894297856 (TID: 908)
I. 09/27 00:51:21. 0000000000 **************************************************
I. 09/27 00:51:21. 0000000000
I. 09/27 00:51:21. 0000000000 ** Error from IQ connection:
I. 09/27 00:51:21. 0000000000 ** Time of error: 2014-09-27 00:51:21
I. 09/27 00:51:21. 0000000000 ** IQ Version: Sybase IQ/15.4.0/120816/P/ESD 2
I. 09/27 00:51:21. 0000000000 ** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/SICPSL-HIST-D03/3.0.13-0.27-default/#1 SMP Wed Feb 15 13:33:49 UTC 2012 (d73692b)/x86_64
I. 09/27 00:51:21. 0000000000 ** Command status when error occured: NO COMMAND OR CURSOR ACTIVE
I. 09/27 00:51:21. 0000000000 Dump all thread stacks at st_server.cxx:1430 for PID: 36589
I. 09/27 00:51:21. 0000000000
I. 09/27 00:51:21. 0000000000
I. 09/27 00:51:21. 0000000000 pc: 0x7f106828cb66 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x36
I. 09/27 00:51:21. 0000000000 pc: 0x7f106828cda1 ucstkgentrace(int, int)+0x111
I. 09/27 00:51:21. 0000000000 pc: 0x7f106828de21 DumpAllThreads(char const*, unsigned int, int)+0x111
I. 09/27 00:51:21. 0000000000 pc: 0x7f10680574cf hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x18f
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068afcb0f SigHndlr+0x4f
I. 09/27 00:51:21. 0000000000 pc: 0x7f10fdac47c0 typeinfo+0x9638b7b1
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067c68949 db_IndexDef::OpenSIndexWithLock(unsigned int, s_bm const*)+0x579
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067c63844 db_IndexDef::OpenSIndex(unsigned int, s_bm const*)+0x360
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068037fa2 df_Table::FindMultiColumnHG(hos_vector_noerror&, int)+0x302
I. 09/27 00:51:21. 0000000000 pc: 0x7f10680380ff df_Table::FindPrimaryKeyColumns(hos_vector_noerror const&, hos_vector_noerror&)+0xef
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067f8a1fe dfo::EliminateDuplicateKeysFromVector(hos_vector_noerror&, unsigned int&)+0x31e
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067f3a4c6 dfo_OrderBy::EliminateDuplicateKeys()+0x206
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067f3aca1 dfo_cOrderBy::dfo_cOrderBy(df_Heap*, dfo*, hos_vector_noerror const&, dfo_OrderBy::dfo_OrderBy_directions, dfo_OrderBy::dfo_OrderBy_key_constraints)+0x11
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067f3b51d dfo_cOrderByParaIn::dfo_cOrderByParaIn(dfo_cOrderBy const&, hos_vector_noerror const&, hos_vector_noerror const&, unsigned int)+0x4d
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068348319 opt_Driver::ApplyShadowTransform(dfo*, hos_vector_noerror*, hos_vector_noerror*)+0x2729
I. 09/27 00:51:21. 0000000000 pc: 0x7f106834891c opt_Driver::AddParallelShadowSubtrees(dfo*)+0x5dc
I. 09/27 00:51:21. 0000000000 pc: 0x7f1067dc42ad df_DQPFragment::Prepare()+0x26d
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068a79ee7 st_workerQueryFragment::Prepare(hos_Deserializer&)+0x467
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068a778e3 st_workerQueryFragment::Exec()+0x8d
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068a7f269 st_workerContextContainer::SetupWorkAllocatorExec(st_workerQueryFragment*)+0x2b9
I. 09/27 00:51:21. 0000000000 pc: 0x7f10682aa65a hos_thread::Main()+0x20a
I. 09/27 00:51:21. 0000000000 pc: 0x7f1068231d38 hos_lwtask::Start(hos_lwtask*)+0x58
I. 09/27 00:51:21. 0000000000 pc: 0x7f10fe1370dd IQWorkerStarter(void*)+0x4d
I. 09/27 00:51:21. 0000000000 pc: 0x7f10fe6dd81d run_task_body+0x2d
I. 09/27 00:51:21. 0000000000 pc: 0x7f10fe2d3a87 UnixTask::pre_body(void*)+0x77
I. 09/27 00:51:21. 0000000000 pc: 0x7f10fdabc7b6 typeinfo+0x963837a7
I. 09/27 00:51:21. 0000000000 pc: 0x7f10fd0919cd typeinfo+0x959589be

-----

In stktrc-XXXX-XXXX.iq:

  **  Error from IQ connection:      **  Time of error:  2014-09-27 00:51:21    **  IQ Version:  Sybase IQ/15.4.0/120816/P/ESD 2    **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/SICPSL-HIST-D03/3.0.13-0.27-default/#1 SMP Wed Feb 15 13:33:49 UTC 2012 (d73692b)/x86_64    **  Command status when error occured:  NO COMMAND OR CURSOR ACTIVEDump all thread stacks at st_server.cxx:1430 for PID: 36589

    ***************** This is the STACKTRACE ***************

 ===== Thread Number  894297856  (DQP queryID: 45235) =====
pc: 0x7f106828cb66 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x36
pc: 0x7f106828cda1 ucstkgentrace(int, int)+0x111
pc: 0x7f106828de21 DumpAllThreads(char const*, unsigned int, int)+0x111
pc: 0x7f10680574cf hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x18f
pc: 0x7f1068afcb0f SigHndlr+0x4f
pc: 0x7f10fdac47c0 typeinfo+0x9638b7b1
pc: 0x7f1067c68949 db_IndexDef::OpenSIndexWithLock(unsigned int, s_bm const*)+0x579
pc: 0x7f1067c63844 db_IndexDef::OpenSIndex(unsigned int, s_bm const*)+0x360
pc: 0x7f1068037fa2 df_Table::FindMultiColumnHG(hos_vector_noerror&, int)+0x302
pc: 0x7f10680380ff df_Table::FindPrimaryKeyColumns(hos_vector_noerror const&, hos_vector_noerror&)+0xef
pc: 0x7f1067f8a1fe dfo::EliminateDuplicateKeysFromVector(hos_vector_noerror&, unsigned int&)+0x31e
pc: 0x7f1067f3a4c6 dfo_OrderBy::EliminateDuplicateKeys()+0x206
pc: 0x7f1067f3aca1 dfo_cOrderBy::dfo_cOrderBy(df_Heap*, dfo*, hos_vector_noerror const&, dfo_OrderBy::dfo_OrderBy_directions, dfo_OrderBy::dfo_OrderBy_key_constraints)+0x11
pc: 0x7f1067f3b51d dfo_cOrderByParaIn::dfo_cOrderByParaIn(dfo_cOrderBy const&, hos_vector_noerror const&, hos_vector_noerror const&, unsigned int)+0x4d
pc: 0x7f1068348319 opt_Driver::ApplyShadowTransform(dfo*, hos_vector_noerror*, hos_vector_noerror*)+0x2729
pc: 0x7f106834891c opt_Driver::AddParallelShadowSubtrees(dfo*)+0x5dc
pc: 0x7f1067dc42ad df_DQPFragment::Prepare()+0x26d
pc: 0x7f1068a79ee7 st_workerQueryFragment::Prepare(hos_Deserializer&)+0x467
pc: 0x7f1068a778e3 st_workerQueryFragment::Exec()+0x8d
pc: 0x7f1068a7f269 st_workerContextContainer::SetupWorkAllocatorExec(st_workerQueryFragment*)+0x2b9
pc: 0x7f10682aa65a hos_thread::Main()+0x20a
pc: 0x7f1068231d38 hos_lwtask::Start(hos_lwtask*)+0x58
pc: 0x7f10fe1370dd IQWorkerStarter(void*)+0x4d
pc: 0x7f10fe6dd81d run_task_body+0x2d
pc: 0x7f10fe2d3a87 UnixTask::pre_body(void*)+0x77
pc: 0x7f10fdabc7b6 typeinfo+0x963837a7
pc: 0x7f10fd0919cd typeinfo+0x959589be


Read more...

Environment

IQ 15.4  ESD 3 and below

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

"OpenSIndexWithLock", "OpenSIndex" , , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.