QA » openQA Project

We see many issues similar to:

{
  "args" => [],
  "attempts" => 1,
  "children" => [],
  "created" => "2019-03-31T19:12:39.61881Z",
  "delayed" => "2019-03-31T19:12:39.61881Z",
  "finished" => "2019-03-31T19:14:01.1071Z",
  "id" => 106669,
  "notes" => {
    "gru_id" => 27221060,
    "ttl" => 172800
  },
  "parents" => [],
  "priority" => 10,
  "queue" => "default",
  "result" => {
    "error" => "\$VAR1 = bless( {\n                 'msg' => 'OpenQA::Task::Asset::Limit::_limit(): DBI Exception: DBD::Pg::st execute failed: ERROR:  insert or update on table \"assets\" violates foreign key constraint \"assets_fk_last_use_job_id\"\nDETAIL:  Key (last_use_job_id)=(2532633) is not present in table \"jobs\". [for Statement \"UPDATE assets SET last_use_job_id = ? WHERE id = ?\" with ParamValues: 1=\\'2532633\\', 2=\\'511204\\'] at /usr/share/openqa/script/../lib/OpenQA/Task/Asset/Limit.pm line 25\n'\n               }, 'DBIx::Class::Exception' );\n"
  },
  "retried" => undef,
  "retries" => 0,
  "started" => "2019-03-31T19:12:39.62822Z",
  "state" => "failed",
  "task" => "limit_assets",
  "worker" => 88
}

for the limit_assets minion job on OSD.
As discussed in IRC we need to get rid of those for proper monitoring (and for the sake of cleanness of course).