Project

General

Profile

Actions

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:
Category:
-
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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 open1 closed)

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

Updated by The Foreman Bot over 8 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Eric Helms
  • Pull request https://github.com/Katello/katello/pull/5973 added
Actions #2

Updated by Anonymous over 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #3

Updated by Eric Helms over 8 years ago

  • Has duplicate Bug #14551: after foreman and katello upgrade db:migrate fails added
Actions #4

Updated by Justin Sherrill over 8 years ago

  • Bugzilla link set to 1328274
Actions

Also available in: Atom PDF