Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-677

Close PostgreSQL connection after invalid CQL failure

    XMLWordPrintable

Details

    • CP: sprint 95
    • 2
    • Core: Platform
    • Q2 2020 Hot Fix #2

    Description

      Overview
      This issue was observed while running an export job on bugfest goldenrod and we are able to replicate in multiple environments(testing/snapshot).
      If the below query is run consecutively for 3-4 times, this makes the module un-responsive and eventually 

      curl --location --request GET 'https://okapi-bugfest-goldenrod.folio.ebsco.com:443/item-storage/items?query=()&limit=10' \ \
--data-raw '{{userPermissions}}'

      Response: 

      org.folio.cql2pgjson.exception.QueryValidationException: org.z3950.zing.cql.CQLParseException: expected index or term, got ')'

      The above reponse is returned immediately but if the same query is run 3-4 times the module stops responding.

      TestRail: Results

        Attachments

          Issue Links

            is cloned by

            Bug - A problem which impairs or prevents the functions of the product. MODINV-330 electronicAccess =/@linkText=pdf query cause module to be non responsive

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

            Task - A task that needs to be done. FOLIO-2563 SPIKE: propose prevention of DoS via CQL query

            • 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. FOLIO-2741 login fails due to failure to get /service-points

            • 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. MDEXP-219 Export job with custom mapping profile gets stuck when retrieving data from inventory

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

            Activity

              People

                julianladisch Julian Ladisch
                KVupp Kruthi Vuppala
                Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases