[Bug 25088] New: The tool to bulk edit due dates proxy error times out with large data sets
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25088 Bug ID: 25088 Summary: The tool to bulk edit due dates proxy error times out with large data sets Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: margaret@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org The libraries we support are really appreciative of the new Bug 24846 - "Add a tool to bulk edit due dates", but if a library has 20,000, 30,000, 50,000 issues that they need to use the tool on the user will encounter a proxy error and the page will time out. We've tested this problem trying to even load the second page that shows you a preview of the record to be updated if pushing forward the due date by a number of days is the chosen option. We've gotten the page to load with a hard due date chosen; it squeaked under the apache time out at 8 minutes 46 seconds to load. It would be great if the tool had a better way of handling large batches of data to be updated, because the current errors aren't inspiring much confidence. Libraries can break their batches into smaller groups, to a point, but we're finding that it's still easier for them to have the support team do a bulk due date update for them. I know other tools encounter this issue with large datasets, but at this point we don't have an approximate number of issues that is it 'safe' to update at one time. And if they've got 10,000 items at a branch, all checked out by the same category, they might not be able to make that grouping small enough to get the tool to work. -- 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=25088 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|19.05 |master Depends on| |24846 CC| |katrin.fischer@bsz-bw.de Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24846 [Bug 24846] Add a tool to bulk edit due dates -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25088 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- By linking to the initial bug this will be a little easier to spot! -- 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=25088 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- There is not much we can do. On my laptop, after super quick tests, ~1100 checkouts is processed in ~13s I made it down to 12s with small improvements (datetime handling), but it won't bring significant changes. If we want to display before the process, it will be time consuming. With bug 22417 in mind we could imagine bigger batches (background processing). Or we can provide command line script, but I guess we are loosing the idea of an easy tool that can be used by librarians. You could try playing with the Apache timeout value, but that will need a sysop intervention. -- 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=25088 --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 102610 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=102610&action=edit Bug 25088: prevent too many datetime operations dropping this now to not forget, but it's not super useful. Note for myself: no sure about the removal of $new_hard_due_date->clone in the sub -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25088 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE CC| |kyle@bywatersolutions.com Status|NEW |RESOLVED --- Comment #4 from Kyle M Hall <kyle@bywatersolutions.com> --- *** This bug has been marked as a duplicate of bug 25101 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org