dynamobi/dynamobi — Issue #312: [LDB-8] stacktrace converting from real to decimal
Author: dynamobi-build
Created: 2011-12-30 02:28:52+00:00
State: open
Labels: LDB

[reporter="schoi", created="Wed, 18 Jan 2006 17:43:12 -0500 (GMT-05:00)"]
to repro using sqllineEngine in //open/luciddb

create schema s;

set schema 's';

create table datatype_source(

name varchar(10)

,coldec decimal(14,4)

,colreal real

);

insert into datatype_source values('asdf', -4294967297,-4294967296);

create table datatype_target(col decimal(14,4));

insert into datatype_target

select colreal from datatype_source

where name='asdf';

Error as sqlline crashes:

java: /home/schoi/open/thirdparty/boost/boost/shared_ptr.hpp:253: T* boost::shared_ptr::operator->() const [with T = fennel::Segment]: Assertion `px != 0' failed.

*** CAUGHT SIGNAL 6; BACKTRACE:

/home/schoi/open/fennel/libfennel/.libs/libfennel_common-0.5.0.so(fennel::AutoBacktrace::signal_handler(int)+0x29) [0x3adc1]

[0xffffe420]

[0xffffe410]

/lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0xb7e039b1]

/lib/tls/i686/cmov/libc.so.6(abort+0xe9) [0xb7e052c9]

/lib/tls/i686/cmov/libc.so.6(__assert_fail+0x101) [0x21f51]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(boost::shared_ptr::operator->() const+0x44) [0x1357e6]

/home/schoi/open/fennel/lucidera/libfennel_lu/.libs/libfennel_lu_colstore-0.5.0.so(fennel::LcsClusterAppendExecStream::Close()+0x23) [0x20a8d]

/home/schoi/open/fennel/lucidera/libfennel_lu/.libs/libfennel_lu_colstore-0.5.0.so(fennel::LcsClusterAppendExecStream::closeImpl()+0x55) [0x200b9]

/home/schoi/open/fennel/libfennel/.libs/libfennel_common-0.5.0.so(fennel::ClosableObject::close()+0x27) [0x43e0b]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(void boost::_mfi::mf0::call >(boost::shared_ptr&, void const*) const+0x7e) [0xdb8a0]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(void boost::_mfi::mf0::operator() >(boost::shared_ptr&) const+0x2b) [0xdb81b]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(void boost::_bi::list1 >::operator(), boost::_bi::list1&> >(boost::_bi::type, boost::_mfi::mf0&, boost::_bi::list1&>&, int)+0x44) [0xdb7e0]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(void boost::_bi::bind_t, boost::_bi::list1 > >::operator() >(boost::shared_ptr&)+0x4d) [0xd1787]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(boost::_bi::bind_t, boost::_bi::list1 > > _STL::for_each<_STL::reverse_iterator<_STL::_DBG_iter<_STL::__vector, _STL::allocator > >, _STL::_Vector_nonconst_traits, boost::shared_ptr*> > >, boost::_bi::bind_t, boost::_bi::list1 > > >(_STL::reverse_iterator<_STL::_DBG_iter<_STL::__vector, _STL::allocator > >, _STL::_Vector_nonconst_traits, boost::shared_ptr*> > >, _STL::reverse_iterator<_STL::_DBG_iter<_STL::__vector, _STL::allocator > >, _STL::_Vector_nonconst_traits, boost::shared_ptr*> > >, boost::_bi::bind_t, boost::_bi::list1 > >)+0x44) [0xd03be]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::ExecStreamGraphImpl::closeImpl()+0x1d6) [0xcd2e2]

/home/schoi/open/fennel/libfennel/.libs/libfennel_common-0.5.0.so(fennel::ClosableObject::close()+0x27) [0x43e0b]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(fennel::ClosableObjectDestructor::operator()(fennel::ClosableObject*)+0x1d) [0xe7e69]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(boost::detail::sp_counted_impl_pd::dispose()+0x4f) [0xe62a9]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(boost::detail::sp_counted_base::release()+0x3f) [0xcadb7]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(boost::detail::shared_count::~shared_count()+0x27) [0xcadef]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(boost::shared_ptr::~shared_ptr()+0x20) [0xc7a00]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(fennel::CmdInterpreter::StreamGraphHandle::~StreamGraphHandle()+0xf3) [0xc04a1]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(Java_net_sf_farrago_fennel_FennelStorage_tupleStreamGraphClose+0x223) [0xb1246b5d]

[0xb268041b]

[0xb267aa7b]

[0xb267aa7b]

[0xb267a9a4]

[0xb267a9a4]

[0xb267ad81]

[0xb267a9a4]

[0xb267ad81]

Note that running similarly using sqllineEngine from //open/farrago gives this error (but sqlline does not crash)

Error: MUL(d,r,r) is not a registered instruction (at line:col 0:0 to 16:37, characters 0 to 588) (state=,code=0)

net.sf.farrago.util.FarragoUtil$FarragoSqlException: MUL(d,r,r) is not a registered instruction (at line:col 0:0 to 16:37, characters 0 to 588)at net.sf.farrago.resource.FarragoResource$_Def0.ex(FarragoResource.java:1162)

at net.sf.farrago.fennel.FennelDbHandle.handleNativeException(FennelDbHandle.java:321)

at net.sf.farrago.fennel.FennelDbHandle.executeCmd(FennelDbHandle.java:252)

at net.sf.farrago.runtime.FarragoRuntimeContext.prepareStreamGraph(FarragoRuntimeContext.java:541)

at net.sf.farrago.runtime.FarragoRuntimeContext.access$200(FarragoRuntimeContext.java:58)

at net.sf.farrago.runtime.FarragoRuntimeContext$1.initializeEntry(FarragoRuntimeContext.java:432)

at net.sf.farrago.util.FarragoObjectCache.pin(FarragoObjectCache.java:157)

at net.sf.farrago.runtime.FarragoRuntimeContext.loadFennelPlan(FarragoRuntimeContext.java:452)

at net.sf.farrago.query.FarragoExecutableJavaStmt.execute(FarragoExecutableJavaStmt.java:114)

at net.sf.farrago.db.FarragoDbStmtContext.execute(FarragoDbStmtContext.java:268)

at net.sf.farrago.jdbc.engine.FarragoJdbcEngineStatement.execute(FarragoJdbcEngineStatement.java:106)