Uploaded image for project: 'Jackrabbit Content Repository'
  1. Jackrabbit Content Repository
  2. JCR-3738

CLONE - Deadlock on LOCAL_REVISION table in clustering environment

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.6.2
    • Fix Version/s: None
    • Component/s: clustering
    • Labels:
      None
    • Environment:
      CQ5.6.1 with jackrabbit-core 2.6.2 backed off ibm db2 v10.5

      Description

      Original, cloned description:

      > When inserting a lot of nodes concurrently (100/200 threads) the system hangs generating a deadlock on the LOCAL_REVISION table.
      > There is a thread that starts a transaction but the transaction remains open, while another thread tries to acquire the lock on the table.
      > This actually happen even if there is only a server up but configured in cluster mode.
      > I found that in AbstractJournal, we try to write the LOCAL_REVISION even if we don't sync any record because they're generated by the same journal of the thread running.
      >
      > Removing this unnecessary (to me ) write to the LOCAL_REVISION table, remove the deadlock.

      This might not be the exact same case with this issue. See the attached thread dumps etc. for full details.

        Attachments

        1. threaddumps.zip
          112 kB
          Ankush Malhotra
        2. db-deadlock-info.txt
          5 kB
          Ankush Malhotra
        3. stat-cache.log
          43 kB
          Ankush Malhotra
        4. before-lock.zip
          55 kB
          Ankush Malhotra
        5. extended-log-with-dumps.txt
          14 kB
          Benjamin Papez

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                amalhotr Ankush Malhotra
              • Votes:
                2 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: