Project

General

Custom queries

Profile

Actions
Copy link

Bug #13650

closed

After recent move of errata association from content host to host, the system deletion fails on errata foreign key

Added by Ivan Necas about 9 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Walden Raines
Category:
Errata Management
Target version:
Katello 3.0.0
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/Katello/katello/pull/5768
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

After rebasing to https://github.com/Katello/katello/commit/936cdbc372bdfc41fea42c6fe5318addbefd08e5,
I've hit the following issue when running subscription-manager register --force on already registered system:

update or delete on table "katello_systems" violates foreign key constraint "katello_system_errata_system_id" on table "katello_system_errata"

Related issues 1 (1 open — 0 closed)

Blocks Katello - Feature #11435: Host Unification TrackerNewActions

Added by Walden Raines about 9 years ago

Revision 5619067e (diff)

Fixes #13650 - remove system_errata table.

When deleting a system the foreign key to system_errata causes
the delete of the system to fail. This table is now unused and
should be removed.

http://projects.theforeman.org/issues/13650

Added by Walden Raines about 9 years ago

Revision 16ae0f10

Merge pull request #5768 from waldenraines/13650

Fixes #13650 - remove system_errata table.

Actions
Copy link

Also available in: Atom PDF