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

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

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,