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

Add indices for the job_executions table in srm

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      Folijet Sprint 112
    • Story Points:
      1
    • Development Team:
      Folijet
    • Release:
      R1 2021 Bug Fix

      Description

      Overview: Currently in the mod-source-record-manager there is such log: 

      "Apr 19, 2021 9:21:06 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt WARNING: Doing FT search without index for job_executions.jsonb->>'subordinationType', CQL >>> SQL: subordinationType = "" >>> job_executions.jsonb->>'subordinationType' ~ '' Apr 19, 2021 9:21:06 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt..."

       

      Purpose: It seems like there should be added indices

       

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                VRohach Volodymyr Rohach
                Reporter:
                VRohach Volodymyr Rohach
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases