You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by Radu Marias <ra...@gmail.com> on 2015/07/17 18:18:43 UTC
update statistics *** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS
does not exist or is inaccessible.
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.
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.
Re: update statistics *** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS
does not exist or is inaccessible.
Posted by Radu Marias <ra...@gmail.com>.
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 Tue, Jul 28, 2015, 01:10 Qifan Chen <qi...@esgyn.com> wrote:
> Hi Radu,
>
> Thank you.
>
> In the log, I saw the error is raised against the following query.
>
> SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT,
> TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE,
> JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS,
> SAMPLE_PERCENT, CV, REASON, V1, V2 FROM
>
> TRAFODION.SEABASE.SB_HISTOGRAMS WHERE TABLE_UID = 12457542258532803 AND
> REASON != ' ' ORDER BY TABLE_UID, HISTOGRAM_ID, COL_POSITION FOR READ
> UNCOMMITTED ACCESS
>
>
> Can you please do a showddl command in sqlci for the following command?
>
> showddl TRAFODION.SEABASE.SB_HISTOGRAMS;
>
> I would like to know if the table is indeed created as shown in the log as
> well.
>
>
>
> On Mon, Jul 27, 2015 at 12:05 PM, Radu Marias <ra...@gmail.com>
> wrote:
>
>> Attached are the logs.
>>
>> On Mon, Jul 27, 2015 at 5:07 PM, Qifan Chen <qi...@esgyn.com> wrote:
>>
>>> Hi Radu
>>>
>>> I wonder if you can retry the update stats statement with ULOG feature
>>> turned on, and send us the ULOG file. In this way, we can know better about
>>> what is going on.
>>>
>>> sh rm ULOG;
>>> update statistics log on;
>>> cqd ustat_log 'ulog';
>>> update statistics for table T ...
>>>
>>> I have sent out a similar request email earlier and did not think I have
>>> received the ULOG file.
>>>
>>> Thanks
>>>
>>>
>>> On Mon, Jul 27, 2015 at 5:53 AM, Radu Marias <ra...@gmail.com>
>>> wrote:
>>>
>>>> Attached is $MY_SQROOT/tmp folder content, if it helps.
>>>>
>>>> On Fri, Jul 17, 2015 at 7:18 PM, Radu Marias <ra...@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.
>>>>>
>>>>> 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.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> And in the end, it's not the years in your life that count. It's the
>>>> life in your years.
>>>>
>>>
>>>
>>>
>>> --
>>> Regards, --Qifan
>>>
>>>
>>
>>
>> --
>> And in the end, it's not the years in your life that count. It's the life
>> in your years.
>>
>
>
>
> --
> Regards, --Qifan
>
>
Re: update statistics *** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS
does not exist or is inaccessible.
Posted by Qifan Chen <qi...@esgyn.com>.
Hi Radu,
Thank you.
In the log, I saw the error is raised against the following query.
SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT,
TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE,
JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS,
SAMPLE_PERCENT, CV, REASON, V1, V2 FROM
TRAFODION.SEABASE.SB_HISTOGRAMS WHERE TABLE_UID = 12457542258532803 AND
REASON != ' ' ORDER BY TABLE_UID, HISTOGRAM_ID, COL_POSITION FOR READ
UNCOMMITTED ACCESS
Can you please do a showddl command in sqlci for the following command?
showddl TRAFODION.SEABASE.SB_HISTOGRAMS;
I would like to know if the table is indeed created as shown in the log as
well.
On Mon, Jul 27, 2015 at 12:05 PM, Radu Marias <ra...@gmail.com> wrote:
> Attached are the logs.
>
> On Mon, Jul 27, 2015 at 5:07 PM, Qifan Chen <qi...@esgyn.com> wrote:
>
>> Hi Radu
>>
>> I wonder if you can retry the update stats statement with ULOG feature
>> turned on, and send us the ULOG file. In this way, we can know better about
>> what is going on.
>>
>> sh rm ULOG;
>> update statistics log on;
>> cqd ustat_log 'ulog';
>> update statistics for table T ...
>>
>> I have sent out a similar request email earlier and did not think I have
>> received the ULOG file.
>>
>> Thanks
>>
>>
>> On Mon, Jul 27, 2015 at 5:53 AM, Radu Marias <ra...@gmail.com>
>> wrote:
>>
>>> Attached is $MY_SQROOT/tmp folder content, if it helps.
>>>
>>> On Fri, Jul 17, 2015 at 7:18 PM, Radu Marias <ra...@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.
>>>>
>>>> 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.
>>>>
>>>
>>>
>>>
>>> --
>>> And in the end, it's not the years in your life that count. It's the
>>> life in your years.
>>>
>>
>>
>>
>> --
>> Regards, --Qifan
>>
>>
>
>
> --
> And in the end, it's not the years in your life that count. It's the life
> in your years.
>
--
Regards, --Qifan
Re: update statistics *** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS
does not exist or is inaccessible.
Posted by Radu Marias <ra...@gmail.com>.
Attached are the logs.
On Mon, Jul 27, 2015 at 5:07 PM, Qifan Chen <qi...@esgyn.com> wrote:
> Hi Radu
>
> I wonder if you can retry the update stats statement with ULOG feature
> turned on, and send us the ULOG file. In this way, we can know better about
> what is going on.
>
> sh rm ULOG;
> update statistics log on;
> cqd ustat_log 'ulog';
> update statistics for table T ...
>
> I have sent out a similar request email earlier and did not think I have
> received the ULOG file.
>
> Thanks
>
>
> On Mon, Jul 27, 2015 at 5:53 AM, Radu Marias <ra...@gmail.com> wrote:
>
>> Attached is $MY_SQROOT/tmp folder content, if it helps.
>>
>> On Fri, Jul 17, 2015 at 7:18 PM, Radu Marias <ra...@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.
>>>
>>> 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.
>>>
>>
>>
>>
>> --
>> And in the end, it's not the years in your life that count. It's the life
>> in your years.
>>
>
>
>
> --
> Regards, --Qifan
>
>
--
And in the end, it's not the years in your life that count. It's the life
in your years.
Re: update statistics *** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS
does not exist or is inaccessible.
Posted by Qifan Chen <qi...@esgyn.com>.
Hi Radu
I wonder if you can retry the update stats statement with ULOG feature
turned on, and send us the ULOG file. In this way, we can know better about
what is going on.
sh rm ULOG;
update statistics log on;
cqd ustat_log 'ulog';
update statistics for table T ...
I have sent out a similar request email earlier and did not think I have
received the ULOG file.
Thanks
On Mon, Jul 27, 2015 at 5:53 AM, Radu Marias <ra...@gmail.com> wrote:
> Attached is $MY_SQROOT/tmp folder content, if it helps.
>
> On Fri, Jul 17, 2015 at 7:18 PM, Radu Marias <ra...@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.
>>
>> 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.
>>
>
>
>
> --
> And in the end, it's not the years in your life that count. It's the life
> in your years.
>
--
Regards, --Qifan
Re: update statistics *** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS
does not exist or is inaccessible.
Posted by Radu Marias <ra...@gmail.com>.
Attached is $MY_SQROOT/tmp folder content, if it helps.
On Fri, Jul 17, 2015 at 7:18 PM, Radu Marias <ra...@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.
>
> 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.
>
--
And in the end, it's not the years in your life that count. It's the life
in your years.