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

Was this helpful?

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