QA » openQA Project

I think I have the basic implementation and will now add unit tests
https://github.com/perlpunk/scripts/tree/bisect-all-issue-kinds

PR: https://github.com/os-autoinst/scripts/pull/177 - Bisect all *_TEST_ISSUES variables

PR was merged, I will check if it works in production

think there will be small problem with #111710 on OSD

I was able to search for jobs with this query:

select j.id, jg.name, j.clone_id, js.key, js.value,j.t_created
 from job_settings js join jobs j on js.job_id=j.id left join job_groups jg on j.group_id=jg.id
 where js.key like '%_TEST_ISSUES' and js.value like '%,%' and j.result='failed'
 and j.t_created >= '2022-08-10' and j.clone_id is null
 and jg.name !~ '(Development|Public Cloud|Released|Others|Kernel|Virtualization).*';

I looked at this job https://openqa.suse.de/tests/9298857 but there were only the normal last_good_* investigate jobs.

I ran the hook manually but commented out line 18 echo "$test" | "$script_dir/openqa-investigate":

env script_dir=/opt/os-autoinst-scripts enable_force_result=true host=openqa.suse.de exclude_group_regex='.*(Development|Public Cloud|Released|Others|Kernel|Virtualization).*' grep_timeout=60 nice ionice -c idle /tmp/openqa-label-known-issues-and-investigate-hook 9298857

and now the investigation jobs have been created.

I enabled line 18 again and got this:

Skipping investigation of job 9298857: job cluster is already being investigated, see comment on job 9298857
403 Forbidden
404 Not Found
{"error_status":404}

So a new task is to improve error handling, so we can actually see where this comes from.
But no bisect jobs were created this time. I think the openqa-investigate exits with non-zero and aborts the script.

To search for actual bisect jobs I did:

select id, clone_id, test, t_created, state, result from jobs where t_created >= '2022-08-10' and test like '%:bisect_without_%';

and got 19 jobs for today, so in general it works. Example: https://openqa.suse.de/tests/9296997#comments