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:19:06 UTC
[jira] [Created] (TRAFODION-927) LP Bug: 1413404 - "_REPOS_"
becomes unusable after upgrade
Alice Chen created TRAFODION-927:
------------------------------------
Summary: 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)