Bug 39164

Summary: Add max_statement_time to SQL report queries
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: cornelius.amzar, koha, markus.john
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Katrin Fischer 2025-02-19 14:51:52 UTC
Sometimes an unlucky report can create an issue for the DB server. To avoid that an easy to achieve fix would be to add a configurable timeout via max_statement_time to the query. This way the query would abort automatically if going over the time limit.

See:
https://mariadb.com/kb/en/aborting-statements/