SAP Knowledge Base Article - Preview

3671002 - select statement with MEDIAN function AND DISTINCT clause causes stack trace and crashes the server - SAP IQ

Symptom

  • Running select statement with MEDIAN function along with DISTINCT clause.
  • The SAP IQ database went down unexpectedly.
  • Following stacktrace is generated. 
  • I. 10/17 10:49:00. 0000010110 Connect:  SA connHandle: 1000010109  SA connID: 14  IQ connID: 0000010110  User: dbo
    I. 10/17 10:49:00. 0000010110 Cmt 1957 Txn 1956
    I. 10/17 10:49:00. 0000010110 TINFO t=1956 v=1956 c=1957 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
    I. 10/17 10:49:00. 0000010110 Disconnect:  SA connHandle: 1000010109  SA connID: 14  IQ connID: 0000010110  User: dbo
    I. 10/17 10:49:08. 0000000482 
    I. 10/17 10:49:08. 0000000482 
    I. 10/17 10:49:08. 0000000482 **************************************************
    I. 10/17 10:49:08. 0000000482 ***   SAP IQ Abort:
    I. 10/17 10:49:08. 0000000482 ***      From:  stcxtlib/st_server.cxx:2643
    I. 10/17 10:49:08. 0000000482 ***      PID: 3054
    I. 10/17 10:49:08. 0000000482 ***      Message: caught signal 11, program abort (pc=0x00007fe8aa440197, sp=0x00007fe8adc34dc0, fp=0x00007fe8adc34dd0, addr=0x00000000000001f8)
    I. 10/17 10:49:08. 0000000482 ***      Thread: 140637324412672  (TIX: 2)
    I. 10/17 10:49:08. 0000000482 **************************************************
    I. 10/17 10:49:08. 0000000482 
    I. 10/17 10:49:08. 0000000482 140637324412672 Stacktrace requested from stcxtlib/st_server.cxx:2643 on thread 140637324412672 (TIX 2) start stacktrace
    I. 10/17 10:49:08. 0000000482     **  Error from IQ connection:  SA connHandle: 1  SA connID: 17  IQ connID: 0000000482  User: dba
    I. 10/17 10:49:08. 0000000482     **  Time of error:  2025-10-17 10:49:08
    I. 10/17 10:49:08. 0000000482     **  IQ Version:  SAP IQ/16.1.050/15831/P/SP05.15
    I. 10/17 10:49:08. 0000000482     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/IQTREINPITR/4.18.0-348.7.1.el8_5.x86_64/#1 SMP Wed Dec 22 13:25:12 UTC 2021/x86_64
    I. 10/17 10:49:08. 0000000482     **  Command status when error occurred:  CURSOR ACTIVE
    I. 10/17 10:49:08. 0000000482     **  Command text: 
    I. 10/17 10:49:08. 0000000482 select "FOLDER_NAME",
    I. 10/17 10:49:08. 0000000482   "WORKFLOW_NAME",
    I. 10/17 10:49:08. 0000000482   "MEDIAN"(distinct "DIFF_IN_MIN") as "DIFF_IN_MIN"
    I. 10/17 10:49:08. 0000000482   from "ADW_DASHBOARD_ALL_DATA_AVG_TIME_base"
    I. 10/17 10:49:08. 0000000482   group by "WORKFLOW_NAME",
    I. 10/17 10:49:08. 0000000482   "FOLDER_NAME"
    I. 10/17 10:49:08. 0000000482 [20535]: Query Plan:
    I. 10/17 10:49:08. 0000000482 [20535]: 0    #04:  Root
    I. 10/17 10:49:08. 0000000482 [20535]:         Child Node 1:  #05
    I. 10/17 10:49:08. 0000000482 [20535]:         Estimated Result Rows:  6
    I. 10/17 10:49:08. 0000000482 [20535]:         User Name:  dba   (SA connHandle: 1  SA connID: 17)
    I. 10/17 10:49:08. 0000000482 [20535]:         Est. Temp Space Used (Mb):     0.0
    I. 10/17 10:49:08. 0000000482 [20535]:         Cursor Name:  SQL_CUR_7f24eca920d0
    I. 10/17 10:49:08. 0000000482 [20535]:         Requested attributes:  Scroll Read Only Hold Chained
    I. 10/17 10:49:08. 0000000482 [20535]:         Effective Number of Users:  1
    I. 10/17 10:49:08. 0000000482 [20535]:         Setting of -iqnumbercpus:  1
    I. 10/17 10:49:08. 0000000482 [20535]:         Number of CPUs (available):  1
    I. 10/17 10:49:08. 0000000482 [20535]:         Number of CPUs (total):  1
    I. 10/17 10:49:08. 0000000482 [20535]:         Executed on:
    I. 10/17 10:49:08. 0000000482 [20535]:           Linux/IQTREINPITR/4.18.0-348.7.1.el8_5.x86_64/#1 SMP Wed Dec 22 13:25:12 UTC 2021/x86_64
    I. 10/17 10:49:08. 0000000482 [20535]:         IQ Main Cache Size (Mb):  64
    I. 10/17 10:49:08. 0000000482 [20535]:         IQ Temp Cache Size (Mb):  64
    I. 10/17 10:49:08. 0000000482 [20535]:         IQ Large Memory Size (Mb):  2048
    I. 10/17 10:49:08. 0000000482 [20535]:         Threads used for executing local invariant predicates:  1
    I. 10/17 10:49:08. 0000000482 [20535]:         Option Result_Cache_Temp_Pct:  20  (default: 0)
    I. 10/17 10:49:08. 0000000482 [20535]:         Option CORE_Options125:  4096  (default: 0)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output Vector:  3 entries (20 data bytes)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 1:
    I. 10/17 10:49:08. 0000000482 [20535]:           FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 1     Data Type:  varchar(7)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 1     Column's Declared Data Type:  varchar(255)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 1     Base Distincts:  4
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 2:
    I. 10/17 10:49:08. 0000000482 [20535]:           FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 2     Data Type:  varchar(9)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 2     Column's Declared Data Type:  varchar(255)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 2     Base Distincts:  4
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 3:
    I. 10/17 10:49:08. 0000000482 [20535]:           MEDIAN(DISTINCT FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1)))
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 3     Data Type:  integer (10, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 3     Base Distincts (Est.):  5
    I. 10/17 10:49:08. 0000000482 [20535]: 1    #05:  Scrolling Cursor Store
    I. 10/17 10:49:08. 0000000482 [20535]:         Parent Node:  #04
    I. 10/17 10:49:08. 0000000482 [20535]:         Child Node 1:  #03
    I. 10/17 10:49:08. 0000000482 [20535]:         Estimated Result Rows:  6
    I. 10/17 10:49:08. 0000000482 [20535]:         Output Vector:  3 entries (20 data bytes)
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 1:
    I. 10/17 10:49:08. 0000000482 [20535]:           FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 2:
    I. 10/17 10:49:08. 0000000482 [20535]:           FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:         Output 3:
    I. 10/17 10:49:08. 0000000482 [20535]:           MEDIAN(DISTINCT FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1)))
    I. 10/17 10:49:08. 0000000482 [20535]: 2    . #03:  Group By (Sort)
    I. 10/17 10:49:08. 0000000482 [20535]:           Parent Node:  #05
    I. 10/17 10:49:08. 0000000482 [20535]:           Child Node 1:  #02
    I. 10/17 10:49:08. 0000000482 [20535]:           Estimated Result Rows:  6
    I. 10/17 10:49:08. 0000000482 [20535]:           Optimizer est. max hash rows for these keys:  367539
    I. 10/17 10:49:08. 0000000482 [20535]:           SMP ineligible reason:  Too few estimated rows
    I. 10/17 10:49:08. 0000000482 [20535]:           Grouping Expression 1:
    I. 10/17 10:49:08. 0000000482 [20535]:             FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:           Grouping Expression 2:
    I. 10/17 10:49:08. 0000000482 [20535]:             FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:           Aggregate Expression 1:
    I. 10/17 10:49:08. 0000000482 [20535]:             MEDIAN(DISTINCT FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1)))
    I. 10/17 10:49:08. 0000000482 [20535]:           Production 1:
    I. 10/17 10:49:08. 0000000482 [20535]:             FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:           Production 2:
    I. 10/17 10:49:08. 0000000482 [20535]:             FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:           Output Vector:  3 entries (20 data bytes)
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 1:
    I. 10/17 10:49:08. 0000000482 [20535]:             FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 1     Data Type:  varchar(7)
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 1     Column's Declared Data Type:  varchar(255)
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 1     Base Distincts:  4
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 2:
    I. 10/17 10:49:08. 0000000482 [20535]:             FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 2     Data Type:  varchar(9)
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 2     Column's Declared Data Type:  varchar(255)
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 2     Base Distincts:  4
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 3:
    I. 10/17 10:49:08. 0000000482 [20535]:             MEDIAN(DISTINCT FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1)))
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 3     Data Type:  integer (10, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:           Output 3     Base Distincts (Est.):  5
    I. 10/17 10:49:08. 0000000482 [20535]: 3    . . #02:  Order By
    I. 10/17 10:49:08. 0000000482 [20535]:             Parent Node:  #03
    I. 10/17 10:49:08. 0000000482 [20535]:             Child Node 1:  #01
    I. 10/17 10:49:08. 0000000482 [20535]:             Estimated Result Rows:  6
    I. 10/17 10:49:08. 0000000482 [20535]:             Ordering Expression 1:
    I. 10/17 10:49:08. 0000000482 [20535]:               FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:             Ordering Expression 2:
    I. 10/17 10:49:08. 0000000482 [20535]:               FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:             Production 1:
    I. 10/17 10:49:08. 0000000482 [20535]:               FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:             Output Vector:  3 entries (6 data bytes)
    I. 10/17 10:49:08. 0000000482 [20535]:             Output 1:
    I. 10/17 10:49:08. 0000000482 [20535]:               FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:             Output 2:
    I. 10/17 10:49:08. 0000000482 [20535]:               FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:             Output 3:
    I. 10/17 10:49:08. 0000000482 [20535]:               FPVALUE(FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1))
    I. 10/17 10:49:08. 0000000482 [20535]:             Output 3     Data Type:  integer (10, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:             Output 3     Base Distincts:  5
    I. 10/17 10:49:08. 0000000482 [20535]: 4    . . . #01:  Leaf
    I. 10/17 10:49:08. 0000000482 [20535]:               Table Name:  ADW_DASHBOARD_ALL_DATA_AVG_TIME_base
    I. 10/17 10:49:08. 0000000482 [20535]:               Parent Node:  #02
    I. 10/17 10:49:08. 0000000482 [20535]:               Table Row Count:  6
    I. 10/17 10:49:08. 0000000482 [20535]:               Estimated Result Rows:  6
    I. 10/17 10:49:08. 0000000482 [20535]:               SMP ineligible reason:  Optimizer cost too low: 0.00
    I. 10/17 10:49:08. 0000000482 [20535]:               Projection Per Row:  3 columns (3 bytes)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output Vector:  3 entries (3 data bytes)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 1:
    I. 10/17 10:49:08. 0000000482 [20535]:                 FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.WORKFLOW_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 1     Data Type:  ordinal (1, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 1     Column's Declared Data Type:  varchar(255)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 1     Base Distincts:  4
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 1     Note:  FP(2-bit) index used by optimizer
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 1     Indexes:  FP(2-bit)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 2:
    I. 10/17 10:49:08. 0000000482 [20535]:                 FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.FOLDER_NAME, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 2     Data Type:  ordinal (1, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 2     Column's Declared Data Type:  varchar(255)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 2     Base Distincts:  4
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 2     Note:  FP(2-bit) index used by optimizer
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 2     Indexes:  FP(2-bit)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 3:
    I. 10/17 10:49:08. 0000000482 [20535]:                 FPORDINAL(ADW_DASHBOARD_ALL_DATA_AVG_TIME_base.DIFF_IN_MIN, 1)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 3     Data Type:  ordinal (1, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 3     Column's Declared Data Type:  integer (10, 0)
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 3     Base Distincts:  5
    I. 10/17 10:49:08. 0000000482 [20535]:               Output 3     Indexes:  FP(3-bit)
    I. 10/17 10:49:08. 0000000482     **  Dump all thread stacks at stcxtlib/st_server.cxx:2643 for PID: 3054
    I. 10/17 10:49:08. 0000000482 ***************** This is the STACKTRACE ***************
    I. 10/17 10:49:08. 0000000482 ===== Thread Number 140637324412672 (IQ connID: 0000000482) =====
    I. 10/17 10:49:08. 0000000482 pc: 0x400e71 backtrace+21
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a9ac41e4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a9ac490b ucstkgentrace(int, int)+18b
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a9ac51cd DumpAllThreads(char const*, unsigned int, int)+2bd
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a983c421 hos_ABORT(char const*, unsigned int, char const*, char*, char*, sigcontext*, int, int)+4f1
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa6ab9dc SigHndlr+11c
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8de7afc20 <unknown>
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa440197 s_phash::Clear()+7
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a941a648 dfe_ManyCachedValues::Reset()+18
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a945ab77 dfe_MedianAggregate::Reset()+37
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a95795f0 dfo_GroupBy::PrepareOpus()+190
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a95797c9 dfo_GroupByOrdered::PrepareOpus()+19
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a9533fc7 dfo::PrepareChildren()+67
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a95f6b37 dfo_Cursor::PrepareOpus()+77
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a9533fc7 dfo::PrepareChildren()+67
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a95585e1 dfo::PrepareOpus()+11
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a95e9343 dfo_Root::Prepare()+a3
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa664676 st_cursorIQtoSA::Prepare()+156
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a93f51ab df_OpenCursor::Prepare()+5b
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa65f0eb st_command::DoCmdThroughResourceGate()+5b
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa6a7f52 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+32
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a939eb15 UIQDML_OpenCursor+25
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa6b260b st_SAIQInterfaceInfo::callFunction()+1b
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa718c9e st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+ce
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8aa6b2ab3 st_SAIQInterface::Execute(int, void*, unsigned int (*)(void*, void*), void*, unsigned int)+353
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8a9ad740b saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+8b
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0e7f4e df_OmniRowScan::Restart(a_cursor_orientation)+1ce
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0c9488 dfo_Scan::DoFetch(a_cursor_orientation)+b8
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0c8feb dfo_Scan::DoFirstFetch(a_cursor_orientation)+9b
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0ae827 dfo_Base::Fetch(a_cursor_orientation)+a7
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0b73d4 dfo_Root::DoFetch(a_cursor_orientation)+44
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0b7660 dfo_Root::DoFirstFetch(a_cursor_orientation)+30
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0ae827 dfo_Base::Fetch(a_cursor_orientation)+a7
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0afa1d dfo_Root::DoFetchRelative(int, int*)+bd
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df0b2b51 dfo_Root::FetchRelative(int, int*)+91
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8dec7e995 DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+65
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8dee1a8a2 dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+e2
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8def878f2 db__fetch(Connection*, an_sqlpres_receive*)+1b2
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defa7356 RequestProcedure::call()+e76
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8ded494b1 Worker::spawn(Procedure*)+31
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defab286 EngStream::handle_ind(unsigned char, unsigned int)+156
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defacdbf EngStream::execute()+7ff
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defacf3d RQConnItem::do_request()+d
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defa4cde RQBaseItem::do_work(Worker*)+1e
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defe8a07 RequestQueue::worker_body()+77
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defa6099 request_task(void*)+89
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8df431b9e run_task_body+1e
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8defea668 UnixTask::pre_body(void*)+78
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8de7a517a <unknown>
    I. 10/17 10:49:08. 0000000482 pc: 0x7fe8ddbb9dc3 clone+43


Read more...

Environment

SAP IQ/16.1.050/15831/P/SP05.15
(REPRODUCIBLE IN LINUX and AIX).

Product

SAP IQ all versions

Keywords

database crash, unexpected failure, SELECT query, DISTINCT clause, median function, error 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 for Me (Login required).

Search for additional results

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