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, 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
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. ***