[
http://issues.apache.org/jira/browse/DERBY-389?page=comments#action_12314350 ]
Kathey Marsden commented on DERBY-389:
--------------------------------------
Manjula sent me this trace when the server was in a similar state,
"DRDAConnThread_7" prio=5 tid=0x0ae97d18 nid=0x988 waiting for monitor entry
[0x
0bdcf000..0x0bdcf9e4]
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.remov
eStatement(GenericLanguageConnectionContext.java)
- waiting to lock <0x02fdfcd0> (a org.apache.derby.impl.services.cache.C
lock)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen
t.java)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j
ava)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPrepare
dStatement.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPrepa
redStatement20.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPrepa
redStatement30.java)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.jav
a)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
- locked <0x03db03e0> (a org.apache.derby.impl.jdbc.EmbedConnection30)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(DRDASt
atement.java)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatemen
t.java)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThre
ad.java)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr
ead.java)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java)
"DRDAConnThread_6" prio=5 tid=0x0aeb8d28 nid=0x998 in Object.wait() [0x0bd8f000.
.0x0bd8fa64]
at java.lang.Object.wait(Native Method)
- waiting on <0x03db4a78> (a org.apache.derby.impl.services.cache.Cached
Item)
at java.lang.Object.wait(Object.java:474)
at org.apache.derby.impl.services.cache.CachedItem.remove(CachedItem.jav
a)
- locked <0x03db4a78> (a org.apache.derby.impl.services.cache.CachedItem
)
at org.apache.derby.impl.services.cache.Clock.remove(Clock.java)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.remov
eStatement(GenericLanguageConnectionContext.java)
- locked <0x02fdfcd0> (a org.apache.derby.impl.services.cache.Clock)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen
t.java)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j
ava)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPrepare
dStatement.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPrepa
redStatement20.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPrepa
redStatement30.java)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.jav
a)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
- locked <0x03db5ad8> (a org.apache.derby.impl.jdbc.EmbedConnection30)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(DRDASt
atement.java)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatemen
t.java)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThre
ad.java)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr
ead.java)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java)
"DRDAConnThread_5" prio=5 tid=0x0adb94c8 nid=0x9a8 waiting for monitor entry [0x
0bd4f000..0x0bd4fae4]
at org.apache.derby.impl.services.cache.Clock.find(Clock.java)
- waiting to lock <0x02fdfcd0> (a org.apache.derby.impl.services.cache.C
lock)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.looku
pStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen
t.java)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j
ava)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java
)
- locked <0x03e07518> (a org.apache.derby.impl.jdbc.EmbedConnection30)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatemen
t.java)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThre
ad.java)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr
ead.java)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java)
"DRDAConnThread_4" prio=5 tid=0x009febe8 nid=0x9c0 waiting for monitor entry [0x
0bd0f000..0x0bd0fb64]
at org.apache.derby.impl.services.cache.Clock.find(Clock.java)
- waiting to lock <0x02fdfcd0> (a org.apache.derby.impl.services.cache.C
lock)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.looku
pStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen
t.java)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j
ava)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPrepare
dStatement.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPrepa
redStatement20.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPrepa
redStatement30.java)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.jav
a)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
- locked <0x03dbd7f8> (a org.apache.derby.impl.jdbc.EmbedConnection30)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(DRDASt
atement.java)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatemen
t.java)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThre
ad.java)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr
ead.java)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java)
"DRDAConnThread_3" prio=5 tid=0x0ba4b5b8 nid=0x9d0 waiting for monitor entry [0x
0bccf000..0x0bccfbe4]
at org.apache.derby.impl.services.cache.Clock.find(Clock.java)
- waiting to lock <0x02fdfcd0> (a org.apache.derby.impl.services.cache.C
lock)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.looku
pStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen
t.java)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j
ava)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java
)
- locked <0x03e078d8> (a org.apache.derby.impl.jdbc.EmbedConnection30)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatemen
t.java)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThre
ad.java)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr
ead.java)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java)
"derby.rawStoreDaemon" daemon prio=5 tid=0x0ad29d68 nid=0x9d8 in Object.wait() [
0x0b88f000..0x0b88fc64]
at java.lang.Object.wait(Native Method)
at org.apache.derby.impl.services.daemon.BasicDaemon.rest(BasicDaemon.ja
va)
- locked <0x02fcf1e0> (a org.apache.derby.impl.services.daemon.BasicDaem
on)
at org.apache.derby.impl.services.daemon.BasicDaemon.run(BasicDaemon.jav
a)
at java.lang.Thread.run(Thread.java:595)
"DRDAConnThread_2" prio=5 tid=0x0ae1e448 nid=0x9e0 waiting for monitor entry [0x
0b84f000..0x0b84fce4]
at org.apache.derby.impl.services.cache.Clock.release(Clock.java)
- waiting to lock <0x02fdfcd0> (a org.apache.derby.impl.services.cache.C
lock)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.looku
pStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen
t.java)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j
ava)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPrepare
dStatement.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPrepa
redStatement20.java)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPrepa
redStatement30.java)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.jav
a)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
- locked <0x03dca718> (a org.apache.derby.impl.jdbc.EmbedConnection30)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn
ection.java)
at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(DRDASt
atement.java)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatemen
t.java)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThre
ad.java)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr
ead.java)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java)
"Thread-1" prio=5 tid=0x0ad8cde8 nid=0xa54 runnable [0x0b7ff000..0x0b7ffd64]
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:384)
- locked <0x02faf708> (a java.net.SocksSocketImpl)
at java.net.ServerSocket.implAccept(ServerSocket.java:450)
at java.net.ServerSocket.accept(ServerSocket.java:421)
at org.apache.derby.impl.drda.ClientThread$1.run(ClientThread.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.drda.ClientThread.run(ClientThread.java)
at java.lang.Thread.run(Thread.java:595)
"derby.antiGC" daemon prio=2 tid=0x0ad2cc40 nid=0xa5c in Object.wait() [0x0af3f0
00..0x0af3f9e4]
at java.lang.Object.wait(Native Method)
- waiting on <0x02fa2150> (a org.apache.derby.impl.services.monitor.Anti
GC)
at java.lang.Object.wait(Object.java:474)
at org.apache.derby.impl.services.monitor.AntiGC.run(BaseMonitor.java)
- locked <0x02fa2150> (a org.apache.derby.impl.services.monitor.AntiGC)
at java.lang.Thread.run(Thread.java:595)
"Low Memory Detector" daemon prio=5 tid=0x009d2f60 nid=0x5cc runnable [0x0000000
0..0x00000000]
"CompilerThread0" daemon prio=10 tid=0x009d1ac0 nid=0xa68 waiting on condition [
0x00000000..0x0ac6f8bc]
"Signal Dispatcher" daemon prio=10 tid=0x009d0cf8 nid=0x6d8 waiting on condition
[0x00000000..0x00000000]
"Finalizer" daemon prio=9 tid=0x009c81a8 nid=0x17c in Object.wait() [0x0abef000.
.0x0abefc64]
at java.lang.Object.wait(Native Method)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
- locked <0x02f82798> (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=10 tid=0x009c6cb8 nid=0xa6c in Object.wait() [0x
0abaf000..0x0abafce4]
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 <0x02f82818> (a java.lang.ref.Reference$Lock)
"main" prio=5 tid=0x00236e80 nid=0x6dc in Object.wait() [0x0006f000..0x0006fc38]
at java.lang.Object.wait(Native Method)
- waiting on <0x02f996d0> (a java.lang.Object)
at java.lang.Object.wait(Object.java:474)
at org.apache.derby.impl.drda.NetworkServerControlImpl.blockingStart(Net
workServerControlImpl.java)
- locked <0x02f996d0> (a java.lang.Object)
at org.apache.derby.impl.drda.NetworkServerControlImpl.executeWork(Netwo
rkServerControlImpl.java)
at org.apache.derby.drda.NetworkServerControl.main(NetworkServerControl.
java)
"VM Thread" prio=10 tid=0x009c4308 nid=0x740 runnable
"VM Periodic Task Thread" prio=10 tid=0x009d44f8 nid=0xa64 waiting on condition
> With Network Server Database hangs after some time with many connections
> executing prepareStatement()
> -----------------------------------------------------------------------------------------------------
>
> Key: DERBY-389
> URL: http://issues.apache.org/jira/browse/DERBY-389
> Project: Derby
> Type: Bug
> Components: JDBC, Network Server
> Versions: 10.1.1.0, 10.2.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Critical
> Attachments: javacore.20050622.135027.2491.txt
>
> Rajesh found this issue in running Network Server system tests for the 10.1
> release candidate
> While running the Network Server system test with 210 clients,
> the Network Server and all the clients hangs after some time.
> A Ctrl+\ on the Network Server shows that upto 180 threads
> waiting on the PreparedStatements to compile and comes from the
> embedded engine. The following is the stack trace from the java
> dump.
> 3XMTHREADINFO "DRDAConnThread_181" (TID:1007C998,
> sys_thread_t:85C4478, state:CW, native ID:4575ABB0) prio=5
> 4XESTACKTRACE at java.lang.Object.wait(Native Method)
> 4XESTACKTRACE at
> java.lang.Object.wait(Object.java(Compiled Code))
> 4XESTACKTRACE at
> org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericSta
> tement.java(Compiled Code))
> 4XESTACKTRACE at
> org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatem
> ent.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.
> prepareInternalStatement(GenericLanguageConnectionContext.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Embe
> dPreparedStatement.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Em
> bedPreparedStatement20.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Em
> bedPreparedStatement30.java)
> 4XESTACKTRACE at
> org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver3
> 0.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Embe
> dConnection.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Embe
> dConnection.java)
> 4XESTACKTRACE at
> sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
> 4XESTACKTRACE at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
> AccessorImpl.java(Compiled Code))
> 4XESTACKTRACE at
> java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> 4XESTACKTRACE at
> org.apache.derby.impl.drda.DRDAStatement.prepareStatementJDBC3(D
> RDAStatement.java)
> 4XESTACKTRACE at
> org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.j
> ava)
> 4XESTACKTRACE at
> org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDASta
> tement.java(Compiled Code))
> 4XESTACKTRACE at
> org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDACon
> nThread.java(Compiled Code))
> 4XESTACKTRACE at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDACo
> nnThread.java(Compiled Code))
> 4XESTACKTRACE at
> org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.jav
> a)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
