Unable to delete review

Still need help?

The Atlassian Community is here for you.

Ask the community


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


The Crucible index may have been out-of-sync with the database


  1. Reindex Crucible at Administration >> Global Settings >> Crucible

  2. Delete the review again

Last modified on Mar 30, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.