dynamobi/dynamobi — Issue #273: [LDB-48] crash in LbmsegmentReader when selecting on a bitmap indexed table filtering on 3 columns
Author: dynamobi-build
Created: 2011-12-30 02:26:06+00:00
State: open
Labels: LDB

[reporter="elin", created="Tue, 14 Mar 2006 14:49:26 -0500 (GMT-05:00)"]
0: jdbc:luciddb:> SELECT KSEQ, K500K FROM BENCH1M

. . . . . . . . > WHERE

. . . . . . . . >K2 = 1

. . . . . . . . > AND K100 > 80

. . . . . . . . > AND K10K BETWEEN 2000 AND 3000;

java: LbmSegmentReader.cpp:99: void fennel::LbmSegmentReader::readCurrentByteSegment(fennel::LcsRid&, uint8_t*&, uint&): Assertion `*byteSeg != 0' failed.

*** CAUGHT SIGNAL 6; BACKTRACE:

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

[0xffffe420]

[0xffffe410]

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

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

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

/home/elin/open/fennel/lucidera/libfennel_lu/.libs/libfennel_lu_colstore-0.5.0.so(fennel::LbmSegmentReader::readCurrentByteSegment(fennel::OpaqueInteger&, unsigned char*&, unsigned&)+0xc8) [0x58e30]

/home/elin/open/fennel/lucidera/libfennel_lu/.libs/libfennel_lu_colstore-0.5.0.so(fennel::LbmIntersectExecStream::execute(fennel::ExecStreamQuantum const&)+0x28c) [0x6e206]

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

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

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

[0xb273641b]

[0xb27309cf]

[0xb27309cf]

[0xb27309cf]

[0xb2730caa]

[0xb2730caa]

[0xb2730923]

[0xb2730c29]

[0xb2730a7b]

[0xb27309cf]

[0xb2730923]

[0xb2730923]

[0xb2730923]

[0xb2730a7b]

[0xb2730a7b]

[0xb272e157]

/usr/local/java/jdk1.5.0_06/jre/lib/i386/client/libjvm.so [0xb786ffec]

/usr/local/java/jdk1.5.0_06/jre/lib/i386/client/libjvm.so [0xb797d1f8]

/usr/local/java/jdk1.5.0_06/jre/lib/i386/client/libjvm.so [0xb786fe1f]

/usr/local/java/jdk1.5.0_06/jre/lib/i386/client/libjvm.so [0xb789a5c2]

/usr/local/java/jdk1.5.0_06/jre/lib/i386/client/libjvm.so [0xb788b7d2]

./sqllineEngine: line 16: 17420 Aborted java ${SERVER_JAVA_ARGS} ${SQLLINE_JAVA_ARGS} -u jdbc:luciddb: -d com.lucidera.jdbc.LucidDbLocalDriver -n sa $*

Terminal reset because sqlline crashed

To reproduce:

create foreign data wrapper mssql_jdbc

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

language java;

create server mssql_server

foreign data wrapper mssql_jdbc

options(

url 'jdbc:jtds:sqlserver://akela.lucidera.com:1433',

user_name 'sa',

password 'ketajo',

qualifying_catalog_name 'BENCHMARK',

table_types 'TABLE',

driver_class 'net.sourceforge.jtds.jdbc.Driver'

);

create schema mssql_schema;

set schema 'mssql_schema';

create schema s;

set schema 's';

CREATE TABLE BENCH1M (

KSEQ INTEGER primary key

,K2 INTEGER

,K4 INTEGER

,K5 INTEGER

,K10 INTEGER

,K25 INTEGER

,K100 INTEGER

,K1K INTEGER

,K10K INTEGER

,K40K INTEGER

,K100K INTEGER

,K250K INTEGER

,K500K INTEGER

,S1 VARCHAR(8)

,S2 VARCHAR(20)

,S3 VARCHAR(20)

,S4 VARCHAR(20)

,S5 VARCHAR(20)

,S6 VARCHAR(20)

,S7 VARCHAR(20)

,S8 VARCHAR(20)

)

;

CREATE INDEX B1M_K2_IDX ON BENCH1M(K2)

;

CREATE INDEX B1M_K4_IDX ON BENCH1M(K4)

;

CREATE INDEX B1M_K5_IDX ON BENCH1M(K5)

;

CREATE INDEX B1M_K10_IDX ON BENCH1M(K10)

;

CREATE INDEX B1M_K25_IDX ON BENCH1M(K25)

;

CREATE INDEX B1M_K100_IDX ON BENCH1M(K100)

;

CREATE INDEX B1M_K1K_IDX ON BENCH1M(K1K)

;

CREATE INDEX B1M_K10K_IDX ON BENCH1M(K10K)

;

CREATE INDEX B1M_K40K_IDX ON BENCH1M(K40K)

;

CREATE INDEX B1M_K100K_IDX ON BENCH1M(K100K)

;

CREATE INDEX B1M_K250K_IDX ON BENCH1M(K250K)

;

CREATE INDEX B1M_K500K_IDX ON BENCH1M(K500K)

;

-- composite indices (for Q5)

CREATE INDEX B1M_K2_K100_IDX ON BENCH1M(K2,K100)

;

CREATE INDEX B1M_K4_K25_IDX ON BENCH1M(K4,K25)

;

CREATE INDEX B1M_K10_K25_IDX ON BENCH1M(K10,K25)

;

CREATE FOREIGN TABLE BENCH_SOURCE (

C1 INTEGER,

C2 INTEGER,

C4 INTEGER,

C5 INTEGER,

C10 INTEGER,

C25 INTEGER,

C100 INTEGER,

C1K INTEGER,

C10K INTEGER,

C40K INTEGER,

C100K INTEGER,

C250K INTEGER,

C500K INTEGER

)

server mssql_server

options (

SCHEMA_NAME 'dbo',

TABLE_NAME 'bench1M'

)

;

insert into bench1m (kseq,k2,k4,k5,k10,k25,k100,k1K,k10k,k40k,k100k,k250k,

k500k, s1, s2, s3, s4, s5, s6, s7, s8)

select c1,c2,c4,c5,c10,c25,c100,c1k,c10k,c40k,c100k,c250k,c500k,

'12345678', '12345678900987654321', '12345678900987654321', '12345678900987654321', '12345678900987654321', '12345678900987654321', '12345678900987654321', '12345678900987654321'

from bench_source

;

SELECT KSEQ, K500K FROM BENCH1M

WHERE

K2 = 1

AND K100 > 80

AND K10K BETWEEN 2000 AND 3000;