trafodion-development team mailing list archive
-
trafodion-development team
-
Mailing list archive
-
Message #00116
Re: update statistics error on simple test table
With help from Amanda we managed to install the latest build and now I can
run update statistics. Seems the issue was fixed.
Thanks everyone for the support.
On Fri, Jul 17, 2015, 18:20 Radu Marias <radumarias@xxxxxxxxx> wrote:
> 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.
>
References