After deleting a fisheye review manually, it still has residual references

Mark Staroska

We had a review start causing fisheye to spike in processing due to larges file in the review, so we followed the manual process (https://confluence.atlassian.com/fishkb/deleting-hung-reviews-manually-278072632.html) to delete the review from our mysql database.  This seemed to work, and fisheye seemed to recover and process normally once it was deleted.

However, users that had that now deleted review in their Inbox still see an numeric indicator of a review, even though their inbox is empty. 

empty inbox.png

Are there more tables that need to be cleaned, or a way for a user to re-index their inbox?

Thanks for any assistance!

empty inbox.png

Vanessa Strazdas

Go to Administration -> Global Settings -> Crucible.  Under Crucible Index Maintenance, click Re-index.  This will rebuild each user's inbox and other review stats.  Users can still access reviews while the re-index happens and it's pretty quick.