2456413 - server stack traces with dfjo_HashParaT1 function - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2456413 - server stack traces with dfjo_HashParaT1 function - SAP IQ

Symptom

In SAP IQ 16 SP11PL05 A complex query with hash joins causes multiple "signal 11"

  **************************************************
  ***   SAP IQ Abort:
  ***      From:  stcxtlib/st_server.cxx:1926
  ***      PID: 31464
  ***      Message: caught signal 11, program abort
  ***      Thread: 140723418732288  (TID: 406)
  **************************************************
 
      **  Error from IQ connection:  SA connHandle: 254117  SA connID: 40  IQ connID: 0001203125  User: CRM_BO
      **  Time of error:  2017-04-05 17:31:18
      **  IQ Version:  SAP IQ/16.0.110/10361/P/sp11.05
      **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/slpdfrsiqq301/3.10.0-327.28.3.el7.x86_64/#1 SMP Fri Aug 12 13:21:05 EDT 2016/x86_64
      **  Command status when error occured:  CURSOR ACTIVE
      **  Command text:
............................................
.......................................................................
................................................................................................
 Dump all thread stacks at stcxtlib/st_server.cxx:1926 for PID: 31464
0001203125
     ***************** This is the STACKTRACE ***************
0001203125
===== Thread Number  140723418732288  (IQ connID: 0001203125) =====
     **  While handling one abort, caught signal 11, program abort on thread 140723262871296 (TID 708)
     **  While handling one abort, caught signal 11, program abort on thread 140723322222336 (TID 593)
     **  While handling one abort, caught signal 11, program abort on thread 140723153975040 (TID 919)
 pc: 0x7ffe05801e42 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
 pc: 0x7ffe058024b1 ucstkgentrace(int, int)+0x121
 pc: 0x7ffe05803889 DumpAllThreads(char const*, unsigned int, int)+0x259
 pc: 0x7ffe0557fc5a hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x26a
 pc: 0x7ffe06325c9f SigHndlr+0x4f
 pc: 0x7ffff651f100 _fini+0xeee478b8
 pc: 0x7ffe052ce1a3 dfo_Join::SkipRec(dfo*)+0x83
 pc: 0x7ffe052ce181 dfo_Join::SkipRec(dfo*)+0x61
 pc: 0x7ffe0525792f dfjo_MergeKeyed::FetchOpus()+0x72f
 pc: 0x7ffe0524604e dfjo_HashParaT1::FetchOpus()+0x2ce
 pc: 0x7ffe0524604e dfjo_HashParaT1::FetchOpus()+0x2ce
 pc: 0x7ffe05369084 dfo_cOrderByParaIn::ExecWork(int&, unsigned int)+0x6d4
 pc: 0x7ffe057da28a workAllocator::DoWork(unsigned int)+0xba
 pc: 0x7ffe05800ae4 hos_thread::Main()+0x20a
 pc: 0x7ffe057656f8 hos_lwtask::Start(hos_lwtask*)+0x58
 pc: 0x7ffff6c06bad IQWorkerStarter(void*)+0x4d
 pc: 0x7ffff7329edd run_task_body+0x2d
 pc: 0x7ffff6e479f7 UnixTask::pre_body(void*)+0x77
 pc: 0x7ffff6517dc5 _fini+0xeee4057d
 pc: 0x7ffff5a35ced _fini+0xee35e4a5


Read more...

Environment

SAP IQ 16 SP11.x

 

Product

SAP IQ 16.0

Keywords

handling, abort, signal 11 , 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.