[Katello 4.10 / Foreman 3.8] Difference in filter processing

Problem:
Despite the same filters, there is still a difference in filter processing.

In all CV, there are 2 repos activated:
RHEL 8 BaseOS and RHEL 8 AppStream

The filters are:
β†’ Exclude errata released after November 10, 2023

β†’ Include all non-errata RPMs
β†’ Include all non-errata Module Streams

On same Katello instance but in the different organization:

CV published on November 13:
47360 packages including 4515 errata and 717 module streams

It looks OK :slight_smile: .

CV published after November 14 (Note that Red Hat released a lot of errata on November 14) with the same filters:
47390 packages including 4517 errata and 717 module streams
2 excess errata: RHBA-2023:7075 and RHEA-2023:7088

How can we explain the difference in counters? :frowning:

Expected outcome:
Counters must be identical

Foreman and Proxy versions:

  • candlepin-4.3.1-1.el8.noarch
  • candlepin-selinux-4.3.1-1.el8.noarch
  • foreman-3.8.0-1.el8.noarch
  • foreman-cli-3.8.0-1.el8.noarch
  • katello-4.10.0-1.el8.noarch

Distribution and version:
RHEL 8.8

Do the BaseOS and Appstream repos in both orgs have the same content or does the org2 have additional content as well?

We synchronize every day so yes it’s the same content.

The CV was published on November 13. The filters are respected. Errata are taken into account until November 10.

The problem is reproducible. Just put the same filters shown above.

When we publish the CV after November 14, there are 2 excess errata.

I can’t explain why or the filters are not β€œperfect”?
Normally, if I want to exclude on a desired date, it’s easier to process with the appropriate requests.

Note: Solver Dependency is disabled.