Bug 32278

Summary: Batch modifications from the biblio page can cause 414 URI too long when attempting to modify many items
Product: Koha Reporter: Liz Rea <wizzyrea>
Component: Staff interfaceAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: aleisha, dcook, gmcharlt, katariina.pohto, mathsabypro, wizzyrea
Version: 21.11   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36133
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36272
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27859
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Liz Rea 2022-11-18 22:11:36 UTC
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
Comment 1 David Cook 2022-11-20 22:48:49 UTC
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).
Comment 2 Liz Rea 2023-01-09 21:41:17 UTC
I am 100% certain that is the correct call here - the way we do it now simply won't scale.
Comment 3 Magnus Enger 2024-03-07 12:30:53 UTC
*** Bug 36133 has been marked as a duplicate of this bug. ***
Comment 4 Katariina Pohto 2025-03-18 10:34:16 UTC
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.