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 8 months ago. Updated 6 months 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 #1

Updated by okurz 8 months ago

  • Copied from 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:S added
Actions #2

Updated by okurz 8 months ago

  • Target version changed from Ready to Tools - Next
Actions #3

Updated by okurz 8 months ago

  • Parent task changed from #118639 to #99306
Actions #4

Updated by okurz 8 months ago

  • Target version changed from Tools - Next to Ready
Actions #5

Updated by okurz 7 months ago

  • Subject changed from A single openQA webUI search view to show all not-ok tests blocking a SLE maintenance incident to A single API route to show all not-ok tests blocking a SLE maintenance incident size:M
  • Description updated (diff)
  • Status changed from New to Workable
Actions #6

Updated by okurz 7 months ago

  • Copied to action #157660: A single webUI search view to show all not-ok tests blocking a SLE maintenance incident size:M added
Actions #7

Updated by okurz 7 months ago

  • Target version changed from Ready to Tools - Next
Actions #8

Updated by okurz 7 months ago

  • Target version changed from Tools - Next to Ready
Actions #9

Updated by okurz 7 months ago

I moved this ticket based on special request by team members but it did not get picked up yet. As it's not linked to any saga currently in ready or next moving out again

Actions #10

Updated by okurz 6 months ago

  • Target version changed from Ready to future
Actions

Also available in: Atom PDF