[Bug 42765] New: Add pagination to the checkouts table
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765 Bug ID: 42765 Summary: Add pagination to the checkouts table Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: kyle@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle@bywatersolutions.com The checkouts table on circulation.pl and moremember.pl works fine for most patrons, but causes issues for patrons with hundreds of checkouts, especially if the table is set to load automatically. In practice, we've seen a patron with 200ish checkouts take about 10 seconds to load the table. If the patron is then checking out another stack of items ( let's say 20 ) it's possible to lock up the entire server. This happens because those svc/checkouts continue to stack up and use up workers. A fast enough librarian will be able to get to the point where most if not all workers are calling svc/checkouts. If it takes 10 seconds to resolve the api call, and 3 seconds to check out an item, the process will plateau at 4 workers being dedicated to just calling svc/checkouts for just that patron. Setting LoadCheckoutsTableDelay to a non-zero value works around the symptom, since the next scan's page reload cancels the pending request before it fires, but the real fix is to make the table server-side so it only fetches the recent subset of checkouts by default. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765 Kyle M Hall (khall) <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |kyle@bywatersolutions.com |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765 Kyle M Hall (khall) <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765 --- Comment #1 from Kyle M Hall (khall) <kyle@bywatersolutions.com> --- Created attachment 202830 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=202830&action=edit Bug 42765: Add pagination to the checkouts table The checkouts table on circulation.pl and moremember.pl works fine for most patrons, but causes issues for patrons with hundreds of checkouts, especially if the table is set to load automatically. In practice, we've seen a patron with 200ish checkouts take about 10 seconds to load the table. If the patron is then checking out another stack of items ( let's say 20 ) it's possible to lock up the entire server. This happens because those svc/checkouts continue to stack up and use up workers. A fast enough librarian will be able to get to the point where most if not all workers are calling svc/checkouts. If it takes 10 seconds to resolve the api call, and 3 seconds to check out an item, the process will plateau at 4 workers being dedicated to just calling svc/checkouts for just that patron. Setting LoadCheckoutsTableDelay to a non-zero value works around the symptom, since the next scan's page reload cancels the pending request before it fires, but the real fix is to make the table server-side so it only fetches the recent subset of checkouts by default. Test Plan: 1) Create or find a patron with many checkouts from the past and from today 2) View the checkouts table from circulation.pl and/or moremember.pl 3) Apply this patch 4) Restart all the things! 5) Reload the page 6) Note the checkouts are now paginated! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42765 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com Status|Needs Signoff |Patch doesn't apply --- Comment #2 from David Nind <david@davidnind.com> --- The patch no longer applies 8-(... Testing notes (using KTD): 1. Set these system prferences as follows: - BatchCheckouts = Allow - BatchCheckoutsValidCategories = select all 2. Batch checkout items to Mary Burton (use the Batch check out section): 39999000011418 39999000001396 39999000000511 39999000001235 39999000001570 39999000001617 39999000008975 39999000009255 39999000011111 39999000011135 39999000003055 39999000003536 39999000000290 39999000000672 39999000005134 39999000000498 39999000000597 39999000000719 39999000000870 39999000001938 39999000001976 39999000003352 39999000004236 39999000004854 39999000004878 39999000006032 39999000006056 39999000006575 39999000006995 39999000007237 39999000011333 3. Update the issue date in the database: - Access the database: koha-mysql kohadev - SQL: update issues set timestamp = "2026-08-03 19:35:15"; - SQL: update issues set issuedate = "2026-08-03 19:35:15"; 4. Batch checkout another lot of items to Mary Burton: 39999000002355 39999000008074 39999000001334 39999000014419 39999000005417 39999000005455 39999000006773 39999000012897 39999000012958 39999000001594 39999000015355 39999000004236 39999000018691 39999000018417 39999000013313 39999000004977 39999000004991 39999000018639 39999000017717 39999000003352 39999000007398 3999900000017 39999000002775 39999000002799 39999000017557 39999000004458 39999000004472 39999000004915 39999000013511 39999000017472 39999000017496 39999000018554 39999000018578 39999000018592 39999000014839 39999000012576 39999000002539 39999000016611 39999000017205 39999000017267 39999000016925 39999000016949 39999000000672 39999000013894 39999000018738 39999000018752 39999000007459 39999000017380 39999000005936 5. When you click on Checkouts tab under either the patron's Check out or Details sections, you have a single table divided into these sections: - Today's checkouts - Previous checkouts -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org