action #109920

Updated by okurz 4 months ago

## Motivation
See parent #94105 where we identified multiple users stories regarding creating tickets or identifying direct or indirect users of openQA based on openqa-investigate results. As a next step we could try to identify product issues from openqa-investigate results, in particular the step "S3: retry X, last_good_test X, last_good_build V, last_good_test+build V -> reproducible product issue => if QAM test write comment on IBS/OBS or smelt, for non-QAM report product bug" from

## Acceptance criteria
* **AC1:** On failed A comment is written openQA jobs with where from openqa-investigate infos "retry X, last_good_test X, last_good_build V, last_good_test+build V" (X: failed, V: passed) a comment is written pointing to a likely job results we can identify reproducible product regression issues
* **AC2:** No such comment is written on other jobs

## Suggestions
* Take a look how we identify likely sporadic issues as a result of the "retry" job in
* Then try to fan-in on the results of multiple investigation jobs to find the jobs with the combination "retry X, last_good_test X, last_good_build V, last_good_test+build V" (X: failed, V: passed).
The challenge is that job done hooks are called on a single job so one would need to identify other sibling investigation jobs. And any other job can finish sooner than the others. Maybe we just call this investigation step on the "last_good_test" and if other jobs are not finished by then, then trigger another incarnation of the same minion job with a delay (exponential back-off?). Communicate by exit code? This would also avoid the need to run job_done_hooks on passed jobs.
* Then add an openQA comment stating the observation about a likely product regression
* Note: The bash script openqa-investigate itself must not know anything about "openQA minion jobs" or schedule any