[
https://issues.apache.org/jira/browse/TRAFODION-276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-276.
----------------------------------
Resolution: Fixed
Assignee: (was: Suresh Subbiah)
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1320385 - update of hive table generates sqlci core
> -----------------------------------------------------------
>
> Key: TRAFODION-276
> URL: https://issues.apache.org/jira/browse/TRAFODION-276
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Julie Thai
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> update stmt on hive table generated sqlci core on workstation, datalake_64_1
> v40596.
> Also tried to prepare-update stmt and sqlci core generated too.
> MY_SQROOT=/opt/home/thaiju/datalake_64_1
> who@host=tha...@g4t3029.houston.hp.com
> JAVA_HOME=/opt/home/tools/jdk1.7.0_09_64
> linux=2.6.32-279.el6.x86_64
> redhat=6.3
> Release 0.7.0 (Build release [40596], branch 40596-project/datalake_64_1,
> date 16May14)
> From sqlci:
> Trafodion Conversational Interface 0.7.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>obey traf.sql;
> >>select count(*) from hive.hive.nation;
> (EXPR)
> --------------------
> 25
> --- 1 row(s) selected.
> >>
> >>insert into hive.hive.nation values (999, 'nines name', 8888, 'eights
> >>comment');
> --- 1 row(s) inserted.
> >>
> >>select count(*) from hive.hive.nation;
> (EXPR)
> --------------------
> 25
> --- 1 row(s) selected.
> >>
> >>select n_nationkey from hive.hive.nation order by n_nationkey asc;
> N_NATIONKEY
> -----------
> 0
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> 11
> 12
> 13
> 14
> 15
> 16
> 17
> 18
> 19
> 20
> 21
> 22
> 23
> 24
> 999
> --- 26 row(s) selected.
> >>
> >>update hive.hive.nation set n_regionkey = 7777 where n_nationkey = 999;
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007fffefbf5210, pid=2352, tid=140737180482304
> #
> # 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 [liboptimizer.so+0x394210] GenericUpdate::bindUpdateExpr(BindWA*,
> ItemExpr*, ItemExprList&, RelExpr*, Scan*, NASet<short>&, int)+0x120
> #
> # Core dump written. Default location: /opt/home/thaiju/hive_upd/core or
> core.2352
> #
> # An error report file with more information is saved as:
> # /opt/home/thaiju/hive_upd/hs_err_pid2352.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)
> Callstack from core.g4t3029.houston.hp.com.2352.sqlci:
> Core was generated by `sqlci'.
> Program terminated with signal 6, Aborted.
> #0 0x00000033088328a5 in raise () from /lib64/libc.so.6
> Missing separate debuginfos, use: debuginfo-install
> boost-filesystem-1.41.0-11.el6_1.2.x86_64
> boost-program-options-1.41.0-11.el6_1.2.x86_64
> boost-system-1.41.0-11.el6_1.2.x86_64 cyrus-sasl-lib-2.1.23-13.el6.x86_64
> glibc-2.12-1.107.el6.x86_64 keyutils-libs-1.4-4.el6.x86_64
> krb5-libs-1.9-33.el6.x86_64 libcom_err-1.41.12-12.el6.x86_64
> libgcc-4.4.6-4.el6.x86_64 libselinux-2.0.94-5.3.el6.x86_64
> libstdc++-4.4.6-4.el6.x86_64 libuuid-2.17.2-12.7.el6.x86_64
> nss-softokn-freebl-3.12.9-11.el6.x86_64 openssl-1.0.0-20.el6_2.5.x86_64
> protobuf-2.3.0-7.el6.x86_64 qpid-cpp-client-0.14-16.el6.x86_64
> zlib-1.2.3-27.el6.x86_64
> (gdb) where
> #0 0x00000033088328a5 in raise () from /lib64/libc.so.6
> #1 0x0000003308834085 in abort () from /lib64/libc.so.6
> #2 0x00007ffff6d46455 in os::abort(bool) ()
> from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff6ea6717 in VMError::report_and_die() ()
> from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff6d49f60 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 0x00007fffefbf5210 in getColumnListCount (this=0x7fffd493bb80, bindWA=
> 0x7fffffff14c0, recExpr=0x7fffd493a658, assignList=..., boundView=0x0,
> scanNode=
> 0x7fffd493b108, stoiColumnSet=..., onRollback=0)
> at ../optimizer/BindRelExpr.cpp:10489
> #7 GenericUpdate::bindUpdateExpr (this=0x7fffd493bb80, bindWA=0x7fffffff14c0,
> recExpr=0x7fffd493a658, assignList=..., boundView=0x0,
> scanNode=0x7fffd493b108,
> stoiColumnSet=..., onRollback=0) at ../optimizer/BindRelExpr.cpp:10489
> #8 0x00007fffefc0a2a7 in GenericUpdate::bindNode (this=0xfffffffffffffd28,
> bindWA=0x7fffffff14c0) at ../optimizer/BindRelExpr.cpp:11705
> #9 0x00007fffefc0c0eb in Update::bindNode (this=0x7fffd493bb80,
> bindWA=0x7fffffff14c0) at ../optimizer/BindRelExpr.cpp:9805
> #10 0x00007fffefbe9d87 in RelExpr::bindChildren (this=0x7fffd493ec68,
> bindWA=0x7fffffff14c0) at ../optimizer/BindRelExpr.cpp:2166
> #11 0x00007fffefc2040e in RelRoot::bindNode (this=0x7fffd493ec68,
> bindWA=0x7fffffff14c0) at ../optimizer/BindRelExpr.cpp:5003
> #12 0x00007ffff14563d4 in CmpMain::compile (this=0x7fffffff3770,
> input_str=0x7fffd4938910 "update hive.hive.nation set n_regionkey = 7777
> where n_
> nationkey = 999;", charset=15, queryExpr=@0x7fffffff36a8,
> gen_code=0x7fffd4942958,
> gen_code_len=0x7fffd4942950, heap=0x7fffe8fe0aa0, phase=CmpMain::END,
> fragmentDir=0x7fffffff38c8, op=3004, useQueryCache=<value optimized out>,
> cacheable=0x7fffffff36b8, begTime=0x7fffffff3690, shouldLog=0)
> at ../sqlcomp/CmpMain.cpp:1783
> #13 0x00007ffff145897e in CmpMain::sqlcomp (this=0x7fffffff3770,
> input_str=0x7fffd4938910 "update hive.hive.nation set n_regionkey = 7777
> where n_nationkey = 999;", charset=15, queryExpr=@0x7fffffff36a8,
> gen_code=0x7fffd4942958,
> gen_code_len=0x7fffd4942950, heap=0x7fffe8fe0aa0, phase=CmpMain::END,
> fragmentDir=0x7fffffff38c8, op=3004, useQueryCache=1,
> cacheable=0x7fffffff36b8,
> begTime=0x7fffffff3690, shouldLog=0) at ../sqlcomp/CmpMain.cpp:1450
> #14 0x00007ffff1459b94 in CmpMain::sqlcomp (this=0x7fffffff3770, input=...,
> gen_code=0x7fffd4942958, gen_code_len=0x7fffd4942950, heap=0x7fffe8fe0aa0,
> phase=CmpMain::END, fragmentDir=0x7fffffff38c8, op=3004)
> at ../sqlcomp/CmpMain.cpp:785
> #15 0x00007ffff5361daf in CmpStatement::process (this=0x7fffd4918438,
> sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:476
> #16 0x00007ffff5356a4e in CmpContext::compileDirect (this=0x7fffe844b090,
> data=0x7fffe9002770 "\200", data_len=200, outHeap=0x7fffe9a52660,
> charset=15,
> op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffffff3e90,
> gen_code_len=@0x7fffffff3e98, parserFlags=0, diagsArea=0x7fffe9002840)
> at ../arkcmp/CmpContext.cpp:658
> #17 0x00007ffff6114487 in CliStatement::prepare2 (this=0x7fffe8fefb58,
> source=0x7fffe9008af0 "update hive.hive.nation set n_regionkey = 7777
> where n_nationkey = 999;", diagsArea=..., passed_gen_code=<value optimized
> out>,
> passed_gen_code_len=<value optimized out>, charset=15, unpackTdbs=1,
> cliFlags=129) at ../cli/Statement.cpp:1783
> #18 0x00007ffff6114936 in CliStatement::prepare (this=0x7fffe8fefb58,
> source=0x7fffe9008af0 "update hive.hive.nation set n_regionkey = 7777
> where n_nationkey = 999;", diagsArea=..., passed_gen_code=<value optimized
> out>,
> passed_gen_code_len=<value optimized out>, charset=<value optimized out>,
> unpackTdbs=1, cliFlags=129) at ../cli/Statement.cpp:1373
> #19 0x00007ffff60df21c in SQLCLI_Prepare2 (cliGlobals=0xba0ef0,
> statement_id=0x4290130, sql_source=0x1b9ba40, gencode_ptr=0x0,
> gencode_len=0,
> ret_gencode_len=0x0, query_cost_info=0x7fffffff53f0,
> query_comp_stats_info=0x7fffffff4160, uniqueStmtId=<value optimized out>,
> uniqueStmtIdLen=0x7fffffff54a8, flags=129) at ../cli/Cli.cpp:5955
> #20 0x00007ffff611f757 in SQL_EXEC_Prepare2 (statement_id=0x4290130,
> sql_source=0x1b9ba40, gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0,
> query_cost_info=0x7fffffff53f0, comp_stats_info=0x7fffffff4160,
> uniqueStmtId=0x7fffffff5260 " ", uniqueStmtIdLen=0x7fffffff54a8,
> flags=129)
> at ../cli/CliExtern.cpp:4901
> #21 0x00007ffff7bd893f in SqlCmd::do_prepare (sqlci_env=0xb9f710,
> prep_stmt=0x29e5d30,
> sqlStmt=0x29e4db0 "update hive.hive.nation set n_regionkey = 7777 where
> n_nationkey = 999;", resetLastExecStmt=1, rsIndex=-44448,
> prepcode=0x7fffffff557c,
> statisticsType=0x7fffffff5578) at ../sqlci/SqlCmd.cpp:879
> #22 0x00007ffff7bd7d90 in DML::process (this=0x426c0c0, sqlci_env=0xb9f710)
> at ../sqlci/SqlCmd.cpp:2781
> #23 0x00007ffff7bbe8c4 in Obey::process (this=0x280bbf0,
> sqlci_env=<value optimized out>) at ../sqlci/Obey.cpp:252
> #24 0x00007ffff7bc4c76 in SqlciEnv::executeCommands (this=0xb9f710,
> input_stmt=@0x7fffffff5768) at ../sqlci/SqlciEnv.cpp:835
> #25 0x00007ffff7bc6d1b in SqlciEnv::run (this=0xb9f710) at
> ../sqlci/SqlciEnv.cpp:644
> #26 0x0000000000401af1 in main (argc=1, argv=0x7fffffff5938)
> at ../bin/SqlciMain.cpp:307
> To reproduce, see attachment, hive_upd.tar.
> 1. in hive, create and load table nation, see hive_setup and nation.tbl files
> 2. in sqlci, obey traf.sql to reproduce.
> core.g4t3029.houston.hp.com.2352.sqlci can be found under
> /designs/seaquest/thaiju/hive_upd.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
