[Bug 32278] New: Batch modifications from the biblio page can cause 415 URI too long when attempting to modify many items
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32278 Bug ID: 32278 Summary: Batch modifications from the biblio page can cause 415 URI too long when attempting to modify many items Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff interface Assignee: koha-bugs@lists.koha-community.org Reporter: wizzyrea@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com We had a library attempt to request the following uri from the detail page with a "select all -> modify" type of workflow. They could do up to about 400 items (I presume because their biblionumbers are of this specific length) but not 500 or 800, response from apache is 414 Request URI too long. We will likely up the limit for this but wondering if there is something that can be done to make this work a little better at scale. https://staff.partner.kohaprovider.com/cgi-bin/koha/tools/batchMod.pl?op=show&itemnumber=48432&itemnumber=48433&itemnumber=48434&itemnumber=48435&itemnumber=48436&itemnumber=48437&itemnumber=48438&itemnumber=48439&itemnumber=48440&itemnumber=48441&itemnumber=48442&itemnumber=48443&itemnumber=48444&itemnumber=48445&itemnumber=48446&itemnumber=48447&itemnumber=48448&itemnumber=48449&itemnumber=48450&itemnumber=48451&itemnumber=48452&itemnumber=48453&itemnumber=48454&itemnumber=48455&itemnumber=48456&itemnumber=48457&itemnumber=48458&itemnumber=48459&itemnumber=48460&itemnumber=48461&itemnumber=48462&itemnumber=48463&itemnumber=48464&itemnumber=48465&itemnumber=48466&itemnumber=48467&itemnumber=48468&itemnumber=48469&itemnumber=48470&itemnumber=48471&itemnumber=48472&itemnumber=48473&itemnumber=48474&itemnumber=48475&itemnumber=48476&itemnumber=48477&itemnumber=48478&itemnumber=48479&itemnumber=48480&itemnumber=48481&itemnumber=48482&itemnumber=48483&itemnumber=48484&itemnumber=48485&itemnumber=48486&itemnumber=48487&itemnumber=48488&itemnumber=48489&itemnumber=48490&itemnumber=48491&itemnumber=48492&itemnumber=48493&itemnumber=48494&itemnumber=48495&itemnumber=48496&itemnumber=48497&itemnumber=48498&itemnumber=48499&itemnumber=48500&itemnumber=48501&itemnumber=48502&itemnumber=48503&itemnumber=48504&itemnumber=48505&itemnumber=48506&itemnumber=48507&itemnumber=48508&itemnumber=48509&itemnumber=48510&itemnumber=48511&itemnumber=48512&itemnumber=48513&itemnumber=48514&itemnumber=48515&itemnumber=48516&itemnumber=48517&itemnumber=48518&itemnumber=48519&itemnumber=48520&itemnumber=48521&itemnumber=48522&itemnumber=48523&itemnumber=48524&itemnumber=48525&itemnumber=48526&itemnumber=48527&itemnumber=48528&itemnumber=48529&itemnumber=48530&itemnumber=48531&itemnumber=48532&itemnumber=48533&itemnumber=48534&itemnumber=48535&itemnumber=48536&itemnumber=48537&itemnumber=48538&itemnumber=48539&itemnumber=48540&itemnumber=48541&itemnumber=48542&itemnumber=48543&itemnumber=48544&itemnumber=48545&itemnumber=48546&itemnumber=48547&itemnumber=48548&itemnumber=48549&itemnumber=48550&itemnumber=48551&itemnumber=48552&itemnumber=48553&itemnumber=48554&itemnumber=48555&itemnumber=48556&itemnumber=48557&itemnumber=48558&itemnumber=48559&itemnumber=48560&itemnumber=48561&itemnumber=48562&itemnumber=48563&itemnumber=48564&itemnumber=48565&itemnumber=48566&itemnumber=48567&itemnumber=48568&itemnumber=48569&itemnumber=48570&itemnumber=48571&itemnumber=48572&itemnumber=48573&itemnumber=48574&itemnumber=48575&itemnumber=48576&itemnumber=48577&itemnumber=48578&itemnumber=48579&itemnumber=48580&itemnumber=48581&itemnumber=48582&itemnumber=48583&itemnumber=48584&itemnumber=48585&itemnumber=48586&itemnumber=48587&itemnumber=48588&itemnumber=48589&itemnumber=48590&itemnumber=48591&itemnumber=48592&itemnumber=48593&itemnumber=48594&itemnumber=48595&itemnumber=48596&itemnumber=48597&itemnumber=48598&itemnumber=48599&itemnumber=48600&itemnumber=48601&itemnumber=48602&itemnumber=48603&itemnumber=48604&itemnumber=48605&itemnumber=48606&itemnumber=48607&itemnumber=48608&itemnumber=48609&itemnumber=48610&itemnumber=48611&itemnumber=48612&itemnumber=48613&itemnumber=48614&itemnumber=48615&itemnumber=48616&itemnumber=48617&itemnumber=48618&itemnumber=48619&itemnumber=48620&itemnumber=48621&itemnumber=48622&itemnumber=48623&itemnumber=48624&itemnumber=48625&itemnumber=48626&itemnumber=48627&itemnumber=48628&itemnumber=48629&itemnumber=48630&itemnumber=48631&itemnumber=48632&itemnumber=48633&itemnumber=48634&itemnumber=48635&itemnumber=48636&itemnumber=48637&itemnumber=48638&itemnumber=48639&itemnumber=48640&itemnumber=48641&itemnumber=48642&itemnumber=48643&itemnumber=48644&itemnumber=48645&itemnumber=48646&itemnumber=48647&itemnumber=48648&itemnumber=48649&itemnumber=48650&itemnumber=48651&itemnumber=48652&itemnumber=48653&itemnumber=48654&itemnumber=48655&itemnumber=48656&itemnumber=48657&itemnumber=48658&itemnumber=48659&itemnumber=48660&itemnumber=48661&itemnumber=48662&itemnumber=48663&itemnumber=48664&itemnumber=48665&itemnumber=48666&itemnumber=48667&itemnumber=48668&itemnumber=48669&itemnumber=48670&itemnumber=48671&itemnumber=48672&itemnumber=48673&itemnumber=48674&itemnumber=48675&itemnumber=48676&itemnumber=48677&itemnumber=48678&itemnumber=48679&itemnumber=48680&itemnumber=48681&itemnumber=48682&itemnumber=48683&itemnumber=48684&itemnumber=48685&itemnumber=48686&itemnumber=48687&itemnumber=48688&itemnumber=48689&itemnumber=48690&itemnumber=48691&itemnumber=48692&itemnumber=48693&itemnumber=48694&itemnumber=48695&itemnumber=48696&itemnumber=48697&itemnumber=48698&itemnumber=48699&itemnumber=48700&itemnumber=48701&itemnumber=48702&itemnumber=48703&itemnumber=48704&itemnumber=48705&itemnumber=48706&itemnumber=48707&itemnumber=48708&itemnumber=48709&itemnumber=48710&itemnumber=48711&itemnumber=48712&itemnumber=48713&itemnumber=48714&itemnumber=48715&itemnumber=48716&itemnumber=48717&itemnumber=48718&itemnumber=48719&itemnumber=48720&itemnumber=48721&itemnumber=48722&itemnumber=48723&itemnumber=48724&itemnumber=48725&itemnumber=48726&itemnumber=48727&itemnumber=48728&itemnumber=48729&itemnumber=48730&itemnumber=48731&itemnumber=48732&itemnumber=48733&itemnumber=48734&itemnumber=48735&itemnumber=48736&itemnumber=48737&itemnumber=48738&itemnumber=48739&itemnumber=48740&itemnumber=48741&itemnumber=48742&itemnumber=48743&itemnumber=48744&itemnumber=48745&itemnumber=48746&itemnumber=48747&itemnumber=48748&itemnumber=48749&itemnumber=48750&itemnumber=48751&itemnumber=48752&itemnumber=48753&itemnumber=48754&itemnumber=48755&itemnumber=48756&itemnumber=48757&itemnumber=48758&itemnumber=48759&itemnumber=48760&itemnumber=48761&itemnumber=48762&itemnumber=48763&itemnumber=48764&itemnumber=48765&itemnumber=48766&itemnumber=48767&itemnumber=48768&itemnumber=48769&itemnumber=48770&itemnumber=48771&itemnumber=48772&itemnumber=48773&itemnumber=48774&itemnumber=48775&itemnumber=48776&itemnumber=48777&itemnumber=48778&itemnumber=48779&itemnumber=48780&itemnumber=48781&itemnumber=48782&itemnumber=48783&itemnumber=48784&itemnumber=48785&itemnumber=48786&itemnumber=48787&itemnumber=48788&itemnumber=48789&itemnumber=48790&itemnumber=48791&itemnumber=48792&itemnumber=48793&itemnumber=48794&itemnumber=48795&itemnumber=48796&itemnumber=48797&itemnumber=48798&itemnumber=48799&itemnumber=48800&itemnumber=48801&itemnumber=48802&itemnumber=48803&itemnumber=48804&itemnumber=48805&itemnumber=48806&itemnumber=48807&itemnumber=48808&itemnumber=48809&itemnumber=48810&itemnumber=48811&itemnumber=48812&itemnumber=48813&itemnumber=48814&itemnumber=48815&itemnumber=48816&itemnumber=48817&itemnumber=48818&itemnumber=48819&itemnumber=48820&itemnumber=48821&itemnumber=48822&itemnumber=48823&itemnumber=48824&itemnumber=48825&itemnumber=48826&itemnumber=48827&itemnumber=48828&itemnumber=48829&itemnumber=48830&itemnumber=48831&itemnumber=48832&itemnumber=48833&itemnumber=48834&itemnumber=48835&itemnumber=48836&itemnumber=48837&itemnumber=48838&itemnumber=48839&itemnumber=48840&itemnumber=48841&itemnumber=48842&itemnumber=48843&itemnumber=48844&itemnumber=48845&itemnumber=48846&itemnumber=48847&itemnumber=48848&itemnumber=48849&itemnumber=48850&itemnumber=48851&itemnumber=48852&itemnumber=48853&itemnumber=48854&itemnumber=48855&itemnumber=48856&itemnumber=48857&itemnumber=48858&itemnumber=48859&itemnumber=48860&itemnumber=48861&itemnumber=48862&itemnumber=48863&itemnumber=48864&itemnumber=48865&itemnumber=48866&itemnumber=48867&itemnumber=48868&itemnumber=48869&itemnumber=48870&itemnumber=48871&itemnumber=48872&itemnumber=48873&itemnumber=48874&itemnumber=48875&itemnumber=48876&itemnumber=48877&itemnumber=48878&itemnumber=48879&itemnumber=48880&itemnumber=48881&itemnumber=48882&itemnumber=48883&itemnumber=48884&itemnumber=48885&itemnumber=48886&itemnumber=48887&itemnumber=48888&itemnumber=48889&itemnumber=48890&itemnumber=48891&itemnumber=48892&itemnumber=48893&itemnumber=48894&itemnumber=48895&itemnumber=48896&itemnumber=48897&itemnumber=48898&itemnumber=48899&itemnumber=48900&itemnumber=48901&itemnumber=48902&itemnumber=48903&itemnumber=48904&itemnumber=48905&itemnumber=48906&itemnumber=48907&itemnumber=48908&itemnumber=48909&itemnumber=48910&biblionumber=26604&src=CATALOGUING -- 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=32278 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Batch modifications from |Batch modifications from |the biblio page can cause |the biblio page can cause |415 URI too long when |414 URI too long when |attempting to modify many |attempting to modify many |items |items CC| |wizzyrea@gmail.com -- 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=32278 mathieu saby <mathsabypro@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mathsabypro@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32278 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #1 from David Cook <dcook@prosentient.com.au> --- Off the top of my head, for scale, I think we'd want to POST itemnumbers (probably in batches) to an API "add to batch" endpoint, and then call an API endpoint to perform the batch mod (as a background job). -- 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=32278 --- Comment #2 from Liz Rea <wizzyrea@gmail.com> --- I am 100% certain that is the correct call here - the way we do it now simply won't scale. -- 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=32278 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=36133 -- 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=32278 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aleisha@catalyst.net.nz --- Comment #3 from Magnus Enger <magnus@libriotech.no> --- *** Bug 36133 has been marked as a duplicate of this bug. *** -- 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=32278 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=36272 -- 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=32278 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=27859 -- 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=32278 Katariina Pohto <katariina.pohto@ouka.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katariina.pohto@ouka.fi --- Comment #4 from Katariina Pohto <katariina.pohto@ouka.fi> --- We'd have some need to get this working, the ~400 results is often exceeded when we are doing batch modifications. While it is possible to grab the list of itemnumbers and just navigate to batchMod.pl, it shouldn't be necessary. And it would be good to change all links to batch tools to work the same way, for instance 'Modify selected items' link from Biblio Detail page will also create the same long URI. -- 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=32278 Kristi Krueger <kkrueger@cuyahogalibrary.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kkrueger@cuyahogalibrary.or | |g -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org