Project

General

Profile

Actions

action #156547

open

QA - coordination #99303: [saga][epic] Future improvements for SUSE Maintenance QA workflows with fully automated testing, approval and release

coordination #99306: [epic] Future improvements: Make reviewing openQA results per squad easier

A single API route to show all not-ok tests blocking a SLE maintenance incident size:M

Added by okurz 2 months ago. Updated 24 days ago.

Status:
Workable
Priority:
Normal
Assignee:
-
Category:
Feature requests
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:

Description

Motivation

From #121246-15: "We'd need to look for all the tests that are failing for a given incident, using the same TEST_ISSUES for both, Aggregates and Incidents". After #117655 we identified that we can use that to filter but there is a key/job id limit so we need to find out how to work with a much larger limit e.g. with a database index.

Acceptance criteria

  • AC1: /job_settings/jobs can yield a sufficiently complete list of matching jobs, e.g. some weeks old
  • AC2: DoS attacks using /job_settings/jobs is not feasible -> so not just remove the limit

Suggestions

  • We can get a job for a particular incident (#117655#note-33)
    • openqa-cli api --o3 /job_settings/jobs key=*_TEST_ISSUES list_value=1234567
    • openqa-cli api --osd /job_settings/jobs key=LTSS_TEST_ISSUES list_value=20988
    • Note there is an implicit enforced limit of 20000 jobs here (see also the later suggestion)
  • Explore how to work around the key/job id limit without simply removing it, or add a way to override it or finally introduce a trigram gin index for fast text searching without limits on keys

Out of scope

  • This doesn't need to be specific to squads/blocking tests (openQA itself should not know about these SUSE specific concepts)

Related issues 2 (1 open1 closed)

Copied from openQA Project - action #131279: [timeboxed:6h][spike solution] a single command line or openQA webUI search view to show all tests blocking an incident by squad size:SResolvedybonatakis

Actions
Copied to openQA Project - action #157660: A single webUI search view to show all not-ok tests blocking a SLE maintenance incident size:MNew2024-03-21

Actions
Actions

Also available in: Atom PDF