Project

General

Profile

Actions
Copy link

action #49886

closed

Foreign key violation for limit_assets minion job on OSD

Added by nicksinger about 5 years ago. Updated almost 5 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
kraih
Category:
Feature requests
Target version:
-
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
Copy link

Also available in: Atom PDF