Project

General

Profile

Actions
Copy link

Bug #14676

closed

[3.0 RC2] Upgrade Procedure fails due to "PG Error on table "katello_systems" which violates foreign key constraint"

Added by Christian Ehart over 8 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Eric Helms
Category:
-
Target version:
Katello 3.0.0
Difficulty:
Triaged:
Bugzilla link:
1328274
Pull request:
https://github.com/Katello/katello/pull/5973
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Postgresql Error, please be so kind and refer to the attached logs

Example:
[ INFO 2016-04-15 17:56:20 verbose] Upgrade Step: migrate_foreman...
PG::Error: ERROR: update or delete on table "katello_systems" violates foreign key constraint "system_activation_keys_system_id_fk" on table "katello_system_activation_keys"
DETAIL: Key (id)=(49) is still referenced from table "katello_system_activation_keys".
: DELETE FROM "katello_systems" WHERE "katello_systems"."id" = 49

Files

3.0 UPG Problem with PG.txt 3.0 UPG Problem with PG.txt 17.5 KB Christian Ehart, 04/15/2016 12:37 PM

Related issues 1 (0 open — 1 closed)

Has duplicate Katello - Bug #14551: after foreman and katello upgrade db:migrate failsDuplicate04/08/2016Actions
Actions
Copy link

Also available in: Atom PDF