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

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

Alice Chen created TRAFODION-166:
------------------------------------

             Summary: 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
            Assignee: Hans Zeller
            Priority: Critical


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)