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

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

IQ 15.4  ESD 3 and below

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