dynamobi/dynamobi — Issue #495: [FNL-13] fennel dumps during join in luciddb tests
Author: dynamobi-build
Created: 2011-12-30 03:29:42+00:00
State: open
Labels: FNL

[reporter="boris", created="Tue, 31 Jan 2006 16:33:26 -0500 (GMT-05:00)"]
Stack trace is:

"Main Thread" id=1 idx=0x2 tid=19485 lastJavaFrame=0xbfffca78

Stack 0: start=0xbfe00000, end=0xc0000000, guards=0xbfe05000 (ok), forbidden=0xbfe03000

Thread Stack Trace:

at _ZN6fennel9SqlStrCmpILi1ELi1EEEiPKciS2_ii+150(SqlString.h:209)@0xa2ce9fb6 at _ZN6fennel7strCmpAEPNS_11RegisterRefIiEEPNS0_IPcEES5_+226(ExtString.cpp:79)@0xa2ce56dc

at _ZNK6fennel20ExtendedInstruction3IiPcS1_E4execERl+73(ExtendedInstruction.h:649)@0xa2cedde1

at _ZN6fennel10Calculator4execEv+1746(Calculator.cpp:298)@0xa2bff52a

at _ZN6fennel14CalcExecStream7executeERKNS_17ExecStreamQuantumE+246(CalcExecStream.cpp:137)@0xb739a68a

at _ZN6fennel19ExecStreamScheduler13executeStreamERNS_10ExecStreamERKNS_17ExecStreamQuantumE+140(ExecStreamScheduler.h:230)@0xb697801c

at _ZN6fennel26DfsTreeExecStreamScheduler10readStreamERNS_10ExecStreamE+1187(DfsTreeExecStreamScheduler.cpp:137)@0xb69761a3

at Java_net_sf_farrago_fennel_FennelStorage_tupleStreamFetch+166(NativeMethods.cpp:112)@0xb6c3c8b6

-- Java stack --

at net/sf/farrago/fennel/FennelStorage.tupleStreamFetch(J[B)I(Native Method) at net/sf/farrago/fennel/FennelStreamGraph.fetch(Lnet/sf/farrago/fennel/FennelStreamHandle;[B)I(FennelStreamGraph.java:163)

at net/sf/farrago/runtime/FennelIterator.populateBuffer()I(FennelIterator.java:96)

at net/sf/farrago/runtime/FennelAbstractIterator.hasNext()Z(FennelAbstractIterator.java:100)

at org/eigenbase/runtime/IteratorResultSet.next()Z(IteratorResultSet.java:196)

at net/sf/farrago/runtime/FarragoIteratorResultSet.next()Z(FarragoIteratorResultSet.java:98)

at sqlline/SqlLine$BufferedRows.(Lsqlline/SqlLine;Ljava/sql/ResultSet;)V(Unknown Source)

at sqlline/SqlLine.print(Ljava/sql/ResultSet;)I(Unknown Source)

at sqlline/SqlLine$Commands.execute(Ljava/lang/String;Z)Z(Unknown Source)

at sqlline/SqlLine$Commands.sql(Ljava/lang/String;)Z(Unknown Source)

at sqlline/SqlLine.dispatch(Ljava/lang/String;)Z(Unknown Source)

at sqlline/SqlLine.begin([Ljava/lang/String;Ljava/io/InputStream;)V(Unknown Source)

at sqlline/SqlLine.mainWithInputRedirection([Ljava/lang/String;Ljava/io/InputStream;)V(Unknown Source)

at sqlline/SqlLine.main([Ljava/lang/String;)V(Unknown Source)

at jrockit/vm/RNI.c2java(IIII)V(Native Method)

-- end of trace

In order to reproduce, run sqllineEngine from open/luciddb and execute the following (keep in mind that you need to do an "ant restoreCatalog" after this crash):

=======================================

-- SETUP:

create schema s;

set schema 's';

create table CUSTOMERS(

CUSTID integer primary key,

FNAME varchar(30),

LNAME varchar(30) not null,

SEX char(1))

server sys_ftrs_data_server;

create index CUSTOMERS_NAME on CUSTOMERS(LNAME, FNAME);

create foreign data wrapper test_jdbc library '../farrago/plugin/FarragoMedJdbc.jar' language java;

create server csv_server

foreign data wrapper test_jdbc

options(

driver_class 'org.relique.jdbc.csv.CsvDriver',

url 'jdbc:relique:csv:test/sql/shortreg',

schema_name 'TESTDATA');

create schema csv_schema;

create foreign table csv_schema.SHORTREG_CUSTOMERS_SRC (

CUSTID INTEGER,

FNAME VARCHAR(30),

LNAME VARCHAR(30),

SEX VARCHAR(1)

)

server csv_server

options (table_name 'customers');

INSERT INTO s.CUSTOMERS

SELECT CUSTID,FNAME,LNAME,SEX FROM csv_schema.SHORTREG_CUSTOMERS_SRC;

-- QUERY THAT DIES

-- many to many self join

select M.FNAME ,F.FNAME, M.LNAME

FROM CUSTOMERS M, CUSTOMERS F

WHERE M.LNAME = F.LNAME

AND M.SEX = 'M'

AND F.SEX = 'F'

order by FNAME, FNAME, LNAME;