openSUSE Project Management Tool

2021-06-16

16:08 openQA Project action #94111 (New): Optimize /api/v1/jobs

Currently that endpoint is accessible by everyone, and without parameters it returns up to 10k jobs.
Additionally ...

12:34 openQA Project action #93925 (Feedback): Optimize SQL on /tests/overview

PR: https://github.com/os-autoinst/openQA/pull/3960

09:28 openQA Project action #93925: Optimize SQL on /tests/overview

I did the same changes on osd (except access_log was already enabled), though I had to touch different files.
I re...

2021-06-15

15:54 openQA Project coordination #92854: [epic] limit overload of openQA webUI by heavy requests

okurz wrote:
> tinita wrote:
> > How about reducing MaxRequestWorkers? https://httpd.apache.org/docs/2.4/mod/mpm_...

13:38 openQA Project coordination #92854: [epic] limit overload of openQA webUI by heavy requests

How about reducing MaxRequestWorkers? https://httpd.apache.org/docs/2.4/mod/mpm_common.html#maxrequestworkers

12:58 openQA Project coordination #92854: [epic] limit overload of openQA webUI by heavy requests

okurz wrote:
> As I stated any optimization is only secondary to prevent an overload
Does that mean access_logs a...

12:52 openQA Project action #93925: Optimize SQL on /tests/overview

I made the following config changes on o3:
```
# /etc/apache2/global.conf
CustomLog /space/logs/apache2/access_log...

12:31 openQA Project coordination #92854: [epic] limit overload of openQA webUI by heavy requests

We should add `%D` or `%T` (The time taken to serve the request) to our Apache access_logs.
I found out today that...

2021-06-12

12:53 openQA Project action #93925 (Feedback): Optimize SQL on /tests/overview

For `/tests/overview` pages with a lot of jobs, retrieving data from our database is quite inefficient.
For every jo...

2021-06-11

10:38 openQA Project action #93892 (Workable): Automatically validate code style for python code in openQA

Like in os-autoinst, use black for checking python code style in openQA
## Acceptance criteria
- **AC1**: python...