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

    • Standard Bug Write-Up Format
    • 2
    • Folijet Support
    • R3 2021
    • 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

                Nosko Serhii Nosko
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases