trafodion-development team mailing list archive
-
trafodion-development team
-
Mailing list archive
-
Message #00109
update statistics error on simple test table
Hi,
Using Trafodion Sandbox 1.1 with VirtualBox after adding some data in a
test table I get this error while updating statistics. This is the scenario:
*[trafodion@n001 ~]$ sqlci*
*Trafodion Conversational Interface 1.1.0*
*(c) Copyright 2015 Hewlett-Packard Development Company, LP.*
*>>create table test1 (f1 int, f2 int);*
*--- SQL operation complete.*
*>>insert into test1 values(1,1);*
*--- 1 row(s) inserted.*
*>>insert into test1 values(2,2);*
*--- 1 row(s) inserted.*
*>>select * from test1;*
*F1 F2*
*----------- -----------*
* 1 1*
* 2 2*
*>>update statistics for table TRAFODION.SEABASE.TEST1 on every column;*
*#*
*# A fatal error has been detected by the Java Runtime Environment:*
*#*
*# SIGILL (0x4) at pc=0x00007fb4dfbd9be7, pid=19296, tid=140414902713376*
*#*
*# JRE version: Java(TM) SE Runtime Environment (7.0_79-b15) (build
1.7.0_79-b15)*
*# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.79-b02 mixed mode
linux-amd64 compressed oops)*
*# Problematic frame:*
*# C 0x00007fb4dfbd9be7*
*#*
*# Core dump written. Default location: /home/trafodion/core or core.19296*
*#*
*# An error report file with more information is saved as:*
*# /home/trafodion/hs_err_pid19296.log*
*#*
*# If you would like to submit a bug report, please visit:*
*# http://bugreport.java.com/bugreport/crash.jsp
<http://bugreport.java.com/bugreport/crash.jsp>*
*# The crash happened outside the Java Virtual Machine in native code.*
*# See problematic frame for where to report the bug.*
*#*
*#*
*# A fatal error has been detected by the Java Runtime Environment:*
*#*
*# SIGILL (0x4) at pc=0x00007f6378ffc05f, pid=21310, tid=140065297075232*
*#*
*# JRE version: Java(TM) SE Runtime Environment (7.0_79-b15) (build
1.7.0_79-b15)*
*# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.79-b02 mixed mode
linux-amd64 compressed oops)*
*# Problematic frame:*
*# C 0x00007f6378ffc05f*
*#*
*# Core dump written. Default location: /home/trafodion/core or core.21310*
*#*
*# An error report file with more information is saved as:*
*# /home/trafodion/hs_err_pid21310.log*
*#*
*# If you would like to submit a bug report, please visit:*
*# http://bugreport.java.com/bugreport/crash.jsp
<http://bugreport.java.com/bugreport/crash.jsp>*
*# The crash happened outside the Java Virtual Machine in native code.*
*# See problematic frame for where to report the bug.*
*#*
**** ERROR[9200] UPDATE STATISTICS for table TRAFODION.SEABASE.TEST1
encountered an error (4082) from statement .*
**** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS does not exist or
is inaccessible.*
**** ERROR[8822] The statement was not prepared.*
*--- SQL operation failed with errors.*
Is this related to: https://bugs.launchpad.net/trafodion/+bug/1405235 ?
--
And in the end, it's not the years in your life that count. It's the life
in your years.
Follow ups