You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:46 UTC

[jira] [Created] (TRAFODION-358) LP Bug: 1327465 - purgedata on a view crashes sqlci at NACollection::entries

Alice Chen created TRAFODION-358:
------------------------------------

             Summary: LP Bug: 1327465 - purgedata on a view crashes sqlci at NACollection<NAColumn*>::entries
                 Key: TRAFODION-358
                 URL: https://issues.apache.org/jira/browse/TRAFODION-358
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma


Running purgedata on a view crashes sqlci with a core file at NACollection<NAColumn*>::entries.  Purgedata on a view is not supported, but it should error out more gracefully than crashing sqlci.

This is seen on the GIT build v0606_0930 build.

-----------------------------------------

Here is the entire script to reproduce this problem:

create table t (a int);
create view v (a) as select a from t;
purgedata v;

-----------------------------------------

Here is the execution output:

-bash-4.1$ sqlci
Trafodion Conversational Interface 0.8.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>create table t (a int);

--- SQL operation complete.
>>create view v (a) as select a from t;

--- SQL operation complete.
>>purgedata v;
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00007ffff12dc634, pid=1301, tid=140737171865184
#
# 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  [libsqlcomp.so+0xba634]  NACollection<NAColumn*>::entries() const+0xc
#
# Core dump written. Default location: core.1301
#
# An error report file with more information is saved as:
# hs_err_pid1301.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.
#
Aborted (core dumped)

-----------------------------------------

Here is the stack trace 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  0x00007ffff6ec7455 in os::abort(bool) ()
   from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#3  0x00007ffff7027717 in VMError::report_and_die() ()
   from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#4  0x00007ffff6ecaf60 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  0x00007ffff12dc634 in NACollection<NAColumn*>::entries (this=0x260)
    at ../common/Collections.h:335
#7  0x00007ffff12fa631 in CmpSeabaseDDL::purgedataHbaseTable (
    this=0x7fffffff25f0, ddlExpr=0x7fffd81c0e70, currCatName=...,
    currSchName=...) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:3860
#8  0x00007ffff12fb83e in CmpSeabaseDDL::executeSeabaseDDL (
    this=0x7fffffff25f0, ddlExpr=0x7fffd81c0e70, ddlNode=0x0, currCatName=...,
    currSchName=...) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:4125
#9  0x00007ffff581dce4 in CmpStatement::process (this=0x7fffd81b1ad0,
    statement=...) at ../arkcmp/CmpStatement.cpp:909
#10 0x00007ffff581152f in CmpContext::compileDirect (this=0x7fffe7beb090,
    data=0x7fffe878f7e8 "\200", data_len=168, outHeap=0x7fffe91f1660,
    charset=0, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffffff2e18,
    gen_code_len=@0x7fffffff2e14, parserFlags=0, diagsArea=0x7fffe878f898)
    at ../arkcmp/CmpContext.cpp:710
#11 0x00007ffff4fb0036 in ExDDLTcb::work (this=0x7fffe8783198)
    at ../executor/ex_ddl.cpp:265
#12 0x00007ffff4fc39b3 in ex_tcb::sWork (tcb=0x7fffe8783198)
    at ../executor/ex_tcb.h:99
#13 0x00007ffff50c521b in ExSubtask::work (this=0x7fffe87836f0)
    at ../executor/ExScheduler.cpp:751
#14 0x00007ffff50c45de in ExScheduler::work (this=0x7fffe8782d00,
    prevWaitTime=0) at ../executor/ExScheduler.cpp:328
#15 0x00007ffff50036e7 in ex_root_tcb::execute (this=0x7fffe8783770,
    cliGlobals=0xba2330, glob=0x7fffe878e5f8, input_desc=0x7fffe87ae730,
    diagsArea=@0x7fffffff4450, reExecute=0) at ../executor/ex_root.cpp:1025
#16 0x00007ffff625b11b in CliStatement::execute (this=0x7fffe879f6d0,
    cliGlobals=0xba2330, input_desc=0x7fffe87ae730, diagsArea=...,
    execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0, cliflags=0)
    at ../cli/Statement.cpp:4754
#17 0x00007ffff6200fd3 in SQLCLI_PerformTasks(CliGlobals *, ULng32, SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0xba2330, tasks=4882,
    statement_id=0x184b540, input_descriptor=0x23c5240, output_descriptor=0x0,
    num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff4a20,
    input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3323
#18 0x00007ffff6201944 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
    cliGlobals=0xba2330, statement_id=0x184b540, input_descriptor=0x23c5240,
    num_ptr_pairs=0, ap=0x7fffffff4a20, ptr_pairs=0x0) at ../cli/Cli.cpp:3570
#19 0x00007ffff626e1ca in SQL_EXEC_Exec (statement_id=0x184b540,
    input_descriptor=0x23c5240, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2062
#20 0x00007ffff7bbc43c in SqlCmd::doExec (sqlci_env=0xba0b30, stmt=0x184b540,
    prep_stmt=0x27e7610, numUnnamedParams=0, unnamedParamArray=0x0,
    unnamedParamCharSetArray=0x0, handleError=1) at ../sqlci/SqlCmd.cpp:1705
#21 0x00007ffff7bbd1fa in SqlCmd::do_execute (sqlci_env=0xba0b30,
    prep_stmt=0x27e7610, numUnnamedParams=0, unnamedParamArray=0x0,
    unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2036
#22 0x00007ffff7bbf487 in DML::process (this=0x1aa3fa0, sqlci_env=0xba0b30)
    at ../sqlci/SqlCmd.cpp:2807
#23 0x00007ffff7ba9996 in SqlciEnv::executeCommands (this=0xba0b30,
    input_stmt=@0x7fffffff6448) at ../sqlci/SqlciEnv.cpp:847
#24 0x00007ffff7ba90d7 in SqlciEnv::run (this=0xba0b30)
    at ../sqlci/SqlciEnv.cpp:656
#25 0x0000000000401f49 in main (argc=1, argv=0x7fffffff6608)
    at ../bin/SqlciMain.cpp:317



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