Bug #35031: 20211220185935_clean_duplicate_content_units db:migrate fails with child records - Katello - Foreman

Bug #35031

20211220185935_clean_duplicate_content_units db:migrate fails with child records

Added by Samir Jha 8 months ago. Updated 6 months ago.

Status:

Closed

Priority:

Normal

Assignee:

Samir Jha

Category:

Upgrades

Target version:

Katello 4.4.2

Difficulty:

Triaged:

Yes

Bugzilla link:

2118694

Pull request:

https://github.com/Katello/katello/pull/10196

Fixed in Releases:

Katello 4.6.0

Found in Releases:

Red Hat JIRA:

Description

During db:migrate the database patch 20211220185935_clean_duplicate_content_units.rb is applied, but fails with the following error in /var/log/foreman-installer/katello.log:

2022-06-07 08:48:45 [INFO  ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: PG::ForeignKeyViolation: ERROR:  update or delete on table "katello_module_profiles" violates foreign key constraint "katello_mod_profile_rpm_mod_profile_id_fk" on table "katello_module_profile_rpms" 
2022-06-07 08:48:45 [INFO  ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: DETAIL:  Key (id)=(22) is still referenced from table "katello_module_profile_rpms".

More details here: https://community.theforeman.org/t/foreignkeyviolation-on-katello-module-profiles-during-db-migrate/28926

Associated revisions

Revision 66732409 (diff)
Added by Samir Jha 6 months ago

Fixes #35031 - Delete ModuleProfile and ModuleProfileRpms before ModuleStreams (#10196)

History

#1 Updated by William Clark 8 months ago

Triaged changed from No to Yes
Target version set to Katello 4.4.2

#2 Updated by Florian Faltermeier 8 months ago

Samir Jha wrote:

During db:migrate the database patch 20211220185935_clean_duplicate_content_units.rb is applied, but fails with the following error in /var/log/foreman-installer/katello.log:

[...]

More details here: https://community.theforeman.org/t/foreignkeyviolation-on-katello-module-profiles-during-db-migrate/28926

Same issue happens to me on upgrade vom Katello 4.3 to 4.4

Florian

#3 Updated by Vladislav Bulygin 7 months ago

Samir Jha wrote:

During db:migrate the database patch 20211220185935_clean_duplicate_content_units.rb is applied, but fails with the following error in /var/log/foreman-installer/katello.log:

[...]

More details here: https://community.theforeman.org/t/foreignkeyviolation-on-katello-module-profiles-during-db-migrate/28926

Same problem with same versions.