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

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1116:
-------------------------------------

             Summary: LP Bug: 1438943 - Select query with outer join of 3 repos tables from trafci failing with error 201 and esp core
                 Key: TRAFODION-1116
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1116
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Aruna Sadashiva
            Assignee: justin.du@hp.com
            Priority: Critical
             Fix For: 1.1 (pre-incubation)


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)