[FOLIO-2044] GET tags can take up to 9 seconds to respond Created: 28/May/19  Updated: 03/Jun/20  Resolved: 26/Feb/20

Status: Closed
Project: FOLIO
Components: None
Affects versions: None
Fix versions: None

Type: Bug Priority: P3
Reporter: Carole Godfrey Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: bugfest_q2.1.2019, performance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: PNG File Screen Shot 2019-05-28 at 10.40.20 AM.png     PNG File folio-2044-db-graph.png     Text File folio-2044-mod-authtoken.log     Text File folio-2044-mod-permissions.log     Text File folio-2044-okapi.log     Text File folio-2044-slow-queries.log    
Issue links:
Relates
relates to FOLIO-2039 Research perf related tickets from Q2... Closed
Sprint:
Development Team: Prokopovych

 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



 Comments   
Comment by Hongwei Ji [ 28/May/19 ]

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
Comment by Cate Boerema (Inactive) [ 26/Feb/20 ]

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

Comment by Khalilah Gambrell [ 26/Feb/20 ]

Carole Godfrey, can you respond to Cate Boerema's question.

Comment by Carole Godfrey [ 26/Feb/20 ]

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? Khalilah GambrellCate Boerema unless there is still reported performance issues in this area that I havent reproduced

Generated at Thu Feb 08 23:17:47 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.