trafodion-development team mailing list archive

[Radu Marias <radumarias@xxxxxxxxx>]

Attached is $MY_SQROOT/tmp folder content.

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

> 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.
>



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

Attachment: tmp.zip
Description: Zip archive