Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-89

Lookups in SRS for records by Instance UUID are timing out, part 1

    XMLWordPrintable

Details

    • EPAM BatchLoader Sprint 31, EPAM BatchLoader Sprint 32
    • 1
    • Folijet

    Description

      When we had only 20 000 records in the Five colleges tenant, lookups by Instance UUID where fast, both through the UI, the API and also through the database. Now, with 7.6 million records, the requests are timing out.

      I made test loads with 20 000 records using the exact same process as with the 7.6 million, so I am pretty certain that it is the number of records that is the cause for this.

      Throught the ui:
      Nothing happens

      Through the API:
      A request to baseUrl/source-storage/records/910890c8-3b58-4381-9ba8-725432ded07a?identifier=INSTANCE
      gives me a HTTP 504 after 6minutes 40 seconds
      Through the Database:

      SELECT fs00001006_mod_source_record_storage.get_record_by_instance_id('910890c8-3b58-4381-9ba8-725432ded07a');
      

      gives strange responses :

      or

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Kateryna Senchenko Kateryna Senchenko
                ttolstoy Theodor Tolstoy
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases