Fisheye freezes unexpectedly
Issue Symptoms
If 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 FISHEYE_INST/var/log/fisheye-error.log.YYYY-MM-DD .
See the Jira issue for more information.
Workaround
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.
Requesting Support
If you require assistance in resolving the problem, please raise a support request under the Fisheye project.
Last modified on Dec 13, 2018
Powered by Confluence and Scroll Viewport.