I have upgraded to Fisheye 3.2 and am running on Oracle 11. I am finding that I am having massive row lock contentions with Fisheye. Specifically my issue is with updates to the cru_revision table. I have Fisheye connected to 74 repositories for Crucible reviews.
How could I reduce the "enq: TX - row lock contention"?
Also is it possible to throttle the indexing? I tried deleting FISHEYE_INST/var/cache and it triggered the re-indexing, but all the diff commands it runs and with there being so many revisions..... it is just beating against subversion.
After watching a little, we found out that adding the indexes on foreign keys actually didn't help so we removed those indexes.
This is seen on Oracle 11 and MySQL 5.6.12
After discussions with support, we were able to show the bug to get them to replicate. This affects only LightSCM, Fisheye Native does not have this problem. If you only have a Crucible license, do not upgrade until the bug fix is released
FishEye 3.2 will perform an upgrade of your crucible (ie review) data when it first starts up. This should not take more than 5-10 minutes. Has the row-locking settled down since then ?
You can indeed throttle SVN commands, using the Throttle setting on each repository:
I did see the migration of the users & groups out of the data0.bin; however we had 0 cause we are using Crowd. It did move something out though. Leaving it on over the weekend, it had major row-locking sessions and became stuck. Main culprit being with CRU_REVIEW. We placed an index on all the foreign keys as Sergey suggested. We are waiting to see if that resolved the issue.
We did see the Throttle Connections, but description also says that throttling is not advised in atlassian documentation. Is that just pre-cautionary warning?
Over the next several weeks we'll be sharing some of our Getting Started guides here in the community. Throughout this series of posts, we'd love to hear from customers and non-customers ab...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs