Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
5.8.13, 5.9.7, 5.9.12
-
6
-
Severity 2 - Major
-
1
-
Description
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
- Remove a large space
- Open up Confluence on another tab
- Click on Create (You may stuck at this point)
- Type in anything
- Publish
- You may ran into a system error or it will load indefinitely.
Attachments
Issue Links
- relates to
-
-
- Closed
-
- mentioned in
-
Page Loading...