trafodion-development team mailing list archive

[Radu Marias <radumarias@xxxxxxxxx>]

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 Mon, Jul 27, 2015, 15:53 Radu Marias <radumarias@xxxxxxxxx> wrote:

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