Bug 1996103

I believe pulp_2to3_migration migrates orphaned content and doesn't complain about it.
It think some checks on katello side trigger that message.

Changing to Repositories component.
Justin, it sounds very familiar, maybe it's a duplicate...

Tanya, I am aware of this one 

1971069 – [pulp3] run orphan katello unit deletion as part of 'content prepare'
https://bugzilla.redhat.com/show_bug.cgi?id=1971069

Bug #33131: [pulp3] run orphan katello unit deletion as part of 'content prepare' - Katello - Foreman
https://projects.theforeman.org/issues/33131


Is this the one you were looking for ?

(In reply to Sayan Das from comment #2)
> Tanya, I am aware of this one 
> 
> 1971069 – [pulp3] run orphan katello unit deletion as part of 'content
> prepare'
> https://bugzilla.redhat.com/show_bug.cgi?id=1971069
> 
> Bug #33131: [pulp3] run orphan katello unit deletion as part of 'content
> prepare' - Katello - Foreman
> https://projects.theforeman.org/issues/33131
> 
> 
> Is this the one you were looking for ?

That sounds to me to remove orhpaned content from katello, as it calls

Katello::Pulp3::MigrationSwitchover.new(SmartProxy.pulp_primary).remove_orphaned_content

that executes:

      def remove_orphaned_content
        models = []
        @migration.repository_types.each do |repo_type_label|
          repo_type = ::Katello::RepositoryTypeManager.repository_types[repo_type_label]
          indexable_types = repo_type.content_types_to_index
          models += indexable_types&.map(&:model_class)
          models.select! { |model| model.many_repository_associations }
        end
        models.each do |model|
          model.joins("left join katello_#{model.repository_association} on #{model.table_name}.id = katello_#{model.repository_association}.#{model.unit_id_field}").where("katello_#{model.repository_association}.#{model.unit_id_field} IS NULL").destroy_all
        end
      end

which operates over katello_* tables in DB.


In my case, pulp had orphaned content. Will the above clean it?


(I am adding this to my todo list to test this week..)

this won't be needed after  https://bugzilla.redhat.com/show_bug.cgi?id=1971069  is pulled into to the next z-stream, i propose we close this as a duplicate?

closing this as it shouldn't be needed after the next  6.9.z.  Let me know if you disagree

*** This bug has been marked as a duplicate of bug 1971069 ***