+++ This bug was initially created as a clone of Bug #2052851 +++ Description of problem: Some packages are associated to multiple errata. Each of the errata has different issued/updated date. If one or more of those errata are within the date range of a exclude filter, all of them will be excluded. For example, Modular "lua-guestfs-1.40.2-24.module+el8.2.1+7154+47ffd890.x86_64.rpm" are associated to multiple errata in the advanced virtualization repo. If any of the erratum is excluded by the filter, others will also be excluded. ------------------------------------------------------- pp Katello::ErratumPackage.where(filename: "lua-guestfs-1.40.2-24.module+el8.2.1+7154+47ffd890.x86_64.rpm").map(&:erratum).collect{|et| [et.errata_id, et.is sued, et.updated]}.uniq.sort_by{|et| et[2]}.reverse [["RHSA-2021:5036", Wed, 08 Dec 2021, Wed, 08 Dec 2021], ["RHSA-2021:3704", Thu, 30 Sep 2021, Thu, 30 Sep 2021], ["RHSA-2021:2521", Tue, 22 Jun 2021, Tue, 22 Jun 2021], ["RHSA-2021:0743", Mon, 08 Mar 2021, Mon, 08 Mar 2021], ["RHSA-2021:0648", Tue, 23 Feb 2021, Tue, 23 Feb 2021], ["RHSA-2020:5111", Mon, 16 Nov 2020, Mon, 16 Nov 2020], ["RHSA-2020:4291", Tue, 20 Oct 2020, Tue, 20 Oct 2020], ["RHBA-2020:4221", Mon, 12 Oct 2020, Mon, 12 Oct 2020], ["RHSA-2020:3586", Tue, 01 Sep 2020, Tue, 01 Sep 2020], ["RHBA-2020:3172", Tue, 28 Jul 2020, Tue, 28 Jul 2020]] -------------------------------------------------------- Steps to Reproduce: Perform the following steps on Satellite 6.9 and 6.10 for comparison: 1. Enable and sync "Advanced Virtualization for RHEL 8 x86_64 RPMs" repo 2. Create a content view named "cv-virt-test" and attach the above repo 3. Create an include filter named "erratum_inclusion" and set end date as 11 September 2021 4. Create an exclude filter named "erratum_exclusion" and set start date as 01 September 2020 5. Publish the content view Actual results: Satellite 6.9: 988 Packages 16 Errata ( 5 11 0 ) 16 Module Streams Satellite 6.10: 809 Packages 8 Errata ( 3 5 0 ) 16 Module Streams Expected results: Should match the result of Satellite 6.9 Additional info: As we can see below the errata that updated before 01 September 2020 are excluded in Satellite 6.10 Result of Satellite 6.9: [ErrataID, Issued, Updated] ["RHBA-2020:3234", Wed, 29 Jul 2020, Wed, 29 Jul 2020], ["RHBA-2020:3172", Tue, 28 Jul 2020, Tue, 28 Jul 2020], ["RHBA-2020:2552", Mon, 15 Jun 2020, Mon, 15 Jun 2020], ["RHBA-2020:2017", Tue, 05 May 2020, Tue, 05 May 2020], ["RHBA-2020:1537", Wed, 22 Apr 2020, Wed, 22 Apr 2020], ["RHSA-2020:1261", Wed, 01 Apr 2020, Wed, 01 Apr 2020], ["RHSA-2020:0731", Thu, 05 Mar 2020, Thu, 05 Mar 2020], ["RHSA-2020:0555", Wed, 19 Feb 2020, Wed, 19 Feb 2020], ["RHBA-2020:0510", Mon, 17 Feb 2020, Mon, 17 Feb 2020], ["RHBA-2020:0404", Tue, 04 Feb 2020, Tue, 04 Feb 2020], ["RHBA-2019:3732", Wed, 06 Nov 2019, Wed, 06 Nov 2019], ["RHBA-2019:3723", Wed, 06 Nov 2019, Wed, 06 Nov 2019], ["RHBA-2019:2395", Wed, 07 Aug 2019, Wed, 07 Aug 2019], ["RHSA-2019:1762", Thu, 11 Jul 2019, Thu, 11 Jul 2019], ["RHSA-2019:1455", Tue, 11 Jun 2019, Tue, 11 Jun 2019], ["RHBA-2019:1293", Wed, 29 May 2019, Wed, 29 May 2019] Result of Satellite 6.10: [ErrataID, Issued, Updated] ["RHSA-2020:0555", Wed, 19 Feb 2020, Wed, 19 Feb 2020], ["RHBA-2020:0510", Mon, 17 Feb 2020, Mon, 17 Feb 2020], ["RHBA-2019:3723", Wed, 06 Nov 2019, Wed, 06 Nov 2019], ["RHBA-2019:3732", Wed, 06 Nov 2019, Wed, 06 Nov 2019], ["RHBA-2019:2395", Wed, 07 Aug 2019, Wed, 07 Aug 2019], ["RHSA-2019:1762", Thu, 11 Jul 2019, Thu, 11 Jul 2019], ["RHSA-2019:1455", Tue, 11 Jun 2019, Tue, 11 Jun 2019], ["RHBA-2019:1293", Wed, 29 May 2019, Wed, 29 May 2019] --- Additional comment from on 2022-02-11T01:10:55Z Created redmine issue https://projects.theforeman.org/issues/34437 --- Additional comment from on 2022-03-11T00:05:14Z Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/34437 has been resolved.
Steps to retest: Perform the following steps on Satellite 6.9 and 6.10 for comparison: 1. Enable and sync "Advanced Virtualization for RHEL 8 x86_64 RPMs" repo 2. Create a content view named "cv-virt-test" and attach the above repo 3. Create an include filter named "erratum_inclusion" and set end date as 11 September 2021 4. Create an exclude filter named "erratum_exclusion" and set start date as 01 September 2020 5. Publish the content view Actual results: Satellite 6.9: 988 Packages 16 Errata ( 5 11 0 ) 16 Module Streams Satellite 6.10: 988 Packages 16 Errata ( 5 11 0 ) 16 Module Streams Verified on 6.10.7 with tfm-rubygem-katello-4.1.1.60-1.el7sat.noarch
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Satellite 6.10.7 Async Bug Fix Update), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2022:5516
*** Bug 2092272 has been marked as a duplicate of this bug. ***