action #29535

Regression: Can't delete jobs "holding" assets

Added by coolo about 2 years ago. Updated almost 2 years ago.

Status:ResolvedStart date:18/12/2017
Priority:NormalDue date:
Assignee:mkittler% Done:

100%

Category:Concrete Bugs
Target version:Done
Difficulty:
Duration:

Description

I can't delete jobs that are holding last_use_job_id in assets table.

[Mon Dec 18 08:55:21 2017] [5035:error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: update or delete on table "jobs" violates foreign key constraint "assets_fk_last_use_job_id" on table "
assets"
DETAIL: Key (id)=(1329869) is still referenced from table "assets". [for Statement "DELETE FROM jobs WHERE ( id = ? )" with ParamValues: 1='1329869'] at /usr/share/openqa/script/../lib/OpenQA/Schema/Result/Jobs.pm line 273

I assume unsetting that field for gru to let it recalculate is for now good enough - but in fact in this case the asset is generated and leaves the asset in 'no job group'. But these untracked assets are a problem of its own

History

#1 Updated by mkittler about 2 years ago

  • Assignee set to mkittler

#2 Updated by mkittler about 2 years ago

  • Status changed from New to In Progress

#3 Updated by AdamWill about 2 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 100

The PR was merged, so I assume we can close this. (Don't mind me, just sweepin' up around here, tum ti tum...)

#4 Updated by szarate almost 2 years ago

  • Target version changed from Ready to Done

Also available in: Atom PDF