Reviews mix file types, clear inconsistancies in stored diff cache
There is likely an inconsistency between what Crucible thinks is in the stored diff cache and what is actually there. The stored diff cache is in
FISHEYE_INST/var/data/uploads/... and the DB table
cru_revision maps these to paths and revisions via the
In the DB, the contents of the files likely do not match what
Previous scenarios analysed
This problem has been observed when the following conditions occurred:
- two instances of Crucible have been running against the same database, this lead to the incorrect set of values for the
- two backups of Fisheye/Crucible have been restored, where one contained an older set of review caches, and another one a more recent status for the database.
- Make sure that the is a single instance of Fisheye/Crucible connected to the database
Force the reviews to create new cache entries by applying the following SQL to the DB:
update cru_revision set cru_upload_item = null
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Next time a review is viewed, the diffs will be retrieved from your repository and stored again.