Barcode search takes 30-40 seconds to execute

Description

Overview: While testing for Bug Fest Q3.1 I executed a barcode search in Inventory. I expected the result to come up very quickly. The search took 30 seconds to retrieve the correct item.

Steps to reproduce:

  1. Login to FOLIO bugfest https://bugfest.folio.ebsco.com/ (username: folio, password: folio)

  2. Go to Inventory

  3. Do any search on an existing barcode

Expected result: I get my search result quickly.

Actual result: It took 40 seconds to retrieve the correct item record.
CW: Screencast (7/30/2019): https://screencast.com/t/0BNurahNgUm

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Charlotte Whitt August 12, 2019 at 5:37 PM

Manual test in FOLIO Bugfest environment, version @folio/inventory 1.11.1, using Chrome.

I searched for Item barcode: 1203083709; and got my search result instantly All is good, and I'll close the ticket.

CC:

Jakub Skoczen August 9, 2019 at 9:18 AM

The underlyig problem has been fixed and this issues should be reviewed in the bugfest environment.

Charlotte Whitt August 2, 2019 at 7:08 AM

yes, that's actually better. Thanks

Jakub Skoczen August 2, 2019 at 7:04 AM

thanks, I actually re-opened this and BLOCKED it on MODINVSTOR-292 instead. I think it makes more sense since this is a front-end ticket.

Charlotte Whitt August 2, 2019 at 6:55 AM
Edited

Okay .
I have added and myself as watchers of MODINVSTOR-292.

Here chat from yesterday in the #bug-fest channel:
Patty Wanninger 10:56 PM
I'm just having a terrible time with the bugfest environment. Lots of freezing, very slow or no response. I just did a user search and the it said there were 371 responses but the infinite scroll wouldn't work to show me them.

Hongwei Ji 11:11 PM
I looked at the database load for the last hour. The peak is caused by searching instance by item barcode. I would suggest to avoid doing that if possible since we know it is slow and puts load on database.

Done

Details

Assignee

Reporter

Tester Assignee

Priority

Development Team

Core: Platform

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created July 29, 2019 at 5:38 PM
Updated August 12, 2019 at 5:37 PM
Resolved August 12, 2019 at 5:37 PM
TestRail: Cases
TestRail: Runs