[
https://issues.apache.org/jira/browse/TRAFODION-927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah resolved TRAFODION-927.
--------------------------------------
Resolution: Fixed
> LP Bug: 1413404 - "_REPOS_" becomes unusable after upgrade
> ----------------------------------------------------------
>
> Key: TRAFODION-927
> URL: https://issues.apache.org/jira/browse/TRAFODION-927
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Anoop Sharma
> Priority: Blocker
> Fix For: 1.0 (pre-incubation)
>
>
> After upgrading from 0.9.0 v2 to the v0121 build using 'initialize trafodion,
> upgrade", Any attempt to access “_REPO_”.METRIC_QUERY_AGGR_TABLE and
> “_REPO_”.METRIC_SESSION_TABLE cores sqlci. Since the new build is installed
> with dcs.server.user.program.statistics.enabled set to true, mxosrvr starts
> to core at connection as well.
> Here are the execution output of a select statement to
> "_MD_".METRIC_QUERY_AGGR_TABLE and the stack trace for the sqlci core:
> >>get schemas;
> Schemas in Catalog TRAFODION
> ============================
> G_ARKCASEDB
> G_CMUREG
> G_HCUBEDB
> G_HPIT
> G_SQLDOPT
> G_SQLDPOP
> G_TPCDS1X
> G_TPCH2X
> G_WISC32
> MYSCHEMA
> SEABASE
> _MD_
> _REPOS_
> --- SQL operation complete.
> >>set schema "_REPOS_";
> --- SQL operation complete.
> >>get tables;
> Tables in Schema TRAFODION._REPOS_
> ==================================
> METRIC_QUERY_AGGR_TABLE
> METRIC_QUERY_TABLE
> METRIC_SESSION_TABLE
> --- SQL operation complete.
> >>select count(*) from METRIC_QUERY_AGGR_TABLE;
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007fffee7dc8d0, pid=19884, tid=140737353873440
> #
> # 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 [liboptimizer.so+0x5308d0] void
> ItemExpr::findAllT<ItemExprList>(OperatorTypeEnum, ItemExprList&, int,
> int)+0x20
> #
> # Core dump written. Default location:
> /opt/home/trafodion/v0121/dcs-1.0.0/conf/core or core.19884
> #
> # An error report file with more information is saved as:
> # /opt/home/trafodion/v0121/dcs-1.0.0/conf/hs_err_pid19884.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)
> (gdb) bt
> #0 0x00007ffff57108a5 in raise () from /lib64/libc.so.6
> #1 0x00007ffff571200d in abort () from /lib64/libc.so.6
> #2 0x00007ffff6f04a55 in os::abort(bool) ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff7084f87 in VMError::report_and_die() ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff6f0996f in JVM_handle_linux_signal ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 operator OperatorTypeEnum (this=0x0, wantedType=ITM_REFERENCE, result=...,
> visitVEGMembers=0, visitIndexColDefs=0) at ../common/ExprNode.h:82
> #7 getOperatorType (this=0x0, wantedType=ITM_REFERENCE, result=...,
> visitVEGMembers=0, visitIndexColDefs=0) at ../common/ExprNode.h:142
> #8 ItemExpr::findAllT<ItemExprList> (this=0x0, wantedType=ITM_REFERENCE,
> result=..., visitVEGMembers=0, visitIndexColDefs=0)
> at ../optimizer/ItemExpr.cpp:1400
> #9 0x00007fffee8d8ef4 in createNAFileSets (table_desc=0x1b8efe0,
> table=0x7fffd512e728, colArray=..., indexes=..., vertParts=...,
> clusteringIndex=@0x7fffd512ea58, tableIdList=..., heap=0x7fffd5156360,
> bindWA=0x7fffffff2020, maxIndexLevelsPtr=0x7fffd51032b0)
> at ../optimizer/NATable.cpp:3880
> #10 0x00007fffee8de8e8 in NATable::NATable (this=0x7fffd512e728,
> bindWA=0x7fffffff2020, corrName=..., heap=<value optimized out>,
> inTableDesc=<value optimized out>) at ../optimizer/NATable.cpp:5183
> #11 0x00007fffee8e1755 in NATableDB::get (this=0x7fffe5eb0928, corrName=...,
> bindWA=0x7fffffff2020, inTableDescStruct=<value optimized out>)
> at ../optimizer/NATable.cpp:8018
> #12 0x00007fffee63fcca in BindWA::getNATable (this=0x7fffffff2020,
> corrName=...,
> catmanCollectTableUsages=1, inTableDescStruct=0x0)
> at ../optimizer/BindRelExpr.cpp:1445
> #13 0x00007fffee66bfa6 in RelRoot::bindNode (this=0x7fffd5112f60,
> bindWA=0x7fffffff2020) at ../optimizer/BindRelExpr.cpp:4781
> #14 0x00007fffeff3585e in CmpMain::compile (this=0x7fffffff4ad0,
> input_str=0x7fffd5154f00 "select count(*) from metric_query_aggr_table;",
> charset=15, queryExpr=@0x7fffffff4a08, gen_code=0x7fffd5155258,
> gen_code_len=0x7fffd5155250, heap=0x7fffe6a42c08, phase=CmpMain::END,
> fragmentDir=0x7fffffff4c28, op=3004, useQueryCache=1,
> cacheable=0x7fffffff4a18, begTime=0x7fffffff49f0, shouldLog=0)
> at ../sqlcomp/CmpMain.cpp:2119
> #15 0x00007fffeff3866c in CmpMain::sqlcomp (this=0x7fffffff4ad0,
> input_str=0x7fffd5154f00 "select count(*) from metric_query_aggr_table;",
> charset=15, queryExpr=@0x7fffffff4a08, gen_code=0x7fffd5155258,
> gen_code_len=0x7fffd5155250, heap=0x7fffe6a42c08, phase=CmpMain::END,
> fragmentDir=0x7fffffff4c28, op=3004, useQueryCache=1,
> cacheable=0x7fffffff4a18, begTime=0x7fffffff49f0, shouldLog=0)
> at ../sqlcomp/CmpMain.cpp:1732
> #16 0x00007fffeff39970 in CmpMain::sqlcomp (this=0x7fffffff4ad0, input=...,
> gen_code=0x7fffd5155258, gen_code_len=0x7fffd5155250, heap=0x7fffe6a42c08,
> phase=CmpMain::END, fragmentDir=0x7fffffff4c28, op=3004)
> at ../sqlcomp/CmpMain.cpp:817
> #17 0x00007ffff4abd198 in CmpStatement::process (this=0x7fffd50f8808,
> sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:508
> #18 0x00007ffff4ab0623 in CmpContext::compileDirect (this=0x7fffe5eab090,
> data=0x7fffe6a8d468 "\200", data_len=176, outHeap=0x7ffff7ee1128,
> charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffffff51b0,
> gen_code_len=@0x7fffffff51b8, parserFlags=0, diagsArea=0x7fffe6a8d520)
> at ../arkcmp/CmpContext.cpp:686
> #19 0x00007ffff549acf7 in CliStatement::prepare2 (this=0x7fffe6a85748,
> source=0x7fffe6a8f960 "select count(*) from metric_query_aggr_table;",
> diagsArea=..., passed_gen_code=<value optimized out>,
> passed_gen_code_len=4159574312, charset=15, unpackTdbs=1, cliFlags=129)
> at ../cli/Statement.cpp:1827
> #20 0x00007ffff549b146 in CliStatement::prepare (this=0x7fffe6a85748,
> source=0x7fffe6a8f960 "select count(*) from metric_query_aggr_table;",
> 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:1420
> #21 0x00007ffff544a574 in SQLCLI_Prepare2 (cliGlobals=0xb7dfb0,
> statement_id=0x19367e0, sql_source=0x1513d30, gencode_ptr=0x0,
> gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffffff6710,
> query_comp_stats_info=0x7fffffff5480, uniqueStmtId=<value optimized out>,
> uniqueStmtIdLen=0x7fffffff67c8, flags=129) at ../cli/Cli.cpp:5914
> #22 0x00007ffff54a8b00 in SQL_EXEC_Prepare2 (statement_id=0x19367e0,
> sql_source=0x1513d30, gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0,
> query_cost_info=0x7fffffff6710, comp_stats_info=0x7fffffff5480,
> uniqueStmtId=0x7fffffff6580 " ", uniqueStmtIdLen=0x7fffffff67c8,
> flags=129) at ../cli/CliExtern.cpp:4985
> #23 0x00007ffff77afdff in SqlCmd::do_prepare (sqlci_env=0xb7cd60,
> prep_stmt=0x1fffa90,
> sqlStmt=0x1ff2540 "select count(*) from metric_query_aggr_table;",
> resetLastExecStmt=1, rsIndex=-39552, prepcode=0x7fffffff689c,
> statisticsType=0x7fffffff6898) at ../sqlci/SqlCmd.cpp:893
> #24 0x00007ffff77af200 in DML::process (this=0x1513920, sqlci_env=0xb7cd60)
> at ../sqlci/SqlCmd.cpp:2803
> #25 0x00007ffff779bff6 in SqlciEnv::executeCommands (this=0xb7cd60,
> input_stmt=@0x7fffffff69f8) at ../sqlci/SqlciEnv.cpp:847
> #26 0x00007ffff779e09b in SqlciEnv::run (this=0xb7cd60)
> at ../sqlci/SqlciEnv.cpp:656
> #27 0x0000000000401ad9 in main (argc=1, argv=0x7fffffff6bc8)
> at ../bin/SqlciMain.cpp:328
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
