Uploaded image for project: 'mod-search'
  1. mod-search
  2. MSEARCH-207

Saving large set of UUIDs fails

    XMLWordPrintable

Details

    • Falcon Sprint 126, Falcon Sprint 127
    • 2
    • Falcon
    • R3 2021 Bug Fix

    Description

      Overview:
      The user should be able to save a large number of UUIDs of the records that match the search criteria. In the PostgresSQL implementation the saving suported more than 1M UUIDs. now it seems it errors out for more than 10K records i
      Steps to Reproduce:

      1. In Kiwi bugfest navigate to Inventory and do search that will return more than 10K records, for example filer by language set to German (it will return ~225K records)
      2. Click Action menu and select Save instance UUIDs option

      Expected Results:
      The UUIDs are saved in the Excel file

      Actual Results:
      The saving errors out with the message:
      HTTP 502 Service temporarily unavailable.

      Additional Information:

      I run the same query multiple times (language set to Ukrainian or Belarussian) that returned 14811 records. While trying to save the UUIDs, the request sometimes succeeded and sometimes returned 502 status code:

      TestRail: Results

        Attachments

          1. ids-1637108525831.json
            8.15 MB
          2. image (1).png
            image (1).png
            252 kB
          3. image-2021-11-16-20-10-45-981.png
            image-2021-11-16-20-10-45-981.png
            304 kB
          4. screenshot-1.png
            screenshot-1.png
            225 kB
          5. screenshot-2.png
            screenshot-2.png
            184 kB
          6. screenshot-3.png
            screenshot-3.png
            194 kB
          7. screenshot-4.png
            screenshot-4.png
            244 kB
          8. screenshot-5.png
            screenshot-5.png
            229 kB
          9. screenshot-6.png
            screenshot-6.png
            291 kB
          10. SearchInstanceUUIDs2021-11-16T19_18_18-05_00.csv
            15.62 MB

          Issue Links

            blocks

            Bug - A problem which impairs or prevents the functions of the product. MDEXP-470 Export fails after /data-export/expire-jobs endpoint invocation

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            defines

            New Feature - New feature requests UXPROD-3200 mod-search maintenance - Kiwi release

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            has to be done before

            Task - A task that needs to be done. MSEARCH-226 Release v1.5.2 (R3 Kiwi Bugfix)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. MSEARCH-239 Release v1.5.3 (R3 Kiwi Bugfix)

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            relates to

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MSEARCH-93 Resolve discrepancy between search results and getting UUIDs of the records matching search criteria

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                OleksiiKuzminov Oleksii Kuzminov
                magdaz Magda Zacharska
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases