GET tags can take up to 9 seconds to respond

Description

Observed
GET https://okapi-bugfest-eu-central-1.folio.ebsco.com/tags can take up to 9 seconds to respond

Steps to Repro:

1. From bugfest https://bugfest.folio.ebsco.com
2. Logged in as folio user
3. Got to eHoldings
4. Search for packages
5. Select a package which will open in 3rd panel
6. Observe ... while tags dropdown is loading
7. From Chrome dev tool window - observe that Request can take up to 9 seconds to return (see attached)
Note – the slowness is sporadic – often time will see approximately 300ms for response. May need to search and view package details a few times before slow response is observed

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

6
  • 28 May 2019, 03:44 PM
  • 28 May 2019, 03:44 PM
  • 28 May 2019, 03:44 PM
  • 28 May 2019, 03:44 PM
  • 28 May 2019, 03:44 PM
  • 28 May 2019, 02:54 PM

Checklist

hide

TestRail: Results

Activity

Show:

Carole Godfrey February 26, 2020 at 6:30 PM
Edited

This issue is from May 2019 – I didn't see performance issues with a quick test of this functionality on current edelweiss bugfest environment

There's been so many changes since then – there were some back end performance improvements for tags in eHoldings
https://folio-org.atlassian.net/browse/MODKBEKBJ-256

– I think this is ok to close? unless there is still reported performance issues in this area that I havent reproduced

Khalilah Gambrell February 26, 2020 at 2:04 PM

, can you respond to 's question.

Cate Boerema February 26, 2020 at 1:03 PM

I don't think this is assigned to the right team. It's about performance, which is usually Core Platform () but it is specifically about eHoldings which is Spitfire (). Can you help me get this assigned to the correct team?

Hongwei Ji May 28, 2019 at 3:46 PM

Okapi logs shows the slow entry below. Dig this deeper shows that there were multiple mod-permissions calls and generated heavy queries that overloaded database CPU. See attached logs files and database slow queries and CPU usage diagram.

14:40:13 INFO ProxyContext :209 499709/tags RES 202 8493545us mod-authtoken-2.1.0 http://pvt.lb.bf.folio-eis.eu-central-1:8051/mod-authtoken/tags
Duplicate

Details

Assignee

Reporter

Priority

Development Team

Prokopovych

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 28, 2019 at 3:01 PM
Updated June 3, 2020 at 4:39 PM
Resolved February 26, 2020 at 7:00 PM
TestRail: Cases
TestRail: Runs