You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Ecker Sandor <es...@freemail.hu> on 2012/10/31 15:26:22 UTC
derby is hanging in org.apache.derby.exe....g2
Hi,
I have a problem. I have a filled database, and I want to delete some entities from that.
The JPA query ist the following:
"DELETE FROM ConnectionEntity conn WHERE conn.stopOrPass.id IN " +
"(SELECT sop.id FROM StopOrPassEntity sop WHERE sop.partialTrip.id IN " +
"(SELECT prtTrip.id FROM PartialTripEntity prtTrip WHERE prtTrip.trip.id IN : Ids))"
After executing this command derby will hang and produce 100% load on one core. In the stacktrace below the "DRDAConnThread_11" thread is running constantly.
The database has all foreign key constants generated automatically by EclipseLink. Could You advice where to look further?!
Thanks,
Regards,
Sandor
2012-10-31 14:48:50
Full thread dump Java HotSpot(TM) Client VM (23.3-b01 mixed mode):
"RMI TCP Connection(4)-129.103.124.172" daemon prio=6 tid=0x1779a400 nid=0x1d68 runnable [0x185cf000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x0a260f98> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:808)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:667)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- <0x0a261120> (a java.util.concurrent.ThreadPoolExecutor$Worker)
"RMI TCP Connection(idle)" daemon prio=6 tid=0x1746c800 nid=0xad4 waiting on condition [0x1857f000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x0a255ba0> (a java.util.concurrent.SynchronousQueue$TransferStack)
at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:359)
at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:942)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1043)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1103)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"RMI TCP Connection(idle)" daemon prio=6 tid=0x174ce400 nid=0x140c waiting on condition [0x1852f000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x0a255ba0> (a java.util.concurrent.SynchronousQueue$TransferStack)
at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:460)
at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:359)
at java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:942)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1043)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1103)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"JMX server connection timeout 66" daemon prio=6 tid=0x1772b000 nid=0x19a8 in Object.wait() [0x184df000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x0a224858> (a [I)
at com.sun.jmx.remote.internal.ServerCommunicatorAdmin$Timeout.run(ServerCommunicatorAdmin.java:168)
- locked <0x0a224858> (a [I)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"RMI Scheduler(0)" daemon prio=6 tid=0x174b8000 nid=0x3ac waiting on condition [0x1848f000]
java.lang.Thread.State: TIMED_WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x0a2248e0> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:226)
at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2082)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1090)
at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:807)
at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1043)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1103)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"RMI TCP Connection(6)-129.103.124.172" daemon prio=6 tid=0x176a3400 nid=0xcac runnable [0x1843f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x0a290cd8> (a java.io.BufferedInputStream)
at java.io.FilterInputStream.read(FilterInputStream.java:83)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:808)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:667)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- <0x0a226c30> (a java.util.concurrent.ThreadPoolExecutor$Worker)
"RMI TCP Accept-0" daemon prio=6 tid=0x17731400 nid=0x1b54 runnable [0x183ef000]
java.lang.Thread.State: RUNNABLE
at java.net.TwoStacksPlainSocketImpl.socketAccept(Native Method)
at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183)
- locked <0x0a226d38> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:522)
at java.net.ServerSocket.accept(ServerSocket.java:490)
at sun.management.jmxremote.LocalRMIServerSocketFactory$1.accept(LocalRMIServerSocketFactory.java:52)
at sun.rmi.transport.tcp.TCPTransport$AcceptLoop.executeAcceptLoop(TCPTransport.java:387)
at sun.rmi.transport.tcp.TCPTransport$AcceptLoop.run(TCPTransport.java:359)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"derby.rawStoreDaemon" daemon prio=6 tid=0x1784cc00 nid=0x129c in Object.wait() [0x1828f000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x08c34a70> (a org.apache.derby.impl.services.daemon.BasicDaemon)
at org.apache.derby.impl.services.daemon.BasicDaemon.rest(Unknown Source)
- locked <0x08c34a70> (a org.apache.derby.impl.services.daemon.BasicDaemon)
at org.apache.derby.impl.services.daemon.BasicDaemon.run(Unknown Source)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"DRDAConnThread_15" prio=6 tid=0x1730ac00 nid=0x1738 in Object.wait() [0x1823f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080d90a8> (a java.util.Vector)
at java.lang.Object.wait(Object.java:503)
at org.apache.derby.impl.drda.NetworkServerControlImpl.getNextSession(Unknown Source)
- locked <0x080d90a8> (a java.util.Vector)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_14" prio=6 tid=0x173b0c00 nid=0x420 in Object.wait() [0x181ef000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080d90a8> (a java.util.Vector)
at java.lang.Object.wait(Object.java:503)
at org.apache.derby.impl.drda.NetworkServerControlImpl.getNextSession(Unknown Source)
- locked <0x080d90a8> (a java.util.Vector)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_13" prio=6 tid=0x173af400 nid=0x1154 runnable [0x1819f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_12" prio=6 tid=0x171f6c00 nid=0x1550 in Object.wait() [0x1814f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080d90a8> (a java.util.Vector)
at java.lang.Object.wait(Object.java:503)
at org.apache.derby.impl.drda.NetworkServerControlImpl.getNextSession(Unknown Source)
- locked <0x080d90a8> (a java.util.Vector)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_11" prio=6 tid=0x17200400 nid=0x177c runnable [0x180fe000]
java.lang.Thread.State: RUNNABLE
at org.apache.derby.exe.acd482ef6ex013ax9bc6xec21x0000083196555c.g2(Unknown Source)
at org.apache.derby.exe.acd482ef6ex013ax9bc6xec21x0000083196555c.e12(Unknown Source)
at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.AnyResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.exe.acd482ef6ex013ax9bc6xec21x0000083196555c.g1(Unknown Source)
at org.apache.derby.exe.acd482ef6ex013ax9bc6xec21x0000083196555c.e6(Unknown Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.AnyResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.exe.acd482ef6ex013ax9bc6xec21x0000083196555c.g0(Unknown Source)
at org.apache.derby.exe.acd482ef6ex013ax9bc6xec21x0000083196555c.e1(Unknown Source)
at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
- locked <0x08eae3c8> (a org.apache.derby.impl.jdbc.EmbedConnection40)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_10" prio=6 tid=0x173ac400 nid=0x948 runnable [0x180af000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_9" prio=6 tid=0x17739c00 nid=0x10f8 runnable [0x1805f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_8" prio=6 tid=0x177fc400 nid=0x1054 runnable [0x1800f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_7" prio=6 tid=0x16e90800 nid=0x146c in Object.wait() [0x17fbf000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080d90a8> (a java.util.Vector)
at java.lang.Object.wait(Object.java:503)
at org.apache.derby.impl.drda.NetworkServerControlImpl.getNextSession(Unknown Source)
- locked <0x080d90a8> (a java.util.Vector)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_6" prio=6 tid=0x16e98400 nid=0xbc0 runnable [0x17f6f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_5" prio=6 tid=0x17329400 nid=0x17d4 runnable [0x17f1f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"DRDAConnThread_4" prio=6 tid=0x177f4c00 nid=0x240 runnable [0x17ecf000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"derby.rawStoreDaemon" daemon prio=6 tid=0x172f5c00 nid=0x1198 in Object.wait() [0x1767f000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x081a22b0> (a org.apache.derby.impl.services.daemon.BasicDaemon)
at org.apache.derby.impl.services.daemon.BasicDaemon.rest(Unknown Source)
- locked <0x081a22b0> (a org.apache.derby.impl.services.daemon.BasicDaemon)
at org.apache.derby.impl.services.daemon.BasicDaemon.run(Unknown Source)
at java.lang.Thread.run(Thread.java:722)
Locked ownable synchronizers:
- None
"DRDAConnThread_3" prio=6 tid=0x17276c00 nid=0xde0 runnable [0x1762f000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at org.apache.derby.impl.drda.DDMReader.fill(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"NetworkServerThread_2" prio=6 tid=0x17270000 nid=0x1618 runnable [0x175df000]
java.lang.Thread.State: RUNNABLE
at java.net.TwoStacksPlainSocketImpl.socketAccept(Native Method)
at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:183)
- locked <0x08147168> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:522)
at java.net.ServerSocket.accept(ServerSocket.java:490)
at org.apache.derby.impl.drda.ClientThread$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.drda.ClientThread.run(Unknown Source)
Locked ownable synchronizers:
- None
"Timer-0" daemon prio=6 tid=0x171bb800 nid=0xf44 in Object.wait() [0x1758f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x08147260> (a java.util.TaskQueue)
at java.lang.Object.wait(Object.java:503)
at java.util.TimerThread.mainLoop(Timer.java:526)
- locked <0x08147260> (a java.util.TaskQueue)
at java.util.TimerThread.run(Timer.java:505)
Locked ownable synchronizers:
- None
"Service Thread" daemon prio=6 tid=0x16d5f000 nid=0x1314 runnable [0x00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"C1 CompilerThread0" daemon prio=10 tid=0x16d59400 nid=0xfcc waiting on condition [0x00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Attach Listener" daemon prio=10 tid=0x16d57400 nid=0x1440 waiting on condition [0x00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Signal Dispatcher" daemon prio=10 tid=0x16d56000 nid=0xe3c runnable [0x00000000]
java.lang.Thread.State: RUNNABLE
Locked ownable synchronizers:
- None
"Finalizer" daemon prio=8 tid=0x02ae4800 nid=0xab4 in Object.wait() [0x16d2f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080a3e10> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
- locked <0x080a3e10> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:177)
Locked ownable synchronizers:
- None
"Reference Handler" daemon prio=10 tid=0x02ae3000 nid=0x1734 in Object.wait() [0x16cdf000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080a3e98> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:503)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133)
- locked <0x080a3e98> (a java.lang.ref.Reference$Lock)
Locked ownable synchronizers:
- None
"main" prio=6 tid=0x003cac00 nid=0xc7c in Object.wait() [0x0094f000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x080d9010> (a java.lang.Object)
at java.lang.Object.wait(Object.java:503)
at org.apache.derby.impl.drda.NetworkServerControlImpl.blockingStart(Unknown Source)
- locked <0x080d9010> (a java.lang.Object)
at org.apache.derby.impl.drda.NetworkServerControlImpl.executeWork(Unknown Source)
at org.apache.derby.drda.NetworkServerControl.main(Unknown Source)
Locked ownable synchronizers:
- None
"VM Thread" prio=10 tid=0x02add400 nid=0x9b8 runnable
"VM Periodic Task Thread" prio=10 tid=0x16d71c00 nid=0x1630 waiting on condition
JNI global references: 222
Re: derby is hanging in org.apache.derby.exe....g2
Posted by Bryan Pendleton <bp...@gmail.com>.
> "DELETE FROM ConnectionEntity conn WHERE conn.stopOrPass.id IN " +
> "(SELECT sop.id FROM StopOrPassEntity sop WHERE sop.partialTrip.id IN " +
> "(SELECT prtTrip.id FROM PartialTripEntity prtTrip WHERE prtTrip.trip.id IN : Ids))"
There have been performance problems in the past with IN (...) queries.
Is this query under your control? Or is it generated by some tool?