Bug 32278 - Batch modifications from the biblio page can cause 414 URI too long when attempting to modify many items
Summary: Batch modifications from the biblio page can cause 414 URI too long when atte...
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Staff interface (show other bugs)
Version: 21.11
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
: 36133 (view as bug list)
Depends on:
Blocks:
 
Reported: 2022-11-18 22:11 UTC by Liz Rea
Modified: 2025-03-18 10:34 UTC (History)
6 users (show)

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.