hitcount estimation degeneration when upgrading MIS 19.1.2 (fameflower) -> MIS 19.2.0-SNAPSHOT (RMB30)

mikhail.fokanov oleksii-popov this ticket is created to track the work Mikhail is doing on bugfest with sduvvuri

cboerema charlotte marcjohnson

Problem

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:
ANALYZE fs09000000_mod_inventory_storage.instance;
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.

Documentation:

• Speadsheet: https://docs.google.com/spreadsheets/d/1ergJ7jDHdLbD_noWsL-ZdtVzB2NiiIPaCcUeO4ZFLZw/edit#gid=0