Description of problem: Even with https://bugzilla.redhat.com/show_bug.cgi?id=2044314 fixed, there are some cases when katello wrongly calculates list of errata to send in email notification. Particular example: RHSCL 7Server prior RHSA-2022:5759 released (i.e. have CDN content prior 2022-07-28) and after he errata released. Syncing the repo means "Added Rpms: 22, Errata: 1" but notification mail to contain 146 errata. Explanation provided in https://bugzilla.redhat.com/show_bug.cgi?id=2102867#c2, internal reproducer available at https://bugzilla.redhat.com/show_bug.cgi?id=2102867#c4 . The #c2 also suggests a potential fix. I am raising a new BZ since I cant reopen the https://bugzilla.redhat.com/show_bug.cgi?id=2044314 one. Version-Release number of selected component (if applicable): 6.11.1 How reproducible: 100% with reproducer per https://bugzilla.redhat.com/show_bug.cgi?id=2102867#c4 Steps to Reproduce: 1. Have RHSCL repo with metadata per https://bugzilla.redhat.com/show_bug.cgi?id=2102867#c4 , sync it 2. Update the metadata to the newest, sync it 3. Check errata mail sent and also the postgres queries from https://bugzilla.redhat.com/show_bug.cgi?id=2102867#c2 . Actual results: 3. Mail with 146 errata sent, psql queries like per https://bugzilla.redhat.com/show_bug.cgi?id=2102867#c2. Expected results: 3. Mail with 1 errata sent only. Additional info:
This appears to be a duplicate of 2105299 *** This bug has been marked as a duplicate of bug 2105299 ***
Re-opening this as the bug is sufficiently different from 2105299
Moving this bug to POST for triage into Satellite since the upstream issue https://projects.theforeman.org/issues/35503 has been resolved.
Created attachment 1930053 [details] Hotfix RPM for Satellite 6.10.7 Hotfix RPM for Satellite 6.10.7 NOTE: This hotfix contains the fixes for the following BZs: 2133615, 2133343, 2044314, 2116375 INSTALL INSTRUCTIONS: 1. Take a complete backup or snapshot of Satellite 6.10.7 server 2. Download the hotfix RPM attached to this BZ and copy it to Satellite server 3. # yum install ./tfm-rubygem-katello-4.1.1.60-4.HOTFIXRHBZ2133615.el7sat.noarch.rpm --disableplugin=foreman-protector 4. # satellite-maintain service restart
Created attachment 1930105 [details] Hotfix RPM for Satellite 6.11.4 on RHEL7 NOTE: This hotfix contains the fixes for the following BZs: 2133615, 2133343, 2116375 INSTALL INSTRUCTIONS: 1. Take a complete backup or snapshot of Satellite 6.11.4 server 2. Download the hotfix RPM attached to this BZ and copy it to Satellite server 3. # yum install ./tfm-rubygem-katello-4.3.0.50-2.HOTFIXRHBZ2133615.el7sat.noarch.rpm --disableplugin=foreman-protector 4. # satellite-maintain service restart
Created attachment 1930108 [details] Hotfix RPM for Satellite 6.11.4 on RHEL8 NOTE: This hotfix contains the fixes for the following BZs: 2133615, 2133343, 2116375 INSTALL INSTRUCTIONS: 1. Take a complete backup or snapshot of Satellite 6.11.4 server 2. Download the hotfix RPM attached to this BZ and copy it to Satellite server 3. # dnf install ./rubygem-katello-4.3.0.50-2.HOTFIXRHBZ2133615.el8sat.noarch.rpm --disableplugin=foreman-protector 4. # satellite-maintain service restart
Created attachment 1930116 [details] Hotfix RPM for Satellite 6.12.0 NOTE: This hotfix contains the fixes for the following BZs: 2133615, 2133343, 2116375 INSTALL INSTRUCTIONS: 1. Take a complete backup or snapshot of Satellite 6.12.0 server 2. Download the hotfix RPM attached to this BZ and copy it to Satellite server 3. # dnf install ./rubygem-katello-4.5.0.20-2.HOTFIXRHBZ2133615.el8sat.noarch.rpm --disableplugin=foreman-protector 4. # satellite-maintain service restart
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 (Important: Satellite 6.13 Release), 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/RHSA-2023:2097