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:21:07 UTC
update statistics error on simple test table
Hi,
Using Trafodion Sandbox 1.1 with VirtualBox after adding some data in a
test table I get this error while updating statistics. This is the scenario:
*[trafodion@n001 ~]$ sqlci*
*Trafodion Conversational Interface 1.1.0*
*(c) Copyright 2015 Hewlett-Packard Development Company, LP.*
*>>create table test1 (f1 int, f2 int);*
*--- SQL operation complete.*
*>>insert into test1 values(1,1);*
*--- 1 row(s) inserted.*
*>>insert into test1 values(2,2);*
*--- 1 row(s) inserted.*
*>>select * from test1;*
*F1 F2*
*----------- -----------*
* 1 1*
* 2 2*
*>>update statistics for table TRAFODION.SEABASE.TEST1 on every column;*
*#*
*# A fatal error has been detected by the Java Runtime Environment:*
*#*
*# SIGILL (0x4) at pc=0x00007fb4dfbd9be7, pid=19296, tid=140414902713376*
*#*
*# 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 0x00007fb4dfbd9be7*
*#*
*# Core dump written. Default location: /home/trafodion/core or core.19296*
*#*
*# An error report file with more information is saved as:*
*# /home/trafodion/hs_err_pid19296.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.*
*#*
*#*
*# A fatal error has been detected by the Java Runtime Environment:*
*#*
*# SIGILL (0x4) at pc=0x00007f6378ffc05f, pid=21310, tid=140065297075232*
*#*
*# 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 0x00007f6378ffc05f*
*#*
*# Core dump written. Default location: /home/trafodion/core or core.21310*
*#*
*# An error report file with more information is saved as:*
*# /home/trafodion/hs_err_pid21310.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[9200] UPDATE STATISTICS for table TRAFODION.SEABASE.TEST1
encountered an error (4082) from statement .*
**** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS does not exist or
is inaccessible.*
**** ERROR[8822] The statement was not prepared.*
*--- SQL operation failed with errors.*
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 on simple test table
Posted by Dave Birdsall <da...@esgyn.com>.
Hi,
Thanks for grinding through this. And thanks Amanda for the support. Radu,
if you could let us know of your progress that would be helpful.
Dave
On Mon, Jul 27, 2015 at 10:38 PM, Radu Marias <ra...@gmail.com> wrote:
> 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:50 Radu Marias <ra...@gmail.com> wrote:
>
> > Attached is $MY_SQROOT/tmp folder content.
> >
> >
> > On Fri, Jul 17, 2015 at 7:21 PM, Radu Marias <ra...@gmail.com>
> wrote:
> >
> >> Hi,
> >>
> >> Using Trafodion Sandbox 1.1 with VirtualBox after adding some data in a
> >> test table I get this error while updating statistics. This is the
> scenario:
> >>
> >> *[trafodion@n001 ~]$ sqlci*
> >> *Trafodion Conversational Interface 1.1.0*
> >> *(c) Copyright 2015 Hewlett-Packard Development Company, LP.*
> >> *>>create table test1 (f1 int, f2 int);*
> >>
> >> *--- SQL operation complete.*
> >> *>>insert into test1 values(1,1);*
> >>
> >> *--- 1 row(s) inserted.*
> >> *>>insert into test1 values(2,2);*
> >>
> >> *--- 1 row(s) inserted.*
> >> *>>select * from test1;*
> >>
> >> *F1 F2*
> >> *----------- -----------*
> >> * 1 1*
> >> * 2 2*
> >>
> >> *>>update statistics for table TRAFODION.SEABASE.TEST1 on every column;*
> >>
> >> *#*
> >> *# A fatal error has been detected by the Java Runtime Environment:*
> >> *#*
> >> *# SIGILL (0x4) at pc=0x00007fb4dfbd9be7, pid=19296,
> tid=140414902713376*
> >> *#*
> >> *# 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 0x00007fb4dfbd9be7*
> >> *#*
> >> *# Core dump written. Default location: /home/trafodion/core or
> >> core.19296*
> >> *#*
> >> *# An error report file with more information is saved as:*
> >> *# /home/trafodion/hs_err_pid19296.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.*
> >> *#*
> >> *#*
> >> *# A fatal error has been detected by the Java Runtime Environment:*
> >> *#*
> >> *# SIGILL (0x4) at pc=0x00007f6378ffc05f, pid=21310,
> tid=140065297075232*
> >> *#*
> >> *# 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 0x00007f6378ffc05f*
> >> *#*
> >> *# Core dump written. Default location: /home/trafodion/core or
> >> core.21310*
> >> *#*
> >> *# An error report file with more information is saved as:*
> >> *# /home/trafodion/hs_err_pid21310.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[9200] UPDATE STATISTICS for table TRAFODION.SEABASE.TEST1
> >> encountered an error (4082) from statement .*
> >>
> >> **** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS does not exist
> or
> >> is inaccessible.*
> >>
> >> **** ERROR[8822] The statement was not prepared.*
> >>
> >> *--- SQL operation failed with errors.*
> >>
> >> 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.
> >
>
Re: update statistics error on simple test table
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 Mon, Jul 27, 2015, 15:50 Radu Marias <ra...@gmail.com> wrote:
> Attached is $MY_SQROOT/tmp folder content.
>
>
> On Fri, Jul 17, 2015 at 7:21 PM, Radu Marias <ra...@gmail.com> wrote:
>
>> Hi,
>>
>> Using Trafodion Sandbox 1.1 with VirtualBox after adding some data in a
>> test table I get this error while updating statistics. This is the scenario:
>>
>> *[trafodion@n001 ~]$ sqlci*
>> *Trafodion Conversational Interface 1.1.0*
>> *(c) Copyright 2015 Hewlett-Packard Development Company, LP.*
>> *>>create table test1 (f1 int, f2 int);*
>>
>> *--- SQL operation complete.*
>> *>>insert into test1 values(1,1);*
>>
>> *--- 1 row(s) inserted.*
>> *>>insert into test1 values(2,2);*
>>
>> *--- 1 row(s) inserted.*
>> *>>select * from test1;*
>>
>> *F1 F2*
>> *----------- -----------*
>> * 1 1*
>> * 2 2*
>>
>> *>>update statistics for table TRAFODION.SEABASE.TEST1 on every column;*
>>
>> *#*
>> *# A fatal error has been detected by the Java Runtime Environment:*
>> *#*
>> *# SIGILL (0x4) at pc=0x00007fb4dfbd9be7, pid=19296, tid=140414902713376*
>> *#*
>> *# 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 0x00007fb4dfbd9be7*
>> *#*
>> *# Core dump written. Default location: /home/trafodion/core or
>> core.19296*
>> *#*
>> *# An error report file with more information is saved as:*
>> *# /home/trafodion/hs_err_pid19296.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.*
>> *#*
>> *#*
>> *# A fatal error has been detected by the Java Runtime Environment:*
>> *#*
>> *# SIGILL (0x4) at pc=0x00007f6378ffc05f, pid=21310, tid=140065297075232*
>> *#*
>> *# 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 0x00007f6378ffc05f*
>> *#*
>> *# Core dump written. Default location: /home/trafodion/core or
>> core.21310*
>> *#*
>> *# An error report file with more information is saved as:*
>> *# /home/trafodion/hs_err_pid21310.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[9200] UPDATE STATISTICS for table TRAFODION.SEABASE.TEST1
>> encountered an error (4082) from statement .*
>>
>> **** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS does not exist or
>> is inaccessible.*
>>
>> **** ERROR[8822] The statement was not prepared.*
>>
>> *--- SQL operation failed with errors.*
>>
>> 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.
>
Re: update statistics error on simple test table
Posted by Radu Marias <ra...@gmail.com>.
Attached is $MY_SQROOT/tmp folder content.
On Fri, Jul 17, 2015 at 7:21 PM, Radu Marias <ra...@gmail.com> wrote:
> Hi,
>
> Using Trafodion Sandbox 1.1 with VirtualBox after adding some data in a
> test table I get this error while updating statistics. This is the scenario:
>
> *[trafodion@n001 ~]$ sqlci*
> *Trafodion Conversational Interface 1.1.0*
> *(c) Copyright 2015 Hewlett-Packard Development Company, LP.*
> *>>create table test1 (f1 int, f2 int);*
>
> *--- SQL operation complete.*
> *>>insert into test1 values(1,1);*
>
> *--- 1 row(s) inserted.*
> *>>insert into test1 values(2,2);*
>
> *--- 1 row(s) inserted.*
> *>>select * from test1;*
>
> *F1 F2*
> *----------- -----------*
> * 1 1*
> * 2 2*
>
> *>>update statistics for table TRAFODION.SEABASE.TEST1 on every column;*
>
> *#*
> *# A fatal error has been detected by the Java Runtime Environment:*
> *#*
> *# SIGILL (0x4) at pc=0x00007fb4dfbd9be7, pid=19296, tid=140414902713376*
> *#*
> *# 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 0x00007fb4dfbd9be7*
> *#*
> *# Core dump written. Default location: /home/trafodion/core or core.19296*
> *#*
> *# An error report file with more information is saved as:*
> *# /home/trafodion/hs_err_pid19296.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.*
> *#*
> *#*
> *# A fatal error has been detected by the Java Runtime Environment:*
> *#*
> *# SIGILL (0x4) at pc=0x00007f6378ffc05f, pid=21310, tid=140065297075232*
> *#*
> *# 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 0x00007f6378ffc05f*
> *#*
> *# Core dump written. Default location: /home/trafodion/core or core.21310*
> *#*
> *# An error report file with more information is saved as:*
> *# /home/trafodion/hs_err_pid21310.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[9200] UPDATE STATISTICS for table TRAFODION.SEABASE.TEST1
> encountered an error (4082) from statement .*
>
> **** ERROR[4082] Object TRAFODION.SEABASE.SB_HISTOGRAMS does not exist or
> is inaccessible.*
>
> **** ERROR[8822] The statement was not prepared.*
>
> *--- SQL operation failed with errors.*
>
> 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.