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

Saving large set of UUIDs fails

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      Falcon Sprint 126, Falcon Sprint 127
    • Story Points:
      2
    • Development Team:
      Falcon
    • Release:
      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

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases