[TRAFODION-1116] LP Bug: 1438943 - Select query with outer join of 3 repos tables from trafci failing with error 201 and esp core

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.1 (pre-incubation)
• Component/s: sql-exe
• External issue URL: https://bugs.launchpad.net/bugs/1438943
• Assignee: [e-mail]
• Reporter: Aruna Sadashiva
• Created: 22/Jul/15 18:19
• Updated: 31/Aug/15 04:35
• Resolved: 31/Aug/15 04:35

Description

Traf daily build 3/29.

From trafci :
Set schema “REPOS”;
Select * from metric_query_table, metric_query_aggr_table, metric_session_table;

It returns error 201s and there are esp cores with the stack below, it works ok from sqlci.

(gdb) bt
#0 0x00007ffff28b5625 in raise () from /lib64/libc.so.6
#1 0x00007ffff28b6e05 in abort () from /lib64/libc.so.6
#2 0x00007ffff40aaa55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff422af87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff40af96f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007fffe7962dcf in ?? ()
#7 0x00007ffff6d5b0f7 in eval (this=0x7fffe60c0780, newEntry=0x7ffff7ee36e0,
moveExpr=0x7fffe7962c50, hashValue=666, rc=0x7ffff7ef5b7c,
skipMemoryCheck=0) at ../exp/exp_expr.h:368
#8 Cluster::insert (this=0x7fffe60c0780, newEntry=0x7ffff7ee36e0,
moveExpr=0x7fffe7962c50, hashValue=666, rc=0x7ffff7ef5b7c,
skipMemoryCheck=0) at ../executor/cluster.cpp:1551
#9 0x00007ffff6da92e5 in insert (this=0x7ffff7ef5968)
at ../executor/cluster.h:1361
#10 ex_hashj_tcb::workReadInner (this=0x7ffff7ef5968)
at ../executor/ex_hashj.cpp:1737
#11 0x00007ffff6dad360 in ex_hashj_tcb::workUp (this=0x7ffff7ef5968)
at ../executor/ex_hashj.cpp:918
#12 0x00007ffff6e9ec73 in ExScheduler::work (this=0x7ffff7ebdfb8,
--Type <return> to continue, or q <return> to quit--
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#13 0x00007ffff6d70842 in ExEspFragInstanceDir::work (this=0x7fffffffc070,
prevWaitTime=356936) at ../executor/ex_esp_frag_dir.cpp:757
#14 0x000000000040620f in runESP (argc=3, argv=0x7fffffffc498,
guaReceiveFastStart=0x0) at ../bin/ex_esp_main.cpp:401
#15 0x0000000000406643 in main (argc=3, argv=0x7fffffffc498)
at ../bin/ex_esp_main.cpp:255