Actions
action #49886
closedForeign key violation for limit_assets minion job on OSD
Start date:
2019-04-02
Due date:
% Done:
0%
Estimated time:
Description
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).
Actions