action #97481: qam dashboard including development job group - QA (public) - openSUSE Project Management Tool

Custom queries

may-sprint
new immediate tickets
openQA Infrastructure Project
openqa-review - Closed tickets last updated by openqa-review, last 30 days
QA roadmap long-term
QA SLE functional
QA SLE Functional - closed in last 14 days
QA SLE Functional - High, need to be refined
QA SLE Functional - over cycle time median
QA SLE u
QA SLE y
QA tools (tag not necessary in openQA and subprojects)
QA tools tag (tag not necessary in openQA and subprojects; excluding tickets in "Ready" version as they are already on the backlog)
QAC - Backlog
QE tools team - backlog (dev)
QE tools team - backlog (ready issues)
QE tools team - backlog SLA high
QE tools team - backlog SLA immediate
QE tools team - backlog SLA no immediate/urgent in feedback/blocked
QE tools team - backlog SLA normal
QE tools team - backlog SLA urgent
QE tools team - backlog SLO high
QE tools team - backlog SLO normal
QE tools team - backlog SLO urgent
QE tools team - backlog, high-level view (epics and higher)
QE tools team - backlog, non-reactive work, needs parent
QE tools team - backlog, top-level view (all sagas)
QE tools team - closed within last 14 days
QE tools team - closed within last 60 days
QE tools team - closed yesterday
QE Tools Team - Collaborative Session
QE tools team - due date forecast
QE tools team - exceeding due-date
QE tools team - infrastructure backlog
QE tools team - next - sorted by update time
QE tools team - next issues
QE tools team - non-estimated (unblocked) issues (dev)
QE tools team - non-estimated (unblocked) issues (infra)
QE tools team - ready issues - Workable
QE tools team - ready, not assigned/blocked/low
QE tools team - SLO high forecast
QE tools team - triage: untriaged issues
QE tools team - update forecast
QE tools team - updated by priority
QE tools team - what members of the team are working on - Feedback (not-low)
QE Tools Team Backlog By Assignee
Tools Team Retrospective
Tools Team Retrospective (not estimated or assigned)

Actions

Copy link

action #97481

closed

qam dashboard including development job group

Added by dzedro over 3 years ago. Updated over 3 years ago.

Status:

Resolved

Priority:

Urgent

Assignee:

osukup

Target version:

openQA Project (public) - Ready

Start date:

2021-08-25

Due date:

2021-09-08

% Done:

Estimated time:

Description

Allegedly it's because JeOS: Development group was moved from non-devel to devel group. [1]
I guess it's blocking approx. half of updates on http://dashboard.qam.suse.de/blocked

[1] https://chat.suse.de/channel/qac/thread/MqX5SfykQzpNokELR?jump=J2iRPTz9nZqvrRYsv

History
Notes
Property changes

Actions

Copy link

Updated by okurz over 3 years ago

Due date set to 2021-09-08
Status changed from New to Feedback
Assignee set to okurz
Target version set to Ready

I'm sorry, I don't understand. Could you please add more details? I assume you see a problem but I don't know what the problem is. What is the expected result?

Actions

Copy link

Updated by dzedro over 3 years ago

Assignee deleted (~~okurz~~)
Target version deleted (~~Ready~~)

okurz wrote:

I'm sorry, I don't understand. Could you please add more details? I assume you see a problem but I don't know what the problem is. What is the expected result?

When you open dashboard http://dashboard.qam.suse.de/blocked and search for JeOS: Development, this group should be not there.

Actions

Copy link

Updated by dzedro over 3 years ago

Assignee set to okurz
Target version set to Ready

Actions

Copy link

Updated by okurz over 3 years ago

Status changed from Feedback to New
Assignee deleted (~~okurz~~)
Priority changed from High to Urgent

@osukup is this a regression due to the ill-communicated move of incident test approval from openQABot to bot-ng? If yes, please revert that ASAP

Actions

Copy link

Updated by livdywan over 3 years ago

I don't see any relevant-looking changes in bot-ng or openQABot 🤔️ We really need to figure out where these things are changed, and where we can review such changes easily and quickly.

Actions

Copy link

Updated by osukup over 3 years ago

https://gitlab.suse.de/qa-maintenance/bot-ng/-/merge_requests/9

for current state it needs touch qem dashboard database

Actions

Copy link

Updated by osukup over 3 years ago

Status changed from New to Feedback
Assignee set to osukup

dashboard_db=# DELETE FROM openqa_jobs WHERE job_group='JeOS: Development';
DELETE 180
dashboard_db=#

Actions

Copy link

Updated by osukup over 3 years ago

Status changed from Feedback to In Progress

this more looks like data from rabbitmq pollutes database with unneded groups @kraih ?

Actions

Copy link

Updated by kraih over 3 years ago

osukup wrote:

this more looks like data from rabbitmq pollutes database with unneded groups @kraih ?

There is no data added to the database from RabbitMQ. There is just one query that updates the state of jobs, that't it.

UPDATE openqa_jobs SET status = ?, updated = NOW() WHERE job_id = ? RETURNING job_id;

Actions

Copy link

#10

Updated by osukup over 3 years ago

kraih wrote:

osukup wrote:

this more looks like data from rabbitmq pollutes database with unneded groups @kraih ?

There is no data added to the database from RabbitMQ. There is just one query that updates the state of jobs, that't it.
UPDATE openqa_jobs SET status = ?, updated = NOW() WHERE job_id = ? RETURNING job_id;
oh ... thx for info,