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

            blocks

            Task - A task that needs to be done. MODSOURCE-90 Release v3.0.1

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

            New Feature - New feature requests UXPROD-2076 NFR: Data Import (Batch Importer for Bib Acq) Q4 2019 Technical, NFR, & Misc bug work

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

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-92 Lookups in SRS for records by Instance UUID are timing out, part 2

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

            Bug - A problem which impairs or prevents the functions of the product. MODOAIPMH-82 ListRecords requests times out for Five Colleges and Alabama

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

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-85 Timeout when making GET requests to /source-storage/sourceRecords, part 1

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

            Bug - A problem which impairs or prevents the functions of the product. MODSOURCE-91 Timeout when making GET requests to /source-storage/sourceRecords, part 2

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

            Activity

              People

                Kateryna Senchenko Kateryna Senchenko
                ttolstoy Theodor Tolstoy (One-Group.se)
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases