We are seeing imprecise hitcounts reported after upgrading Bugfest from MIS used for Fameflower to the latest MIS snapshot using RMB 30 (which included the harmonisation of hit count between Instance records sorted by title). Most hitcounts are reported as ~37000.
Analyis from Mikhail
I found out that the instance table wan't analysed due to some error during the deployment of the new version of inventory.
Manually running of:
fixes the problem.
But VACUUM with ANALYZE was failing (possibly due to timeout).
But just ANALYZE query is pretty fast, so it completed.
So, as far as I can see, the root cause is that because of changes which was implemented in scope of
RMB-583 during the deployment there is a migration which involves REINDEX and ANALYZE but due to timeout of this procedures the database wasn't completely migrated, but stuck in the kind of inconsistent state and therefore counters are not accurate.