action #152643: https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test showing two entries for x86_64, one with quotes and one without - openQA Infrastructure (public) - openSUSE Project Management Tool

Actions

Copy link

action #152643

closed

https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test showing two entries for x86_64, one with quotes and one without

Added by okurz 12 months ago. Updated 12 months ago.

Status:

Resolved

Priority:

Normal

Assignee:

tinita

Category:

Target version:

openQA Project (public) - Ready

Start date:

2023-12-14

Due date:

% Done:

Estimated time:

Tags:

infra, reactive work

Description

Observation¶

https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test showing two entries for x86_64, one with quotes and one without. Likely that appeared since 2023-12-13 since the past days I regularly took a look. The entry for 'x86_64' seems to have appeared since then and shouldn't be there.

Acceptance criteria¶

AC1: https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test?orgId=1&from=now-7d&to=now&viewPanel=12 shows only the four usual architectures x86_64, aarch64, ppc64le, s390x without quotes and no duplicates

Suggestions¶

Check if somebody scheduled jobs with architecture 'x86_64' by mistake and if yes delete those jobs
Ensure that https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test https://monitor.qa.suse.de/d/nRDab3Jiz/openqa-jobs-test?orgId=1&from=now-7d&to=now&viewPanel=12 shows only the four usual architectures x86_64, aarch64, ppc64le, s390x without quotes and no duplicates

Actions

Copy link

Updated by tinita 12 months ago · Edited

At least this returns nothing on osd, so no job with a single quote in arch:

openqa=> select count(*) from jobs where arch like '%''%';
 count 
-------
     0
(1 row)

Actions

Copy link

Updated by tinita 12 months ago · Edited

I found it in influxdb with a process of elimination, because I couldn't find out how to search for a single quote.
This is the entry (Wed Dec 13 15:19:31 2023 UTC):

> select * from openqa_jobs_by_arch where time = 1702480771000000000;

name: openqa_jobs_by_arch
time                arch     blocked host   origin running scheduled url
----                ----     ------- ----   ------ ------- --------- ---
1702480771000000000 'x86_64'         openqa salt           1         https://openqa.suse.de
1702480771000000000 aarch64          openqa salt   4                 https://openqa.suse.de
1702480771000000000 ppc64le  111     openqa salt   46      167       https://openqa.suse.de
1702480771000000000 s390x    17      openqa salt   20      204       https://openqa.suse.de
1702480771000000000 x86_64   91      openqa salt   98      1002      https://openqa.suse.de

Actions

Copy link