Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1116

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1 (pre-incubation)
    • Component/s: sql-exe
    • Labels:
      None

      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

        Attachments

          Activity

            People

            • Assignee:
              JustinDu justin.du@hp.com
              Reporter:
              saruna Aruna Sadashiva
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: