dynamobi/dynamobi — Issue #294: [LDB-27] loading multiple tables with bitmapped indexes fails
Author: dynamobi-build
Created: 2011-12-30 02:27:25+00:00
State: closed
Labels: LBM, LDB

[reporter="schoi", created="Thu, 9 Feb 2006 12:22:51 -0500 (GMT-05:00)"]
Repro:

----------

(1) from //open/luciddb/test/sql/bench> "ant test" (you will see where and which sql command fails in /open/luciddb/test/sql/bench/gen/prop.oracle/*.log)

or

(2) (here are the sql statements in order.. note if you just try to run a subset of loads, it will probably work, even the bench1M load by itself. But loading all will reliably fail)

create foreign data wrapper orcl_jdbc

library '/home/schoi/open/luciddb/plugin/FarragoMedJdbc3p.jar'

language java;

create server orcl_server

foreign data wrapper orcl_jdbc

options(

url 'jdbc:oracle:thin:@akela.lucidera.com:1521:XE',

user_name 'schoi',

password 'schoi',

driver_class 'oracle.jdbc.driver.OracleDriver'

);

create schema orcl_schema;

import foreign schema "SCHOI" from server orcl_server into orcl_schema;

-- local tables

create schema s;

set schema 's';

create table BENCH10K (

"kseq" bigint primary key,

"k2" bigint,

"k4" bigint,

"k5" bigint,

"k10" bigint,

"k25" bigint,

"k100" bigint,

"k1k" bigint,

"k10k" bigint,

"k40k" bigint,

"k100k" bigint,

"k250k" bigint,

"k500k" bigint)

server sys_column_store_data_server;

create table BENCH100K (

"kseq" bigint primary key,

"k2" bigint,

"k4" bigint,

"k5" bigint,

"k10" bigint,

"k25" bigint,

"k100" bigint,

"k1k" bigint,

"k10k" bigint,

"k40k" bigint,

"k100k" bigint,

"k250k" bigint,

"k500k" bigint)

server sys_column_store_data_server;

create table BENCH1M (

"kseq" bigint primary key,

"k2" bigint,

"k4" bigint,

"k5" bigint,

"k10" bigint,

"k25" bigint,

"k100" bigint,

"k1k" bigint,

"k10k" bigint,

"k40k" bigint,

"k100k" bigint,

"k250k" bigint,

"k500k" bigint)

server sys_column_store_data_server;

INSERT INTO s.BENCH10K

SELECT "kseq","k2","k4","k5","k10","k25","k100","k1k","k10k","k40k","k100k","k250k","k500k"

FROM orcl_schema."bench10K";

INSERT INTO s.BENCH100K

SELECT "kseq","k2","k4","k5","k10","k25","k100","k1k","k10k","k40k","k100k","k250k","k500k"

FROM orcl_schema."bench100K";

INSERT INTO s.BENCH1M

SELECT "kseq","k2","k4","k5","k10","k25","k100","k1k","k10k","k40k","k100k","k250k","k500k"

FROM orcl_schema."bench1M";

Failure:

------------

java: TupleAccessor.cpp:438: void fennel::TupleAccessor::unmarshal(fennel::TupleData&, unsigned int) const: Assertion `value.cbData <= accessor.cbStorage' failed.

*** CAUGHT SIGNAL 6; BACKTRACE:

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

[0xffffe420]

[0xffffe410]

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

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

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

/home/schoi/open/fennel/libfennel/.libs/libfennel_tuple-0.5.0.so(fennel::TupleAccessor::unmarshal(fennel::TupleData&, unsigned) const+0x297) [0x25f6d]

/home/schoi/open/fennel/libfennel/.libs/libfennel_ftrs-0.5.0.so(fennel::ExecStreamBufAccessor::unmarshalTuple(fennel::TupleData&, unsigned)+0x3b) [0x3ddc5]

/home/schoi/open/fennel/lucidera/libfennel_lu/.libs/libfennel_lu_bitmap-0.5.0.so(fennel::LbmSplicerExecStream::execute(fennel::ExecStreamQuantum const&)+0x20a) [0x355d0]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::ExecStreamScheduler::executeStream(fennel::ExecStream&, fennel::ExecStreamQuantum const&)+0x8c) [0xbc6c0]

/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::DfsTreeExecStreamScheduler::readStream(fennel::ExecStream&)+0x4a5) [0xba833]

/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(Java_net_sf_farrago_fennel_FennelStorage_tupleStreamFetch+0xa6) [0xb12a3cce]