Uploaded image for project: '[Read Only] - Hippo Repository'
  1. [Read Only] - Hippo Repository
  2. REPO-1216

Locked table makes CMS unresponsive

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Top
    • Resolution: Fixed
    • 2.26.14, 2.28.00
    • CMS-10.0-GA, 2.28.02
    • None

    Description

      Reproduced with Repository stampede test:
      1) Checkout & build the Repository project
      2) Go to the test folder and run:
      mvn test -Dtest=StampedeTest -Pclusternode1 -Dstampede.minutes=1 -Dstampede.threads=5

      java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
      at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)
      at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
      at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
      at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
      at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:518)
      at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:313)
      at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:294)
      at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:290)
      at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:559)
      at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:290)
      at org.apache.jackrabbit.core.journal.DatabaseJournal$DatabaseRevision.set(DatabaseJournal.java:834)
      at org.apache.jackrabbit.core.cluster.ClusterNode.setRevision(ClusterNode.java:872)
      at org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel.updateCommitted(ClusterNode.java:703)
      at org.hippoecm.repository.jackrabbit.HippoSharedItemStateManager$DocumentChangeNotifyingEventChannelDecorator.updateCommitted(HippoSharedItemStateManager.java:273)

      Attachments

        1. java-deadlock-thread-dump.txt
          71 kB
          Ate Douma

        Issue Links

          Activity

            People

              Unassigned Unassigned
              abanck Arent-Jan Banck (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: