[TRAFODION-2837] mxosrvr coredump

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: any
• Fix Version/s: any
• Component/s: connectivity-mxosrvr
• Environment: centos 6.8, 2.3 incubating

Docs Text

coredump backtrace
#0 0x00007fbafd07e495 in raise () from /lib64/libc.so.6
#1 0x00007fbafd07fbfd in abort () from /lib64/libc.so.6
#2 0x00007fbafcb30040 in assert_botch_abend (f=0x7fbafb846586 "../executor/ex_sort.cpp", l=1212,
    m=0x7fbafb8466d0 "Must get a tuple from pool as they must be available", c=<value optimized out>) at ../export/NAAbort.cpp:295
#3 0x00007fbafb5f469f in ExSortTcb::sortSend (this=0x7fbaffe8c480, srcEntry=0x7fbac08fd740, srcStatus=<value optimized out>,
    pentry_down=0x7fbaffe8c610, upEntry=<value optimized out>, sortFromTop=0, step=@0x7fbaffe8c6ac, matchCount=@0x7fbaffe8c6b0,
    allocatedTuppDesc=@0x7fbaffe8c6b8, noOverflow=@0x7fbaffe8c6c0, workRC=@0x7fff87f1a09e) at ../executor/ex_sort.cpp:1212
#4 0x00007fbafb5f5f24 in ExSortTcb::workUp (this=0x7fbaffe8c480) at ../executor/ex_sort.cpp:871
#5 0x00007fbafb71792e in ExScheduler::work (this=0x7fbaffe8b378, prevWaitTime=<value optimized out>)
    at ../executor/ExScheduler.cpp:331
#6 0x00007fbafb5d47e2 in ex_root_tcb::execute (this=0x7fbaffe8df38, cliGlobals=0x16bde40, glob=0x7fbaffe89640, input_desc=
    0x7fbaffead148, diagsArea=@0x7fff87f1b740, reExecute=0) at ../executor/ex_root.cpp:1005
#7 0x00007fbafcdee1a5 in CliStatement::execute (this=0x7fbaffe95ab0, cliGlobals=0x16bde40, input_desc=0x7fbaffead148, diagsArea=
    ..., execute_state=<value optimized out>, fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:3422
#8 0x00007fbafcd77a9d in SQLCLI_PerformTasks(CliGlobals *, ULng32, SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0x16bde40, tasks=4882, statement_id=0x6dd0a50,
    input_descriptor=0x6dd1860, output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fff87f1b8f0,
    input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3237
#9 0x00007fbafcd785e2 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (cliGlobals=<value optimized out>, statement_id=<value optimized out>, input_descriptor=<value optimized out>,
    num_ptr_pairs=<value optimized out>, ap=<value optimized out>, ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3484
#10 0x00007fbafcdf6aab in SQL_EXEC_Exec (statement_id=0x6dd0a50, input_descriptor=0x6dd1860, num_ptr_pairs=0)

• Assignee: Unassigned
• Reporter: Gu Haiyan
• Created: 11/Dec/17 04:05
• Updated: 11/Dec/17 04:05

Description

when I do scan like this:
prepare s from select * from usertable where primary_key >= 'startKey' order by primary_key limit ?val;
set param ?val 10;
execute s;
set param ?val 20;
execute s;
The second execution failed with coredump if limit value is set larger than the first one. coredump file is attached