Project

General

Profile

Actions
Copy link

action #110409

closed

coordination #91646: [saga][epic] SUSE Maintenance QA workflows with fully automated testing, approval and release

coordination #109641: [epic] qem-bot improvements

qem-dashboard - remove old openQA jobs when rr_number changes size:M

Added by kraih over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
kraih
Target version:
openQA Project - Ready
Start date:
2022-04-28
Due date:
% Done:

0%

Estimated time:

Description

Motivation

#109310 was a good start, but not quite enough to resolve https://github.com/openSUSE/qem-dashboard/issues/61. Incidents might be reused from one day to the next, so only deleting data that is 90 days old does not cover such cases.

Acceptance criteria

  • AC1: Whenever the rr_number of an incident changes, delete existing openQA jobs in the database.
  • AC2: Ensure that there are no performance regressions

Suggestions

  • Trigger the rr_number check from the same API that does the 90 day cleanup.

Related issues 2 (0 open — 2 closed)

Related to openQA Project - action #109310: qem-bot/dashboard - mixed old and new incidents size:MResolvedkraih2022-03-31

Actions
Related to QA - action #114694: Incident seems to have missing aggregate test results in qem-dashboard but openQA jobs exists size:MResolvedkraih2022-07-26

Actions
Actions
Copy link
 #1

Updated by kraih over 2 years ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by kraih over 2 years ago

  • Related to action #109310: qem-bot/dashboard - mixed old and new incidents size:M added
Actions
Copy link
 #3

Updated by kraih over 2 years ago

  • Description updated (diff)
Actions
Copy link
 #4

Updated by kraih over 2 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #5

Updated by okurz over 2 years ago

  • Subject changed from qem-dashboard - remove old openQA jobs when rr_number changes to qem-dashboard - remove old openQA jobs when rr_number changes size:M
  • Target version changed from future to Ready
Actions
Copy link
 #6

Updated by openqa_review over 2 years ago

  • Due date set to 2022-05-17

Setting due date based on mean cycle time of SUSE QE Tools

Actions
Copy link
 #8

Updated by kraih over 2 years ago

  • Status changed from In Progress to Feedback
Actions
Copy link
 #9

Updated by kraih over 2 years ago

Actions
Copy link
 #10

Updated by kraih over 2 years ago

  • Status changed from Feedback to Resolved

The feature is being used in production:

May 17 10:14:15 qam2 dashboard[20256]: [20256] [i] Cleaning up old jobs for incident 24247, rr_number change: 272218 -> 272456

Considering there are no complaints yet, we can probably assume it works.

Actions
Copy link
 #11

Updated by okurz over 2 years ago

  • Due date deleted (2022-05-17)
Actions
Copy link
 #12

Updated by jbaier_cz about 2 years ago

  • Related to action #114694: Incident seems to have missing aggregate test results in qem-dashboard but openQA jobs exists size:M added
Actions
Copy link

Also available in: Atom PDF