Derby
  1. Derby
  2. DERBY-4129

jvm level Deadlock between 2 threads accessing the same connection

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: None
    • Component/s: JDBC, SQL, Store
    • Environment:
      Linux 2.6.18-53.1.14.el5 #1 SMP Wed Mar 5 11:36:49 EST 2008 i686 i686 i386 GNU/Linux
    • Urgency:
      Normal
    • Bug behavior facts:
      Crash, Seen in production

      Description

      Threads working with embedded derby get deadlocked.
      Thread dump:

      Found one Java-level deadlock:
      =============================
      "http-8080-13":
      waiting to lock monitor 0x09d1a37c (object 0x9560fcd8, a org.apache.derby.impl.store.raw.data.BaseContainerHandle),
      which is held by "dwc.ma.MAJobsManager:dwc.ma.MAManager"
      "dwc.ma.MAJobsManager:dwc.ma.MAManager":
      waiting to lock monitor 0x09d1a57c (object 0x93da0180, a org.apache.derby.impl.store.raw.data.StoredPage),
      which is held by "http-8080-13"

      Java stack information for the threads listed above:
      ===================================================
      "http-8080-13":
      at java.util.Observable.deleteObserver(Observable.java:78)

      • waiting to lock <0x9560fcd8> (a org.apache.derby.impl.store.raw.data.BaseContainerHandle)
        at org.apache.derby.impl.store.raw.data.BasePage.releaseExclusive(Unknown Source)
      • locked <0x93da0180> (a org.apache.derby.impl.store.raw.data.StoredPage)
        at org.apache.derby.impl.store.raw.data.CachedPage.releaseExclusive(Unknown Source)
        at org.apache.derby.impl.store.raw.data.StoredPage.releaseExclusive(Unknown Source)
        at org.apache.derby.impl.store.raw.data.BasePage.unlatch(Unknown Source)
        at org.apache.derby.impl.store.raw.data.OverflowInputStream.fillByteHolder(Unknown Source)
        at org.apache.derby.impl.store.raw.data.BufferedByteHolderInputStream.read(Unknown Source)
        at java.io.DataInputStream.readFully(DataInputStream.java:176)
        at java.io.DataInputStream.readFully(DataInputStream.java:152)
        at org.apache.derby.iapi.types.SQLBinary.readExternal(Unknown Source)
        at org.apache.derby.iapi.types.SQLBinary.getValue(Unknown Source)
        at org.apache.derby.iapi.types.SQLBinary.getBytes(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.getBytes(Unknown Source)
        at dwc.ma.MAOrderProcessor.loadData(MAOrderProcessor.java:147)
      • locked <0x91f211b0> (a java.lang.Object)
      • locked <0x91f6a068> (a dwc.ma.MAOrderProcessor)
        at dwc.ma.MAOrderProcessor.generateBundlesForUser(MAOrderProcessor.java:538)
      • locked <0x91f6a068> (a dwc.ma.MAOrderProcessor)
        at dwc.ma.MARequestProcessor$HBundleRequest.process(MARequestProcessor.java:239)
        at dwc.ma.MARequestProcessor.processRequest(MARequestProcessor.java:39)
        at dwc.ma.doProc.doPost(doProc.java:92)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:595)
        "dwc.ma.MAJobsManager:dwc.ma.MAManager":
        at org.apache.derby.impl.store.raw.data.BasePage.releaseExclusive(Unknown Source)
      • waiting to lock <0x93da0180> (a org.apache.derby.impl.store.raw.data.StoredPage)
        at org.apache.derby.impl.store.raw.data.CachedPage.releaseExclusive(Unknown Source)
        at org.apache.derby.impl.store.raw.data.StoredPage.releaseExclusive(Unknown Source)
        at org.apache.derby.impl.store.raw.data.BasePage.update(Unknown Source)
        at java.util.Observable.notifyObservers(Observable.java:142)
        at java.util.Observable.notifyObservers(Observable.java:98)
        at org.apache.derby.impl.store.raw.data.BaseContainerHandle.informObservers(Unknown Source)
        at org.apache.derby.impl.store.raw.data.BaseContainerHandle.close(Unknown Source)
      • locked <0x9560fcd8> (a org.apache.derby.impl.store.raw.data.BaseContainerHandle)
        at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.close(Unknown Source)
        at org.apache.derby.impl.store.access.conglomerate.GenericController.close(Unknown Source)
        at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.closeForEndTransaction(Unknown Source)
        at org.apache.derby.impl.store.access.RAMTransaction.closeControllers(Unknown Source)
        at org.apache.derby.impl.store.access.RAMTransaction.commit(Unknown Source)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doCommit(Unknown Source)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userCommit(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.commit(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.commitIfAutoCommit(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.commitIfAutoCommit(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.resultSetClosing(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.close(Unknown Source)
      • locked <0x91f0b7d0> (a org.apache.derby.impl.jdbc.EmbedConnection30)
        at dwc.ma.MAStatsProcessor$UserStatsBundlesProc.run(MAStatsProcessor.java:117)
        at dwc.ma.MAJobsManager$Runner.run(MAJobsManager.java:84)
      • locked <0x91fce338> (a java.util.LinkedList)
        at java.lang.Thread.run(Thread.java:595)

      Found 1 deadlock.

      1. threaddump.txt
        11 kB
        Knut Anders Hatlen
      2. BlobDeadlock.java
        2 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Unassigned
              Reporter:
              Malchenko Inna
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development