Fisheye freezes unexpectedly
Issue SymptomsIf your Fisheye 2.0 or 2.0.1 instance freezes unexpectedly, this could be caused by a known issue with Fisheye and MySQL database technology.
This issue manifests itself in some Fisheye pages returning a server timeout error. To identify the issue, check the Fisheye error log. For this issue, the following output will appear in the error log:
2009-07-15 15:34:45,555 ERROR [btpool0-519] fisheye.app HibernateUtil-commitTransaction - Commit fail msg-0:Could not execute JDBC batch update 2009-07-15 15:34:45,556 ERROR [btpool0-519] fisheye.app HibernateUtil-commitTransaction - Commit fail msg-1:Lock wait timeout exceeded; try restarting transaction 2009-07-15 15:34:45,557 ERROR [btpool0-519] fisheye.app HibernateUtil-commitTransaction - Commit failed rolling back. ... ... Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) ... 163 more
The Fisheye error log can be found under
See the Jira issue for more information.
Until the issue is solved, the suggested course of action is to restart your Fisheye instance. This will return Fisheye to normal operation.
The Fisheye development team is actively working on a solution and this be part of an upcoming point release of Fisheye.
If you require assistance in resolving the problem, please raise a support request under the Fisheye project.