Uploaded image for project: 'mod-authtoken'
  1. mod-authtoken
  2. MODAT-51

investigate potential mod-authtoken performance issue

    XMLWordPrintable

Details

    • Task
    • Status: Blocked (View Workflow)
    • P2
    • Resolution: Unresolved
    • None
    • None
    • CP: sprint 73, CP: sprint 74
    • 2
    • Core: Platform

    Description

      While looking into checkin/out slowness in BugFest3.2-2019, it was noticed that some mod-authtoken API calls contributed a lot to that. See below Okapi log for checkout/in. Only the calls above 10ms are shown.

      1874519	mod-circulation-16.7.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation/circulation/check-out-by-barcode
358730	mod-circulation-16.7.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation/circulation/rules/notice-policy?item_type_id=1a54b431-2e4f-452d-9cae-9cee66c9a892&loan_type_id=d9ee9741-fbc4-413d-ab22-1093642f8860&patron_type_id=4a34b923-2f07-41e9-97db-0224ceb5410c&shelving_location_id=0a230486-952d-429b-976d-7aaa6d34252a
260148	mod-notify-2.3.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-notify/patron-notice
253148	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/circulation-rules-storage
241405	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/users?query=barcode%3D%3D%22560702-8452%22&limit=1&offset=0
218893	mod-circulation-16.7.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation/circulation/rules/loan-policy?item_type_id=1a54b431-2e4f-452d-9cae-9cee66c9a892&loan_type_id=d9ee9741-fbc4-413d-ab22-1093642f8860&patron_type_id=4a34b923-2f07-41e9-97db-0224ceb5410c&shelving_location_id=0a230486-952d-429b-976d-7aaa6d34252a
181341	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/instance-storage/instances/567634da-effe-498d-9293-72dfa1142efe
169896	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/item-storage/items?query=barcode%3D%3D%221202328307%22&limit=1&offset=0
159011	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/circulation-rules-storage
96671	mod-calendar-1.6.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-calendar/calendar/periods/db222815-8557-490a-aae7-e2c19d7e5dce/calculateopening?requestedDate=2019-12-19
11655	mod-inventory-storage-17.0.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-inventory-storage/item-storage/items/11687990-c7a7-4436-af86-be855d5b3fe9
11107	mod-circulation-storage-9.3.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation-storage/loan-storage/loans
11079	mod-users-15.6.2	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-users/groups?query=id%3D%3D%28%224a34b923-2f07-41e9-97db-0224ceb5410c%22%29&limit=2147483647&offset=0

      1915013	mod-circulation-16.7.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation/circulation/check-in-by-barcode
437124	mod-circulation-16.7.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation/circulation/rules/notice-policy?item_type_id=1a54b431-2e4f-452d-9cae-9cee66c9a892&loan_type_id=d9ee9741-fbc4-413d-ab22-1093642f8860&patron_type_id=503a81cd-6c26-400f-b620-14c08943697c&shelving_location_id=a874ce9f-5b85-48fe-a3d0-d1fe5178579a
312691	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/circulation-rules-storage
226269	mod-circulation-16.7.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation/circulation/rules/notice-policy?item_type_id=1a54b431-2e4f-452d-9cae-9cee66c9a892&loan_type_id=d9ee9741-fbc4-413d-ab22-1093642f8860&patron_type_id=4a34b923-2f07-41e9-97db-0224ceb5410c&shelving_location_id=a874ce9f-5b85-48fe-a3d0-d1fe5178579a
217685	mod-notify-2.3.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-notify/patron-notice
177439	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/circulation-rules-storage
166800	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/instance-storage/instances/511d9ac6-50f1-4564-83c1-33d427477674
12359	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/users?query=barcode%3D%3D%22560702-8452%22&limit=1&offset=0
11438	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/users/a058f28f-80ac-4994-add6-e4d02fc238fe
11299	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/loan-storage/loans?query=status.name%3D%3D%22Open%22+and+itemId%3D%3D%22a4bd96a8-e7c2-427f-b168-ff671f7f5c17%22&limit=1&offset=0
11246	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/scheduled-notice-storage/scheduled-notices?query=requestId%3D%3D%22101da631-c1cc-414c-877b-01e8f22b56a6%22&offset=0
11139	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/users/a7f483c5-8cd4-46cf-9a56-1430ec2514cc
11026	mod-authtoken-2.2.1	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-authtoken/service-points/28d0257b-ea12-4467-851b-c5b1989b724a
10202	mod-circulation-storage-9.3.0	http://pvt.lb.bf32.folio-eis.eu-central-1:8051/mod-circulation-storage/request-storage/requests?query=itemId%3D%3D%22a4bd96a8-e7c2-427f-b168-ff671f7f5c17%22+and+status%3D%3D%28%22Open+-+Awaiting+pickup%22+or+%22Open+-+Not+yet+filled%22+or+%22Open+-+In+transit%22%29+sortBy+position%2Fsort.ascending&limit=1000&offset=0

      TestRail: Results

        Attachments

          1. 1-check-in.pdf
            26 kB
          2. 1-check-out.pdf
            30 kB
          3. 1i-check-in.pdf
            27 kB
          4. 1i-check-out.pdf
            32 kB
          5. checkout-adam-local.log
            6 kB

          Issue Links

            blocks

            Task - A task that needs to be done. CIRC-448 investigate and verify backend API performance issues for UICHKIN-111

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

            Sub-task - The sub-task of the issue CIRC-453 analyze circulation/requests and circulation/loans

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

            Task - A task that needs to be done. FOLIO-2296 enrich perf circulation data to match BugFest q3.2

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

            Task - A task that needs to be done. MODAT-49 Two caches for permissionsForUser and expandPermissions

            • 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. MODAT-50 Does not pass X-Okapi-Request-Id

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

            Task - A task that needs to be done. MODAT-80 SPIKE: investigate authentication performance optimizations

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

            Task - A task that needs to be done. MODAT-83 SPIKE: investigate authentication performance optimizations continued.

            • 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. MODPERMS-64 Expanded permissions causing stack overflow preventing login

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

            Task - A task that needs to be done. MODPERMS-67 verify and reduce the cost of expanding permissions

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

            New Feature - New feature requests OKAPI-770 PoC: Okapi GET and HEAD cache

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Umbrella - OKAPI-806 Caching layer in Okapi

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Open

            Activity

              People

                Unassigned Unassigned
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:

                  TestRail: Runs

                    TestRail: Cases