Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-513

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

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      CP: sprint 90
    • Story Points:
      2
    • Development Team:
      Core: Platform
    • Release:
      Q2 2020

      Description

      Mikhail Fokanov Oleksii Popov this ticket is created to track the work Mikhail is doing on bugfest with Sobha Duvvuri

      Cate Boerema Charlotte Whitt Marc Johnson

      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:

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                mikhail.fokanov Mikhail Fokanov
                Reporter:
                jakub Jakub Skoczen
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases