dynamobi/dynamobi — Issue #278: [LDB-43] load w/ multiple indices created hangs
Author: dynamobi-build
Created: 2011-12-30 02:26:24+00:00
State: open
Labels: LDB

[reporter="elin", created="Mon, 6 Mar 2006 17:18:51 -0500 (GMT-05:00)"]
If the table is created w/ each of the indexes individually, insert works fine.

To reproduce:

create foreign data wrapper orcl_jdbc

library '/home/elin/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;

CREATE foreign table orcl_schema.BENCH_SOURCE_10K (

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 orcl_server

options (

SCHEMA_NAME 'SCHOI',

table_name 'bench10K'

)

;

CREATE TABLE BENCH10K (

KSEQ INTEGER

,K2 INTEGER

,K4 INTEGER

,K5 INTEGER

,K10 INTEGER

,K25 INTEGER

,K100 INTEGER

,K1K INTEGER

,K10K INTEGER

,K40K INTEGER

,K100K INTEGER

,K250K INTEGER

,K500K INTEGER )

;

CREATE INDEX B10K_KSEQ_IDX ON BENCH10K (KSEQ)

;

CREATE INDEX B10K_K4_IDX ON BENCH10K (K4)

;

CREATE INDEX B10K_K5_IDX ON BENCH10K (K5)

;

CREATE INDEX B10K_K10_IDX ON BENCH10K (K10)

;

CREATE INDEX B10K_K25_IDX ON BENCH10K (K25)

;

CREATE INDEX B10K_K100_IDX ON BENCH10K (K100)

;

CREATE INDEX B10K_K1K_IDX ON BENCH10K (K1K)

;

CREATE INDEX B10K_K10K_IDX ON BENCH10K (K10K)

;

CREATE INDEX B10K_K40K_IDX ON BENCH10K (K40K)

;

CREATE INDEX B10K_K100K_IDX ON BENCH10K (K100K)

;

CREATE INDEX B10K_K250K_IDX ON BENCH10K (K250K)

;

CREATE INDEX B10K_K500K_IDX ON BENCH10K (K500K)

;

CREATE INDEX B10K_K2_IDX ON BENCH10K (K2)

;

INSERT INTO BENCH10K (KSEQ,K2,K4,K5,K10,K25,K100,K1K,K10K,K40K,K100K,K250K,

K500K) SELECT C1,C2,C4,C5,C10,C25,C100,C1K,C10K,C40K,C100K,C250K,C500K

FROM orcl_schema.BENCH_SOURCE_10K

;

Here's what the thread dump looks like while it hangs:

Full thread dump Java HotSpot(TM) Client VM (1.5.0_06-b05 mixed mode, sharing):

"Timer-0" prio=1 tid=0x0857b208 nid=0x1de3 in Object.wait() [0xa260a000..0xa260aeb0]

at java.lang.Object.wait(Native Method)

- waiting on <0x8957fe78> (a java.util.TaskQueue)

at java.util.TimerThread.mainLoop(Timer.java:509)

- locked <0x8957fe78> (a java.util.TaskQueue)

at java.util.TimerThread.run(Timer.java:462)

"MDR event dispatcher" daemon prio=1 tid=0x08306500 nid=0x1ddd in Object.wait() [0xb12f1000..0xb12f1e30]

at java.lang.Object.wait(Native Method)

- waiting on <0x89450718> (a java.util.LinkedList)

at java.lang.Object.wait(Object.java:474)

at org.netbeans.mdr.util.EventNotifier$EventsDelivery.run(EventNotifier.java:257)

- locked <0x89450718> (a java.util.LinkedList)

at java.lang.Thread.run(Thread.java:595)

"HSQLDB Timer @2808b3" daemon prio=1 tid=0x08141ff0 nid=0x1ddc in Object.wait() [0xb138e000..0xb138efb0]

at java.lang.Object.wait(Native Method)

- waiting on <0x89000e78> (a org.hsqldb.lib.HsqlTimer)

at org.hsqldb.lib.HsqlTimer.nextTask(Unknown Source)

- locked <0x89000e78> (a org.hsqldb.lib.HsqlTimer)

at org.hsqldb.lib.HsqlTimer$TaskRunner.run(Unknown Source)

at java.lang.Thread.run(Thread.java:595)

"Active Reference Queue Daemon" daemon prio=1 tid=0x08162f98 nid=0x1ddb in Object.wait() [0xb140f000..0xb140ff30]

at java.lang.Object.wait(Native Method)

- waiting on <0x89000f00> (a java.lang.ref.ReferenceQueue$Lock)

at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)

- locked <0x89000f00> (a java.lang.ref.ReferenceQueue$Lock)

at org.openide.util.Utilities$ActiveQueue.run(Utilities.java:2442)

at java.lang.Thread.run(Thread.java:595)

"Low Memory Detector" daemon prio=1 tid=0x080a4fc8 nid=0x1dc7 runnable [0x00000000..0x00000000]

"CompilerThread0" daemon prio=1 tid=0x080a3a68 nid=0x1dc6 waiting on condition [0x00000000..0xb21fc918]

"Signal Dispatcher" daemon prio=1 tid=0x080a2b60 nid=0x1dc5 runnable [0x00000000..0x00000000]

"Finalizer" daemon prio=1 tid=0x0809be20 nid=0x1dc4 in Object.wait() [0xb2446000..0xb2447030]

at java.lang.Object.wait(Native Method)

- waiting on <0x88f82d08> (a java.lang.ref.ReferenceQueue$Lock)

at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)

- locked <0x88f82d08> (a java.lang.ref.ReferenceQueue$Lock)

at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)

at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)

"Reference Handler" daemon prio=1 tid=0x0809b110 nid=0x1dc3 in Object.wait() [0xb24c8000..0xb24c81b0]

at java.lang.Object.wait(Native Method)

- waiting on <0x88f82d88> (a java.lang.ref.Reference$Lock)

at java.lang.Object.wait(Object.java:474)

at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)

- locked <0x88f82d88> (a java.lang.ref.Reference$Lock)

"main" prio=1 tid=0x0805dda0 nid=0x1dc1 runnable [0xbfb1a000..0xbfb1ab08]

at net.sf.farrago.fennel.FennelStorage.tupleStreamFetch(Native Method)

at net.sf.farrago.fennel.FennelStreamGraph.fetch(FennelStreamGraph.java:163)

at net.sf.farrago.runtime.FennelTupleIter.populateBuffer(FennelTupleIter.java:101)

at net.sf.farrago.runtime.FennelAbstractTupleIter.fetchNext(FennelAbstractTupleIter.java:99)

at net.sf.farrago.runtime.FennelIterator.hasNext(FennelIterator.java:82)

at org.eigenbase.runtime.IteratorResultSet.next(IteratorResultSet.java:125)

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

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

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

at sqlline.SqlLine$Commands.execute(Unknown Source)

at sqlline.SqlLine$Commands.sql(Unknown Source)

at sqlline.SqlLine.dispatch(Unknown Source)

at sqlline.SqlLine.begin(Unknown Source)

at sqlline.SqlLine.mainWithInputRedirection(Unknown Source)

at sqlline.SqlLine.main(Unknown Source)

"VM Thread" prio=1 tid=0x080985b8 nid=0x1dc2 runnable

"VM Periodic Task Thread" prio=1 tid=0x080a6468 nid=0x1dc8 waiting on condition