Yeah seems that the host which has the working errata has that errata repo bound to it. Whilst the not working one doesn’t have.
Loading production environment (Rails 6.0.3.7)
irb(main):001:0> ::Katello::Erratum.group(:errata_id).having("count(errata_id) > 1").pluck(:errata_id)
=> []
irb(main):002:1* bound_repos = ::Host.find_by(name: "errata-not-working-host.name.domain").content_facet.bound_repositories.collect do |repo|
irb(main):003:1*
irb(main):004:1* repo.library_instance_id.nil? ? repo.id : repo.library_instance_id
irb(main):005:1*
irb(main):006:0> end
=> [5, 7, 6]
irb(main):007:1* bound_repos = ::Host.find_by(name: "working-host.name.domain").content_facet.bound_repositories.collect do |repo|
irb(main):008:1*
irb(main):009:1* repo.library_instance_id.nil? ? repo.id : repo.library_instance_id
irb(main):010:1*
irb(main):011:0> end
=> [11, 5, 7, 6]
irb(main):012:0>
irb(main):007:0> ::Katello::Repository.find(bound_repos)
=> [#<Katello::Repository id: 5, pulp_id: "927242c5-7fdd-41d3-a199-90eb534cfd37", library_instance_id: nil, content_view_version_id: 1, relative_path: "Company/Library/custom/Centos7/extras_x86_64", environment_id: 1, saved_checksum_type: nil, distribution_version: nil, distribution_arch: nil, distribution_bootable: nil, distribution_family: nil, distribution_variant: nil, container_repository_name: nil, root_id: 5, remote_href: "/pulp/api/v3/remotes/rpm/rpm/e8ff9395-65a0-4b0c-82...", publication_href: "/pulp/api/v3/publications/rpm/rpm/eba67d6e-cdb6-42...", version_href: "/pulp/api/v3/repositories/rpm/rpm/b3cbbe16-bc34-4b...", last_contents_changed: "2022-03-04 12:00:15", last_applicability_regen: "2022-03-04 12:07:42", last_indexed: "2022-04-21 11:22:25">,
#<Katello::Repository id: 7, pulp_id: "eba5f2b6-2b21-4ed3-b9e6-8973f7a1d098", library_instance_id: nil, content_view_version_id: 1, relative_path: "Company/Library/custom/Centos7/updates_x86_64", environment_id: 1, saved_checksum_type: nil, distribution_version: nil, distribution_arch: nil, distribution_bootable: nil, distribution_family: nil, distribution_variant: nil, container_repository_name: nil, root_id: 7, remote_href: "/pulp/api/v3/remotes/rpm/rpm/031db795-0c68-450d-a0...", publication_href: "/pulp/api/v3/publications/rpm/rpm/bef78f50-6ede-42...", version_href: "/pulp/api/v3/repositories/rpm/rpm/7feda14a-1e2a-45...", last_contents_changed: "2022-04-16 11:01:44", last_applicability_regen: "2022-04-16 11:07:43", last_indexed: "2022-04-21 11:22:43">,
#<Katello::Repository id: 6, pulp_id: "bd722086-e668-492c-b7bc-f3dea81dd8ee", library_instance_id: nil, content_view_version_id: 1, relative_path: "Company/Library/custom/Centos7/os_x86_64", environment_id: 1, saved_checksum_type: nil, distribution_version: "7", distribution_arch: "x86_64", distribution_bootable: true, distribution_family: "CentOS", distribution_variant: "CentOS", container_repository_name: nil, root_id: 6, remote_href: "/pulp/api/v3/remotes/rpm/rpm/1d982e1c-9bde-4747-a4...", publication_href: "/pulp/api/v3/publications/rpm/rpm/467e12c0-5782-4c...", version_href: "/pulp/api/v3/repositories/rpm/rpm/ec8b8ab5-e2fe-42...", last_contents_changed: "2022-04-21 11:15:30", last_applicability_regen: "2022-04-21 11:25:24", last_indexed: "2022-04-21 11:23:37">,
#<Katello::Repository id: 11, pulp_id: "4d9b2f74-f050-447a-acbe-402c84825b14", library_instance_id: nil, content_view_version_id: 1, relative_path: "Company/Library/custom/Centos7/centos-7-errata", environment_id: 1, saved_checksum_type: nil, distribution_version: nil, distribution_arch: nil, distribution_bootable: nil, distribution_family: nil, distribution_variant: nil, container_repository_name: nil, root_id: 11, remote_href: "/pulp/api/v3/remotes/rpm/rpm/c8be6a59-657a-4271-ac...", publication_href: "/pulp/api/v3/publications/rpm/rpm/e63ca2a4-12de-4c...", version_href: "/pulp/api/v3/repositories/rpm/rpm/84e3db6e-07b2-4c...", last_contents_changed: "2022-04-15 05:00:26", last_applicability_regen: "2022-04-15 05:01:08", last_indexed: "2022-04-21 11:01:01">]
irb(main):008:0>
# hammer repository list
11 | centos-7-errata | Centos7 | yum |
I also checked the other working hosts which have the centos errata working and they too have the repo 11 listed as bound.
So how can the bound repositories be fixed?