db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-389) With Network Server Database hangs after some time with many connections executing prepareStatement()
Date Thu, 23 Jun 2005 19:39:10 GMT
    [ 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


Mime
View raw message