Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Investigate search without indexes for mod-circulation-storage

Description

Performing tests for Check-In/ Check-Out with DB read-write split disabled and enabled warnings about search without indexes were observed.

  • 14:40:58 [893005/circulation;312636/request-storage] [fs09000000] [9eb67301-6f6e-468f-9b1a-6134dc39a684] [mod_circulation_storage] WARN  CQL2PgJSON           Doing FT search without index for request.jsonb->>'pickupServicePointId', CQL >>> SQL: pickupServicePointId = 7068e104-aa14-4f30-a8bf-71f71cc15e07 >>> get_tsvector(f_unaccent(request.jsonb->>'pickupServicePointId')) @@ tsquery_phrase(f_unaccent('7068e104-aa14-4f30-a8bf-71f71cc15e07'))

  • 14:40:58 [863718/circulation;693082/request-storage] [fs09000000] [9eb67301-6f6e-468f-9b1a-6134dc39a684] [mod_circulation_storage] WARN  CQL2PgJSON           Doing LIKE search without index for request.jsonb->>'instanceId', CQL >>> SQL: instanceId == c34b9e0d-4f6b-4e15-aafa-4f314a241dc9 >>> lower(f_unaccent(request.jsonb->>'instanceId')) LIKE lower(f_unaccent('c34b9e0d-4f6b-4e15-aafa-4f314a241dc9'))

  • 14:40:58 [487959/circulation;934846/actual-cost-record-storage] [fs07000001] [] [mod_circulation_storage] WARN  CQL2PgJSON           Doing SQL query without index for actual_cost_record.jsonb->>'expirationDate', CQL >>> SQL: expirationDate < "2022-12-05T14:40:58.310708Z[Etc/UTC]" >>> actual_cost_record.jsonb->>'expirationDate' <'2022-12-05T14:40:58.310708Z[Etc/UTC]'

Environment:

https://ptf-nolana-2.int.aws.folio.org/

ncp3

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2
  • 08 Dec 2022, 11:38 AM
  • 08 Dec 2022, 11:38 AM

Checklist

hide

TestRail: Results

Activity

Show:

Roman Barannyk September 8, 2023 at 12:49 PM

The warnings mentioned in the description are not reproducible now

Martin Tran April 26, 2023 at 11:47 AM

  If mod-circulation sends the wrong request, should a Jira be created for this problem?

Roman Barannyk March 8, 2023 at 7:08 PM
Edited

'instanceId' and 'expirationDate' were added in scope of https://folio-org.atlassian.net/browse/CIRCSTORE-402#icft=CIRCSTORE-402. Index 'pickupServicePointId' already exists in DB schema, but it doesn't work because mod-circulation sends the wrong request: requesterId==id and pickupServicePointId=id, but it should be pickupServicePointId==id

Ann-Marie Breaux February 14, 2023 at 6:03 AM

Hi There's no dev team on this bug, but I think? it should be Vega. Could you review and adjust if it should go to some other team? Thank you!

Duplicate

Details

Assignee

Reporter

Labels

Priority

Development Team

Vega

Release

Quesnelia (R1 2024)

RCA Group

Not a bug

Affected releases

Nolana (R3 2022)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created December 8, 2022 at 10:22 AM
Updated January 10, 2024 at 2:43 PM
Resolved September 8, 2023 at 2:17 PM
TestRail: Cases
TestRail: Runs

Flag notifications