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!

[Vanessa Strazdas · Accepted solution]

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.