dynamobi/dynamobi — Issue #260: [LDB-61] star join test hangs
Author: dynamobi-build
Created: 2011-12-30 02:25:06+00:00
State: closed
Labels: LDB

[reporter="elin", created="Wed, 12 Apr 2006 11:27:28 -0500 (GMT-05:00)"]
Hanging test found during nightly test run, under open/luciddb/test/sql/pge/8.sql

To rerun just this test, mount raksha and then go to open/luciddb/test/sql/pge/

and run

ant test -Dtestfile=test.xml -Dforeign.db=flatfile -Dbh.test-names=pge.index,pge.8

Log with thread dump:

0: jdbc:luciddb:> SELECT AL4.REVN_YR, AL4.REVN_MO, AL3.SRVPLN_ID,

. . . . . . . . > AL3.SRVPLN_NM, AL2.GEOG_CNTY_CD, SUM(AL5.RSD_SVC_BILG_AMT)

. . . . . . . . > FROM

. . . . . . . . > PGE.CUST_SERV_ACCT AL1,

. . . . . . . . > PGE.GEOG AL2,

. . . . . . . . > PGE.SERV_PLAN AL3,

. . . . . . . . > PGE.REVN_PRD AL4,

. . . . . . . . > PGE.REVN_DTL_RAND AL5

. . . . . . . . > WHERE (AL5.REVN_YR_MO=AL4.REVN_YR_MO

. . . . . . . . > AND AL2.GEOG_KEY=AL5.GEOG_KEY

. . . . . . . . > AND AL3.SRVPLN_KEY=AL5.SRVPLN_KEY

. . . . . . . . > AND AL1.CUST_SERV_ACCT_KEY=AL5.CUST_SERV_ACCT_KEY)

. . . . . . . . > GROUP BY AL4.REVN_YR, AL4.REVN_MO, AL3.SRVPLN_ID,

. . . . . . . . > AL3.SRVPLN_NM, AL2.GEOG_CNTY_CD

. . . . . . . . > ORDER BY 5, 1, 2, 3, 4, 6

. . . . . . . . > ;

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

"Timer-0" prio=1 tid=0x08595668 nid=0x22ee in Object.wait() [0xa244a000..0xa244af30]

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

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

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

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

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

"MDR event dispatcher" daemon prio=1 tid=0x08093a68 nid=0x22e7 in Object.wait() [0xb114a000..0xb114afb0]

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

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

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

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

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

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

"HSQLDB Timer @1cb25f1" daemon prio=1 tid=0x0849ab30 nid=0x22e4 in Object.wait() [0xb1268000..0xb1268e30]

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

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

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

- locked <0x89012180> (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=0x08488b90 nid=0x22e3 in Object.wait() [0xb11e7000..0xb11e7eb0]

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

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

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

- locked <0x89003cb8> (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=0x080a5118 nid=0x22d0 runnable [0x00000000..0x00000000]

"CompilerThread0" daemon prio=1 tid=0x080a3bb8 nid=0x22cf waiting on condition [0x00000000..0xb2287898]

"Signal Dispatcher" daemon prio=1 tid=0x080a2cb0 nid=0x22ce waiting on condition [0x00000000..0x00000000]

"Finalizer" daemon prio=1 tid=0x0809bf70 nid=0x22cd in Object.wait() [0xb24d2000..0xb24d21b0]

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

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

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

- locked <0x88f85800> (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=0x0809b260 nid=0x22cc in Object.wait() [0xb2552000..0xb2553030]

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

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

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

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

"main" prio=1 tid=0x0805def0 nid=0x22ca runnable [0xbfdaa000..0xbfdaaac8]

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

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

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

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

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)

at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)

at sqlline.SqlLine$BufferedRows.(Unknown Source)

at sqlline.SqlLine.print(Unknown Source)

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=0x08098708 nid=0x22cb runnable

"VM Periodic Task Thread" prio=1 tid=0x080a65b8 nid=0x22d1 waiting on condition

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

"Timer-0" prio=1 tid=0x08595668 nid=0x22ee in Object.wait() [0xa244a000..0xa244af30]

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

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

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

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

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

"MDR event dispatcher" daemon prio=1 tid=0x08093a68 nid=0x22e7 in Object.wait() [0xb114a000..0xb114afb0]

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

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

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

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

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

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

"HSQLDB Timer @1cb25f1" daemon prio=1 tid=0x0849ab30 nid=0x22e4 in Object.wait() [0xb1268000..0xb1268e30]

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

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

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

- locked <0x89012180> (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=0x08488b90 nid=0x22e3 in Object.wait() [0xb11e7000..0xb11e7eb0]

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

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

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

- locked <0x89003cb8> (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=0x080a5118 nid=0x22d0 runnable [0x00000000..0x00000000]

"CompilerThread0" daemon prio=1 tid=0x080a3bb8 nid=0x22cf waiting on condition [0x00000000..0xb2287898]

"Signal Dispatcher" daemon prio=1 tid=0x080a2cb0 nid=0x22ce runnable [0x00000000..0x00000000]

"Finalizer" daemon prio=1 tid=0x0809bf70 nid=0x22cd in Object.wait() [0xb24d2000..0xb24d21b0]

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

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

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

- locked <0x88f85800> (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=0x0809b260 nid=0x22cc in Object.wait() [0xb2552000..0xb2553030]

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

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

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

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

"main" prio=1 tid=0x0805def0 nid=0x22ca runnable [0xbfdaa000..0xbfdaaac8]

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

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

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

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

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)

at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)

at sqlline.SqlLine$BufferedRows.(Unknown Source)

at sqlline.SqlLine.print(Unknown Source)

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=0x08098708 nid=0x22cb runnable

"VM Periodic Task Thread" prio=1 tid=0x080a65b8 nid=0x22d1 waiting on condition

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

"Timer-0" prio=1 tid=0x08595668 nid=0x22ee in Object.wait() [0xa244a000..0xa244af30]

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

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

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

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

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

"MDR event dispatcher" daemon prio=1 tid=0x08093a68 nid=0x22e7 in Object.wait() [0xb114a000..0xb114afb0]

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

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

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

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

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

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

"HSQLDB Timer @1cb25f1" daemon prio=1 tid=0x0849ab30 nid=0x22e4 in Object.wait() [0xb1268000..0xb1268e30]

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

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

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

- locked <0x89012180> (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=0x08488b90 nid=0x22e3 in Object.wait() [0xb11e7000..0xb11e7eb0]

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

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

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

- locked <0x89003cb8> (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=0x080a5118 nid=0x22d0 runnable [0x00000000..0x00000000]

"CompilerThread0" daemon prio=1 tid=0x080a3bb8 nid=0x22cf waiting on condition [0x00000000..0xb2287898]

"Signal Dispatcher" daemon prio=1 tid=0x080a2cb0 nid=0x22ce runnable [0x00000000..0x00000000]

"Finalizer" daemon prio=1 tid=0x0809bf70 nid=0x22cd in Object.wait() [0xb24d2000..0xb24d21b0]

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

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

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

- locked <0x88f85800> (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=0x0809b260 nid=0x22cc in Object.wait() [0xb2552000..0xb2553030]

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

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

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

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

"main" prio=1 tid=0x0805def0 nid=0x22ca runnable [0xbfdaa000..0xbfdaaac8]

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

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

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

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

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)

at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)

at sqlline.SqlLine$BufferedRows.(Unknown Source)

at sqlline.SqlLine.print(Unknown Source)

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=0x08098708 nid=0x22cb runnable

"VM Periodic Task Thread" prio=1 tid=0x080a65b8 nid=0x22d1 waiting on condition