Uploaded image for project: 'perf-testing'
  1. perf-testing
  2. PERF-141

Spike: Investigate inventory-storage mismatch

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: TBD
    • Resolution: Done
    • Labels:
      None
    • Template:
      Standard Bug Write-Up Format
    • Development Team:
      None

      Description

      Overview:

      • In the Inventory app, go to Item and search for all items with Item Status = Checked out. There are at least 1000 records.
      • Go to the database and execute the following count statements:
        select count from fs09000000_mod_inventory_storage.item;
        select count from fs09000000_mod_inventory_storage.item where jsonb->'status'->>'name' = 'Available';
        If nothing has changed in the DB the results for these should be the same, 8,933,578 records. This means that all records have status "Available", which is not the same as what the UI shows, and found.
      • You can also look up a checked-out record found in the Inventory page in the database. The record in the database shows "Available". Again, this is a mismatch, inconsistent with what is seen on the UI.

      Investigate why this problem happening. Is it because of the PTF environment or because of a bug somewhere in the system?

      *mod-inventory-storage 16.1.3
      *mod-inventory-storage 19.4.4
      *mod-circulation 19.2.7
      *mod-circulation-storage 12.1.4
      *okapi 4.3.3

        Attachments

          Activity

            People

            Assignee:
            varunjavalkar Varun Javalkar
            Reporter:
            mtraneis Martin Tran
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: