Plugins » Katello

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=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²}.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]