Bug 41920 - Limit number of concurrent reports that can be run simultaneously for an instance of Koha
Summary: Limit number of concurrent reports that can be run simultaneously for an inst...
Status: Needs Signoff
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Kyle M Hall (khall)
QA Contact: Testopia
URL:
Keywords:
Depends on: 41919
Blocks: 41921
  Show dependency treegraph
 
Reported: 2026-02-24 19:47 UTC by Kyle M Hall (khall)
Modified: 2026-02-25 18:07 UTC (History)
1 user (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Comma delimited list of Sponsors:
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
Bug 41920: Limit number of concurrent reports that can be run simultaneously for an instance of Koha (6.75 KB, patch)
2026-02-25 17:43 UTC, Kyle M Hall (khall)
Details | Diff | Splinter Review
Bug 41920: Limit number of concurrent reports that can be run simultaneously for an instance of Koha (6.36 KB, patch)
2026-02-25 18:06 UTC, Kyle M Hall (khall)
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall (khall) 2026-02-24 19:47:20 UTC
As a continuation of bug 41919,  we should limit the total number of simultaneous reports that can be run at a time.
Comment 1 Kyle M Hall (khall) 2026-02-25 17:43:26 UTC
Created attachment 193930 [details] [review]
Bug 41920: Limit number of concurrent reports that can be run simultaneously for an instance of Koha

Building on bug 41918, it would be good to limit the number of reports a given user can run at a time.
This control should be conf file based as it is tied to the server resources provided by whoever administers the server.

Test Plan:
1) Set total_running_reports_per_user_limit to 3 in your koha-conf.xml
2) Create 3 long running reports like: SELECT COUNT(*) FROM items i1 JOIN items i2 JOIN items i3 JOIN items i4 JOIN items i5 JOIN items i6
3) Run each report in turn by opening a new tab, browsing to the reports
   module, and choosing to run that report
5) Note the first two continue to run, but the last one gives an error
   that you have too many reports running simultaneously!
Comment 2 Kyle M Hall (khall) 2026-02-25 18:06:46 UTC
Created attachment 193932 [details] [review]
Bug 41920: Limit number of concurrent reports that can be run simultaneously for an instance of Koha

As a continuation of bug 41919,  we should limit the total number of simultaneous reports that can be run at a time.

Test Plan:
1) Set total_running_reports_per_instance_limit to 2 in your koha-conf.xml
2) Create 3 long running reports like: SELECT COUNT(*) FROM items i1 JOIN items i2 JOIN items i3 JOIN items i4 JOIN items i5 JOIN items i6
3) Run each report in turn by opening a new tab, browsing to the reports
   module, and choosing to run that report
5) Note the first two continue to run, but the last one gives an error
   that you have too many reports running simultaneously!