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/25 08:02:46 UTC
[jira] [Commented] (TRAFODION-163) LP Bug: 1269184 - Unsupported
querycache() crashes sqcli at CmpInternalSP::startCompileCycle()
[ https://issues.apache.org/jira/browse/TRAFODION-163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14710653#comment-14710653 ]
Atanu Mishra commented on TRAFODION-163:
----------------------------------------
Hans Zeller (hans-zeller) wrote on 2014-02-21: #3
Fix is checked into project/datalake_64_1 rev. 37763.
Changed in trafodion:
status: In Progress → Fix Committed
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-03-04: #4
Verified on the trafodion-ci-project-datalake_64_1-20140303-v38027_release.tar build. This problem has been fixed:
-bash-4.1$ sqlci
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>select * from table (querycache());
*** ERROR[4222] The internal compiler functions feature is not supported in this software version.
*** ERROR[8822] The statement was not prepared.
>>
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1269184 - Unsupported querycache() crashes sqcli at CmpInternalSP::startCompileCycle()
> ----------------------------------------------------------------------------------------------
>
> Key: TRAFODION-163
> URL: https://issues.apache.org/jira/browse/TRAFODION-163
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Weishiun Tsai
> Assignee: Hans Zeller
> Fix For: 0.8 (pre-incubation)
>
>
> Unsupported querycache() causes sqlci to crash and core at CmpInternalSP::startCompileCycle(). It should error out more gracefully.
> -bash-4.1$ sqlci
> Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
> (c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
> >>select * from table (querycache());
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007fffef7a34a7, pid=7272, tid=140737178082880
> #
> # 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 [libarkcmplib.so+0x344a7] CmpInternalSP::startCompileCycle()+0x87
> #
> # Core dump written. Default location: /opt/home/wtsai/beta0108/sql/scripts/core or core.7272
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/beta0108/sql/scripts/hs_err_pid7272.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.
> #
> Here is the stack of the sqlci core:
> (gdb) bt
> #0 0x00000039e28328a5 in raise () from /lib64/libc.so.6
> #1 0x00000039e2834085 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 0x00007fffef7a34a7 in CmpInternalSP::startCompileCycle (
> this=0x7fff999598d8) at ../arkcmp/CmpStoredProc.cpp:846
> #7 0x00007fffef7a35ed in CmpInternalSP::InputFormat (this=0x7fff999598d8,
> num=0, t=...) at ../arkcmp/CmpStoredProc.cpp:936
> #8 0x00007ffff052af7b in RelInternalSP::bindNode (this=0x7fff999733b0,
> bindWA=0x7fffffff3070) at ../optimizer/RelStoredProc.cpp:214
> #9 0x00007ffff00afea7 in RelExpr::bindChildren (this=0x7fff999537a8,
> bindWA=0x7fffffff3070) at ../optimizer/BindRelExpr.cpp:2171
> #10 0x00007ffff00ea526 in RelRoot::bindNode (this=0x7fff999537a8,
> bindWA=0x7fffffff3070) at ../optimizer/BindRelExpr.cpp:5015
> #11 0x00007ffff18dfdfd in CmpMain::compile (this=0x7fffffff5180,
> input_str=0x7fff99965120 "select * from table (querycache());",
> charset=15, queryExpr=@0x7fffffff50b8, gen_code=0x7fff99952618,
> gen_code_len=0x7fff99952610, heap=0x7fffe8784ab8, phase=CmpMain::END,
> fragmentDir=0x7fffffff52d8, op=3004, useQueryCache=<value optimized out>,
> cacheable=0x7fffffff50c8, begTime=0x7fffffff50a0, shouldLog=0)
> at ../sqlcomp/CmpMain.cpp:1743
> #12 0x00007ffff18e287e in CmpMain::sqlcomp (this=0x7fffffff5180,
> input_str=0x7fff99965120 "select * from table (querycache());",
> charset=15, queryExpr=@0x7fffffff50b8, gen_code=0x7fff99952618,
> gen_code_len=0x7fff99952610, heap=0x7fffe8784ab8, phase=CmpMain::END,
> fragmentDir=0x7fffffff52d8, op=3004, useQueryCache=1,
> cacheable=0x7fffffff50c8, begTime=0x7fffffff50a0, shouldLog=0)
> at ../sqlcomp/CmpMain.cpp:1408
> #13 0x00007ffff18e392c in CmpMain::sqlcomp (this=0x7fffffff5180, input=...,
> gen_code=0x7fff99952618, gen_code_len=0x7fff99952610, heap=0x7fffe8784ab8,
> phase=CmpMain::END, fragmentDir=0x7fffffff52d8, op=3004)
> at ../sqlcomp/CmpMain.cpp:745
> #14 0x00007fffef7a035f in CmpStatement::process (this=0x7fffe7bef258,
> sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:472
> #15 0x00007fffef796142 in CmpContext::compileDirect (this=0x7fffe7bef090,
> data=0x7fffe87a4f20 "\200", data_len=168, outHeap=0x7fffe91f7648,
> charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffffff56b0,
> gen_code_len=@0x7fffffff56b8, parserFlags=0, diagsArea=0x7fffe87a4fd0)
> at ../arkcmp/CmpContext.cpp:521
> #16 0x00007ffff6116ab7 in CliStatement::prepare2 (this=0x7fffe87923c0,
> source=0x7fffe8777d58 "select * from table (querycache());",
> 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
> #17 0x00007ffff6116f66 in CliStatement::prepare (this=0x7fffe87923c0,
> source=0x7fffe8777d58 "select * from table (querycache());",
> 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:1374
> #18 0x00007ffff60e30bc in SQLCLI_Prepare2 (cliGlobals=0xbe1ac0,
> statement_id=0x1b8c5a0, sql_source=0x1cdfdb0, gencode_ptr=0x0,
> gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffffff6c10,
> query_comp_stats_info=0x7fffffff5980, uniqueStmtId=<value optimized out>,
> uniqueStmtIdLen=0x7fffffff6cc8, flags=129) at ../cli/Cli.cpp:5940
> #19 0x00007ffff61216fe in SQL_EXEC_Prepare2 (statement_id=0x1b8c5a0,
> sql_source=0x1cdfdb0, gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0,
> query_cost_info=0x7fffffff6c10, comp_stats_info=0x7fffffff5980,
> uniqueStmtId=0x7fffffff6a80 " ", uniqueStmtIdLen=0x7fffffff6cc8,
> flags=129) at ../cli/CliExtern.cpp:4849
> #20 0x00007ffff7bd8b1f in SqlCmd::do_prepare (sqlci_env=0xbe02c0,
> prep_stmt=0x14c8f80,
> sqlStmt=0x1acb390 "select * from table (querycache());",
> resetLastExecStmt=1, rsIndex=-38272, prepcode=0x7fffffff6d9c,
> statisticsType=0x7fffffff6d98) at ../sqlci/SqlCmd.cpp:879
> #21 0x00007ffff7bd7f70 in DML::process (this=0x1ee4d30, sqlci_env=0xbe02c0)
> at ../sqlci/SqlCmd.cpp:2781
> #22 0x00007ffff7bc4e66 in SqlciEnv::executeCommands (this=0xbe02c0,
> input_stmt=@0x7fffffff6ef8) at ../sqlci/SqlciEnv.cpp:837
> #23 0x00007ffff7bc6f0b in SqlciEnv::run (this=0xbe02c0)
> at ../sqlci/SqlciEnv.cpp:646
> #24 0x0000000000401a07 in main (argc=1, argv=0x7fffffff70c8)
> at ../bin/SqlciMain.cpp:310
> (gdb)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)