Project

General

Profile

action #71605

Cleanup task `limit_results_and_logs` fails with database error

Added by mkittler 7 months ago. Updated 7 months ago.

Status:
New
Priority:
Low
Assignee:
-
Category:
Concrete Bugs
Target version:
Start date:
2020-09-21
Due date:
% Done:

0%

Estimated time:
Difficulty:

Description

observation

On OSD a limit_results_and_logs task failed with the following database error:

{
  "args" => [],
  "attempts" => 1,
  "children" => [],
  "created" => "2020-09-19T22:00:03.56377Z",
  "delayed" => "2020-09-19T22:03:04.33687Z",
  "expires" => "2020-09-21T22:00:03.56377Z",
  "finished" => "2020-09-19T22:25:10.5735Z",
  "id" => 626723,
  "lax" => 0,
  "notes" => {
    "gru_id" => 27740667
  },
  "parents" => [],
  "priority" => 5,
  "queue" => "default",
  "result" => "bless( {\n         'msg' => 'DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  integer out of range [for Statement \"UPDATE jobs SET logs_present = ?, result_size = result_size - 7760462702, t_updated = ? WHERE ( id = ? )\" with ParamValues: 1=\\'0\\', 2=\\'2020-09-19 22:25:10\\', 3=\\'4269174\\'] at /usr/share/openqa/script/../lib/OpenQA/Schema/Result/Jobs.pm line 1158\n'\n       }, 'DBIx::Class::Exception' )\n",
  "retried" => "2020-09-19T22:02:04.33687Z",
  "retries" => 3,
  "started" => "2020-09-19T22:03:04.62529Z",
  "state" => "failed",
  "task" => "limit_results_and_logs",
  "time" => "2020-09-21T14:30:19.38549Z",
  "worker" => 350
}

The next limit_results_and_logs was successful again so this is not a persistent error preventing the cleanup to work at all. In fact I've seen this error only once so far.

suggestions

  • Update this ticket if it happens more often.
  • Take a look at the relevant code and try to provoke a situation which would lead to such an error. Try to extend unit tests. Change the code to avoid that situation.

History

#1 Updated by okurz 7 months ago

  • Priority changed from Normal to Low
  • Target version set to future

Interesting new issue. Unless it happens more often I would regard this as not important for us for now

Also available in: Atom PDF