Project

General

Profile

action #110409

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 about 1 year ago. Updated about 1 year 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

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

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

History

#1 Updated by kraih about 1 year ago

  • Description updated (diff)

#2 Updated by kraih about 1 year ago

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

#3 Updated by kraih about 1 year ago

  • Description updated (diff)

#4 Updated by kraih about 1 year ago

  • Status changed from New to In Progress

#5 Updated by okurz about 1 year 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

#6 Updated by openqa_review about 1 year ago

  • Due date set to 2022-05-17

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

#8 Updated by kraih about 1 year ago

  • Status changed from In Progress to Feedback

#10 Updated by kraih about 1 year 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.

#11 Updated by okurz about 1 year ago

  • Due date deleted (2022-05-17)

#12 Updated by jbaier_cz 10 months ago

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

Also available in: Atom PDF