You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 02:34:46 UTC

[jira] [Closed] (TRAFODION-166) LP Bug: 1270308 - Update statistics crashes tdm_arkcmp when running on a view

     [ https://issues.apache.org/jira/browse/TRAFODION-166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Atanu Mishra closed TRAFODION-166.
----------------------------------
       Resolution: Fixed
         Assignee:     (was: Hans Zeller)
    Fix Version/s: 1.0 (pre-incubation)

> LP Bug: 1270308 - Update statistics crashes tdm_arkcmp when running on a view
> -----------------------------------------------------------------------------
>
>                 Key: TRAFODION-166
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-166
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-general
>            Reporter: Weishiun Tsai
>            Priority: Critical
>             Fix For: 1.0 (pre-incubation)
>
>
> Update statistics crashes tdm_arkcmp when running on a view. It should have just returned an error message gracefully. The following output shows the problem:
> The build is trafodion-ci-release-trafodion_beta-20140115-v36803_release.tar running on a workstation.
> >>create table t (a int);
> --- SQL operation complete.
> >>insert into t values (1),(2),(3);
> --- 3 row(s) inserted.
> >>create view v as select * from t;
> --- SQL operation complete.
> >>update statistics for table v on every column;
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff63190c4, pid=11862, tid=140737182756416
> #
> # JRE version: 7.0_09-b05
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (23.5-b02 mixed mode linux-amd64 compressed oops)
> # Problematic frame:
> # C [libustat.so+0xc70c4] AddKeyGroups()+0x214
> #
> # Core dump written. Default location: /opt/home/wtsai/beta0115/sql/scripts/core or core.11862
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/beta0115/sql/scripts/hs_err_pid11862.log
> #
> # If you would like to submit a bug report, please visit:
> # http://bugreport.sun.com/bugreport/crash.jsp
> # The crash happened outside the Java Virtual Machine in native code.
> # See problematic frame for where to report the bug.
> #
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff63190c4, pid=14760, tid=140737182756416
> #
> # JRE version: 7.0_09-b05
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (23.5-b02 mixed mode linux-amd64 compressed oops)
> # Problematic frame:
> # C [libustat.so+0xc70c4] AddKeyGroups()+0x214
> #
> # Core dump written. Default location: /opt/home/wtsai/beta0115/sql/scripts/core or core.14760
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/beta0115/sql/scripts/hs_err_pid14760.log
> #
> # If you would like to submit a bug report, please visit:
> # http://bugreport.sun.com/bugreport/crash.jsp
> # The crash happened outside the Java Virtual Machine in native code.
> # See problematic frame for where to report the bug.
> #
> *** ERROR[8838] Unable to receive reply from MXCMP, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the builtin stored procedures.
> Here is the stack of the core file:
> (gdb) bt
> #0 0x00000039e28328a5 in raise () from /lib64/libc.so.6
> #1 0x00000039e2834085 in abort () from /lib64/libc.so.6
> #2 0x00007ffff1a46455 in os::abort(bool) ()
>    from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff1ba6717 in VMError::report_and_die() ()
>    from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff1a49f60 in JVM_handle_linux_signal ()
>    from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 entries () at ../common/Collections.h:323
> #7 AddKeyGroups () at ../ustat/hs_parser.cpp:685
> #8 0x00007ffff631b04a in AddEveryColumn (startColumn=0x0,
>     endColumn=<value optimized out>) at ../ustat/hs_parser.cpp:923
> #9 0x00007ffff6282e77 in ystatparse (scanner=0x1a5a960)
>     at ustat/linux/64bit/release/hs_yacc.cpp:2255
> #10 0x00007ffff631598c in HSFuncParseStmt () at ../ustat/hs_parser.cpp:59
> #11 0x00007ffff63265a9 in UpdateStats (input=<value optimized out>,
>     requestedByCompiler=0) at ../ustat/hs_update.cpp:277
> #12 0x00007ffff4677b43 in CmpStatement::process (this=0x7fff9fc844d8,
>     statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:809
> #13 0x00007ffff4669aa3 in ExCmpMessage::actOnReceive (this=0x7fffffffc8d0)
>     at ../arkcmp/CmpConnection.cpp:396
> #14 0x00007ffff7461a76 in IpcMessageStream::internalActOnReceive (
>     this=0x7fffffffc8d0, buffer=<value optimized out>, connection=0xc00bb0)
>     at ../common/Ipc.cpp:3543
> #15 0x00007ffff747882b in GuaConnectionToClient::acceptBuffer (this=0xc00bb0,
>     buffer=<value optimized out>, receivedDataLength=<value optimized out>)
>     at ../common/IpcGuardian.cpp:2400
> #16 0x00007ffff747951f in GuaReceiveControlConnection::wait (this=0xbefe40,
>     timeout=-1, eventConsumed=<value optimized out>,
>     ipcAwaitiox=0x7fffffffc280) at ../common/IpcGuardian.cpp:3090
> #17 0x00007ffff747a902 in GuaConnectionToClient::wait (this=0xc00bb0,
>     timeout=<value optimized out>, eventConsumed=0x0, ipcAwaitiox=0x0)
>     at ../common/IpcGuardian.cpp:2069
> #18 0x00007ffff746c30a in IpcSetOfConnections::waitOnSet (this=0x7fffffffca70,
>     timeout=-1, calledByESP=0, timedout=0x0) at ../common/Ipc.cpp:1698
> #19 0x00007ffff746ce4d in IpcMessageStream::waitOnMsgStream (
>     this=0x7fffffffc8d0, timeout=-1) at ../common/Ipc.cpp:3262
> #20 0x00007ffff746d192 in IpcMessageStream::receive (this=0x7fffffffc8d0,
>     waited=1) at ../common/Ipc.cpp:3244
> #21 0x0000000000405c1a in main (argc=2, argv=0x7fffffffd048)
>     at ../bin/arkcmp.cpp:334



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