Unable to delete review
Symptoms
Unable to delete review with the following appears in the fisheye-dbdebug-*.log
:
2012-09-06 10:43:51,630 WARN [notificationManager1] util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - SQL Error: 1205, SQLState: 41000
2012-09-06 10:43:51,630 ERROR [notificationManager1] util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - Lock wait timeout exceeded; try restarting transaction
2012-09-06 10:43:51,631 ERROR [notificationManager1] def.AbstractFlushingEventListener AbstractFlushingEventListener-performExecutions - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:262)
...
Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
...
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
Cause
The Crucible index may have been out-of-sync with the database
Resolution
Reindex Crucible at Administration >> Global Settings >> Crucible
Delete the review again
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.