July 2023 - Koha-bugs - lists.koha-community.org

[Bug 22592] New: Elasticsearch - Support for index scan
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22592 Bug ID: 22592 Summary: Elasticsearch - Support for index scan Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: ere.maijala(a)helsinki.fi Target Milestone: --- We can emulate index scan at least to some extent by using faceting with an include filter. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 51

[Bug 34141] New: OPAC Search Performance on Ubuntu Server
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34141 Bug ID: 34141 Summary: OPAC Search Performance on Ubuntu Server Change sponsored?: --- Product: Koha Version: 22.05 Hardware: All OS: Linux Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: amar(a)ourlib.in QA Contact: testopia(a)bugs.koha-community.org We are experiencing a performance issue with the OPAC search functionality on our server. Despite enabling memcached and Apache2 cache services, the OPAC search is extremely slow and consumes excessive CPU resources, leading to server downtime. Here are the details of our server: - Operating System: Ubuntu 20.04 LTS - CPU: 4 cores - RAM: 8GB - Storage: 200GB SSD When monitoring the server using the 'top' command, we observe that only a few OPAC search requests are being processed. However, these requests are utilizing nearly all of the available CPU resources, leaving no CPU capacity for other tasks and causing the server to go down. It's worth mentioning that we did not utilize the 'koha-common' command for the Koha installation and setup. Instead, we downloaded the Koha tar file and performed the installation using the 'perl Makefile.PL' command. We kindly request your assistance in improving the speed and performance of our server. Any suggestions or guidance on optimizing the OPAC search functionality would be greatly appreciated. Thank you in advance for your support. Please check detailed server log here : https://github.com/Londheamar/koha-issue -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 --- Comment #48 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153261 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153261&action=e… Bug 6796: Don't add a day if hourly loan period pushes due date If ConsiderLibraryHoursWhenIssuing is set to shorten the loan period to the closing time, if the loan period initially pushes the due date to the following day, the day still gets added when calculating the due date. We simply need to hardcode the due time here as the due day is the same as the issue day. We only need to calculate a due date if ConsiderLibraryHoursWhenIssuing is set to extend the loan period to the next opening day, as we'll need to consider holidays/closed days. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150478|0 |1 is obsolete| | --- Comment #47 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153260 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153260&action=e… Bug 6796: (follow-up) Schema changes -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150477|0 |1 is obsolete| | --- Comment #46 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153259 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153259&action=e… Bug 6796: (follow-up) Fix branch_hours.day to enum and add filters -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150448|0 |1 is obsolete| | --- Comment #45 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153258 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153258&action=e… Bug 6796: Fix saving of libraries and tests -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150447|0 |1 is obsolete| | --- Comment #44 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153257 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153257&action=e… Bug 6796: Fix atomic updates -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150446|0 |1 is obsolete| | --- Comment #43 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153256 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153256&action=e… Bug 6796: Updated schema files -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150445|0 |1 is obsolete| | --- Comment #42 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153255 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153255&action=e… Bug 6796: (follow-up) Fix logic for calculating following day's open hours Since days for branch hours are stored as 0-6 in the database, when it's a Saturday (6) incrementing the date leads to an error when issuing an hourly loan because no opening hours are found for the non-existent day (7). This patch fixes this by calculating the tomorrow day and setting it to 0 if it's greater than 6. This patch also corrects the mappings for days, where local_day_of_week caluclates the date with Sunday first, which put it out of sync with the database opening hours days. Sponsored-by: Auckland University of Technology Sponsored-by: Catalyst IT -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 6796] Overnight checkouts taking into account opening and closing hours
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796 Aleisha Amohia <aleisha(a)catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #150444|0 |1 is obsolete| | --- Comment #41 from Aleisha Amohia <aleisha(a)catalyst.net.nz> --- Created attachment 153254 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153254&action=e… Bug 6796: Consider library hours when calculating due date + tests This feature adds the ability to set opening and closing hours for your library and for these hours to be considered when calculating due dates for hourly loans. If the due date for an hourly loan falls after the library closes, the library can choose for the due date to be shortened to meet the close time, or extended to meet the open time the next day. This feature adds a new table 'branch_hours' for storing the open and close times per day for each library, and a new system preference 'ConsiderLibraryHoursWhenIssuing' to choose which behaviour should be followed when calculating due dates. To test: 1. Apply patches and update database. Upgrade schema if not applying patch with schema changes. Restart services. 2. Go to Administration -> Libraries. Edit a library and scroll to the bottom to find the 'opening hours' section. Test adding and removing open and close times on various days. Confirm saving works as expected. 3. Add a new library and test adding open and close times works as expected. 4. Edit your default library and save open and close times for each day. 5. Go to Administration -> Circulation and fine rules. Edit a rule, set the unit to 'hours' and set the loan period to a number that would cause a checkout to be due after the close time you just set, i.e. if you set your close time to be 5pm and your system time is currently 1pm, set the loan period to be 5 (5 hours) so the calculated due date would be 6pm. 6. Go to Administration -> system preferences. Search for ConsiderLibraryHoursWhenIssuing. It should be under 'Checkout policy' in the Circulation system preferences. Confirm the pre-selected option is 'ignore'. Keep this tab open. 6. In a new tab, get the barcode for an item that has an itemtype matching the circulation rule you just set. 7. Go to the checkouts for a patron that has a categorycode matching the circulation rule you just set. 8. Check out your item. Confirm that the checkout is due at the end of the loan period, not taking closing hours into consideration. Return the item. 9. Back in your other tab, set ConsiderLibraryHoursWhenIssuing to 'close', so the due date should be shortened to meet the close time. 10. Check out your item. Confirm the checkout is due when the library closes. Return the item. 11. Back in your other tab, set ConsiderLibraryHoursWhenIssuing to 'open', so the due date should be extended to meet the opening time. 12. Check out your item. Confirm the checkout is due the next day when the library opens. 13. Confirm tests pass t/db_dependent/Circulation/CalcDateDue.t Sponsored-by: Catalyst IT -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0