Unable to create page while large space removal is running

XMLWordPrintable

    • 6
    • Severity 2 - Major
    • 1

      Confluence will ran into a system error or load indefinitely when a large space removal is running behind.

      The following error shown in the stacktrace :

      Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
	at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2436)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2391)
	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
	at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
	at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:510)

      Environment Info

      Database : MySQL ver 5.5 and 5.6.31
      Confluence : 5.9.7 and 5.9.12
      Transaction isolation level: READ-COMMITED
      InnoDB Lock Wait Timeout: 500 (ms)
      hibernate.c3p0.max_size : 50 or 75
      Space content : 10,000 to 20,000 pages

      Steps to replicate

      1. Remove a large space
      2. Open up Confluence on another tab
      3. Click on Create (You may stuck at this point)
      4. Type in anything
      5. Publish
      6. You may ran into a system error or it will load indefinitely.

            Assignee:
            Unassigned
            Reporter:
            Jonathan Soo
            Votes:
            6 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved: