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 <radumar...@gmail.com> wrote: > Attached is $MY_SQROOT/tmp folder content. > > On Fri, Jul 17, 2015 at 6:20 PM, Radu Marias <radumar...@gmail.com> wrote: > >> Is this related to: https://bugs.launchpad.net/trafodion/+bug/1405235 ? >> >> On Fri, Jul 17, 2015 at 6:15 PM, Radu Marias <radumar...@gmail.com> >> 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. >
-- Mailing list: https://launchpad.net/~trafodion-development Post to : trafodion-development@lists.launchpad.net Unsubscribe : https://launchpad.net/~trafodion-development More help : https://help.launchpad.net/ListHelp
