Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-389

With Network Server Database hangs after some time with many connections executing prepareStatement()

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 10.1.1.0, 10.2.1.6
    • 10.1.1.0, 10.2.1.6
    • JDBC, Network Server
    • None

    Description

      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)

      Attachments

        1. RTINFO.txt
          12 kB
          Rajesh Kartha
        2. javacore.20050623.150509.22394.txt
          341 kB
          Rajesh Kartha
        3. javacore.20050622.135027.2491.txt
          902 kB
          Katherine Marsden
        4. derby389.diff
          1 kB
          Katherine Marsden
        5. derby.log
          1.34 MB
          Rajesh Kartha

        Activity

          People

            kmarsden Katherine Marsden
            kmarsden Katherine Marsden
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: