trafodion-development team mailing list archive

[Radu Marias <radumarias@xxxxxxxxx>]

Is this related to: https://bugs.launchpad.net/trafodion/+bug/1405235 ?

On Fri, Jul 17, 2015 at 6:15 PM, Radu Marias <radumarias@xxxxxxxxx> wrote:

> Hi,
>
> Using Trafodion Sandbox 1.1 with VirtualBox after loading the data in one
> table I get this error while updating statistics. This is the scenario:
>
> *>>create TABLE sna_persons (*
> *    id NUMERIC not null,*
> *    last_name varchar(70),*
> *    first_name varchar(30),*
> *    middle_name varchar(30),*
> *    sex char(1),*
> *    fraud_flag char(1),*
> *    party_id varchar(24),*
> *    primary key (id)*
> *)*
> *salt using 8 partitions on (id);*
>
> *>>create index sna_persons_i1 on sna_persons(first_name)*
> *salt like table;*
>
> *>>create index sna_persons_i2 on sna_persons(last_name)*
> *salt like table;*
>
> *>>create index sna_persons_i3 on sna_persons(party_id) salt like table;*
>
> *>>load with truncate table into TRAFODION.SEABASE.SNA_PERSONS select id,
> '', first_name, '', sex, fraud_flag, party_id from hive.hive.sna_persons;*
>
> *>>update statistics for table sna_persons on every column sample;*
>
>
> *## A fatal error has been detected by the Java Runtime Environment:##
>  SIGILL (0x4) at pc=0x00007f003d995ae7, pid=17464, tid=139639087959072##
> 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
>  0x00007f003d995ae7## Core dump written. Default location:
> /home/trafodion/core or core.30596## An error report file with more
> information is saved as:# /home/trafodion/hs_err_pid30596.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[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS does not exist or
> is inaccessible.*
>
> **** ERROR[8822] The statement was not prepared.*
>
> **** ERROR[4082] Object
> TRAFODION.SEABASE.SQLMX_116039459583781590_1437143510_194424 does not exist
> or is inaccessible.*
>
> **** ERROR[9214] Object
> TRAFODION.SEABASE.SQLMX_116039459583781590_1437143510_194424 could not be
> created.*
>
> **** ERROR[1390] Object
> TRAFODION.SEABASE.SQLMX_116039459583781590_1437143510_194424 already exists
> in Trafodion.*
>
> **** ERROR[9201] Unable to DROP object
> TRAFODION.SEABASE.SQLMX_116039459583781590_1437143510_194424.*
>
> **** ERROR[1389] Object
> TRAFODION.SEABASE.SQLMX_116039459583781590_1437143510_194424 does not exist
> in Trafodion.*
>
> *--- SQL operation failed with errors.*
>
> Attached is  the crash log file.
>
> --
> And in the end, it's not the years in your life that count. It's the life
> in your years.
>



-- 
And in the end, it's not the years in your life that count. It's the life
in your years.