Uploaded image for project: 'mod-source-record-manager'
  1. mod-source-record-manager
  2. MODSOURMAN-537

SPIKE: Slow Queries observed from jobExecutions lookup from DI Landing Page

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Story Points:
      2
    • Development Team:
      Folijet
    • Release:
      R3 2021
    • Affected Institution:
      Cornell

      Description

      Overview:
      The following issue was observed in an Iris HF3 environment (mod-source-record-manager-3.0.9)

      • Data Import Landing Page at times was unresponsive
      • Observe 502 response in chrome developer tools network tab for query for job executions
        `metadata-provider/jobExecutions?query=` (attached image)
      • Execution time is > 2000 ms in many cases
      • Attaching 2 log excerpts with samples of queries (observed in mod-source-record-manager logs)

        TestRail: Results

          Attachments

          1. DI-Landing-Page-RES-502.png
            DI-Landing-Page-RES-502.png
            398 kB
          2. slow-query.txt
            86 kB
          3. slow-query2.txt
            86 kB

            Issue Links

              Activity

                People

                Assignee:
                Nosko Serhii Nosko
                Reporter:
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases