Bug 41919

Summary: Limit number of current reports a single user can run simultaneously
Product: Koha Reporter: Kyle M Hall (khall) <kyle>
Component: ReportsAssignee: Kyle M Hall (khall) <kyle>
Status: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: dcook, lisette
Version: Main   
Hardware: All   
OS: All   
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:
Bug Depends on: 41918    
Bug Blocks: 41920    
Attachments: Bug 41919: Limit number of current reports a single user can run simultaneously
Bug 41919: Limit number of concurrent reports that can be run simultaneously for an instance of Koha

Description Kyle M Hall (khall) 2026-02-24 19:22:18 UTC
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.
Comment 1 Kyle M Hall (khall) 2026-02-25 18:04:34 UTC
Created attachment 193931 [details] [review]
Bug 41919: Limit number of current reports a single user can run simultaneously

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-26 18:59:41 UTC
Created attachment 194041 [details] [review]
Bug 41919: 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!