You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:36:54 UTC
[jira] [Closed] (TRAFODION-731) LP Bug: 1388207 - bulkload into
volatile table cores
[ https://issues.apache.org/jira/browse/TRAFODION-731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-731.
------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> LP Bug: 1388207 - bulkload into volatile table cores
> ----------------------------------------------------
>
> Key: TRAFODION-731
> URL: https://issues.apache.org/jira/browse/TRAFODION-731
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Julie Thai
> Assignee: Barry Fritchman
>
> Bulkload into volatile table cores. Expected error.
> >>create volatile table voltbl_partsupp primary key (ps_partkey, ps_suppkey) no load as select * from g_tpch2x.partsupp;
> --- 0 row(s) inserted.
> >>cqd comp_bool_226 'on';
> --- SQL operation complete.
> >>cqd TRAF_LOAD_PREP_TMP_LOCATION '/bulkload/';
> --- SQL operation complete.
> >>cqd TRAF_LOAD_TAKE_SNAPSHOT 'OFF';
> --- SQL operation complete.
> >>load into voltbl_partsupp select * from g_tpch2x.partsupp;
> Task: LOAD Status: Started Object: TRAFODION.SEABASE.VOLTBL_PARTSUPP
> Task: CLEANUP Status: Started Object: TRAFODION.SEABASE.VOLTBL_PARTSUPP
> Task: CLEANUP Status: Ended Object: TRAFODION.SEABASE.VOLTBL_PARTSUPP
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007fd63a3b8186, pid=11373, tid=140558030157728
> #
> # JRE version: Java(TM) SE Runtime Environment (7.0_67-b01) (build 1.7.0_67-b01)
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (24.65-b04 mixed mode linux-amd64 compressed oops)
> # Problematic frame:
> # C [libustat.so+0xbb186] HSTableDef::setNATable()+0x186
> #
> # Core dump written. Default location: /home/trafodion/thaiju/loadhive/core or core.11373
> #
> # An error report file with more information is saved as:
> # /home/trafodion/thaiju/loadhive/hs_err_pid11373.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
> Stack trace:
> Stack: [0x00007fff22db2000,0x00007fff22eb2000], sp=0x00007fff22e9bc70, free space=935k
> Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code)
> C [libustat.so+0xbb186] HSTableDef::setNATable()+0x186
> C [libustat.so+0xc006c] HSHbaseTableDef::objExists(HSTableDef::labelDetail)+0x1c
> C [libustat.so+0xd3f12] FetchHistograms(QualifiedName const&, ExtendedQualName::SpecialTableType, NAColumnArray const&, StatsList&, int, NAMemory*, long&, long&, int&, int, long)+0xe52
> C [liboptimizer.so+0x621684] HistogramCache::createColStatsList(NATable&, HistogramsCacheEntry*)+0x304
> C [liboptimizer.so+0x621a95] HistogramCache::getHistograms(NATable&)+0x75
> C [liboptimizer.so+0x621f8e] NATable::getStatistics()+0x19e
> C [liboptimizer.so+0x8c227e] TableDesc::getTableColStats()+0xce
> C [liboptimizer.so+0x6d72e9] GenericUpdate::synthLogProp(NormWA*)+0x59
> C [liboptimizer.so+0x8ddcad] TSJFlowRule::nextSubstitute(RelExpr*, Context*, RuleSubstituteMemory*&)+0x3ed
> C [liboptimizer.so+0x8cd097] ApplyRuleTask::perform(int)+0x247
> C [liboptimizer.so+0x6a41d5] QueryOptimizerDriver::optimizeAPassHelper(Context*)+0x235
> C [liboptimizer.so+0x6a45c5] QueryOptimizerDriver::optimizeAPass(Context*)+0xf5
> C [liboptimizer.so+0x6a4b47] QueryOptimizerDriver::doPass2PerhapsPass1(RelExpr*, Context*, RelExpr*)+0x57
> C [liboptimizer.so+0x6a4d23] RelExpr::optimize2()+0xc3
> C [liboptimizer.so+0x6d5fd8] RelExpr::optimizeNode()+0x98
> C [libsqlcomp.so+0x80e00] CmpMain::compile(char const*, int, RelExpr*&, char**, unsigned int*, NAMemory*, CmpMain::CompilerPhase, FragmentDir**, int, int, int*, timeval*, int)+0x1670
> C [libsqlcomp.so+0x826cc] CmpMain::sqlcomp(char const*, int, RelExpr*&, char**, unsigned int*, NAMemory*, CmpMain::CompilerPhase, FragmentDir**, int, int, int*, timeval*, int)+0xbc
> C [libsqlcomp.so+0x838bc] CmpMain::sqlcomp(QueryText&, int, char**, unsigned int*, NAMemory*, CmpMain::CompilerPhase, FragmentDir**, int)+0x63c
> C [libarkcmplib.so+0x348d8] CmpStatement::process(CmpMessageSQLText const&)+0x298
> C [libarkcmplib.so+0x292de] CmpContext::compileDirect(char*, unsigned int, NAMemory*, int, CmpMessageObj::MessageTypeEnum, char*&, unsigned int&, unsigned int, ComDiagsArea*)+0x7de
> C [libcli.so+0x76a67] CliStatement::prepare2(char*, ComDiagsArea&, char*, unsigned int, int, int, unsigned int)+0xbf7
> C [libcli.so+0x76eb6] CliStatement::prepare(char*, ComDiagsArea&, char*, unsigned int, int, int, unsigned int)+0x96
> C [libcli.so+0x418cc] SQLCLI_Prepare2+0x6bc
> C [libcli.so+0x81cf7] SQL_EXEC_Prepare2+0xc7
> C [libexecutor.so+0x17c85b] ExeCliInterface::prepare(char const*, SQLMODULE_ID_t*, SQLCLI_OBJ_ID*, SQLCLI_OBJ_ID*, SQLCLI_OBJ_ID*, SQLCLI_OBJ_ID*, char**, Queue*, char**, Queue*, char*, int*, SQL_QUERY_COST_INFO*, SQL_QUERY_COMPILER_STATS_INFO*, int)+0x1ab
> C [libexecutor.so+0x17e6d3] ExeCliInterface::executeImmediatePrepare(char const*, char*, int*, long*, int, char*)+0x113
> C [libexecutor.so+0x182bde] ExeCliInterface::executeImmediate(char const*, char*, int*, int, long*, int, ComDiagsArea*)+0xde
> C [libexecutor.so+0x18d27e] ExExeUtilHBaseBulkLoadTcb::work()+0xb3e
> C [libexecutor.so+0x1cbeb3] ExScheduler::work(long)+0x223
> C [libexecutor.so+0x13d1f6] ex_root_tcb::fetch(CliGlobals*, ExExeStmtGlobals*, Descriptor*, ComDiagsArea*&, int, int, int&)+0x416
> C [libcli.so+0x797c8] CliStatement::fetch(CliGlobals*, Descriptor*, ComDiagsArea&, int)+0x2f8
> C [libcli.so+0x3bd5f] SQLCLI_PerformTasks+0x4ff
> C [libcli.so+0x3c77d] SQLCLI_Fetch+0x4d
> C [libcli.so+0x833f7] SQL_EXEC_Fetch+0x117
> C [libsqlcilib.so+0x483a2] SqlCmd::doFetch(SqlciEnv*, SQLCLI_OBJ_ID*, PrepStmt*, int, int, int)+0xc2
> C [libsqlcilib.so+0x4cbbd] SqlCmd::do_execute(SqlciEnv*, PrepStmt*, int, char**, CharInfo::CharSet*, int)+0x7cd
> C [libsqlcilib.so+0x4d4ad] DML::process(SqlciEnv*)+0x40d
> C [libsqlcilib.so+0x39fe6] SqlciEnv::executeCommands(InputStmt*&)+0x4b6
> C [libsqlcilib.so+0x3c08b] SqlciEnv::run()+0x3b
> C [sqlci+0x1ab1]
> To reproduce:
> create volatile table voltbl_partsupp primary key (ps_partkey, ps_suppkey) no load as select * from g_tpch2x.partsupp;
> showddl voltbl_partsupp;
> cqd comp_bool_226 'on';
> cqd TRAF_LOAD_PREP_TMP_LOCATION '/bulkload/';
> cqd TRAF_LOAD_TAKE_SNAPSHOT 'OFF';
> load into voltbl_partsupp select * from g_tpch2x.partsupp;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)