Bug 1199100 - Content view filter errata by date not working
Summary: Content view filter errata by date not working
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Content Management
Version: 6.0.8
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: Unspecified
Assignee: Justin Sherrill
QA Contact: sthirugn@redhat.com
URL:
Whiteboard:
Depends On:
Blocks: 1122832
TreeView+ depends on / blocked
 
Reported: 2015-03-05 13:19 UTC by Peter Vreman
Modified: 2019-08-15 04:20 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-08-12 14:00:30 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1199095 0 unspecified CLOSED Errata not visible by yum updateinfo 2021-02-22 00:41:40 UTC

Internal Links: 1199095

Description Peter Vreman 2015-03-05 13:19:13 UTC
Description of problem:
Packages belong to an errata that has been excluded by date are still included.
I have a content view with a filter on 24-Feb-2015. But the client that uses this Content View also sees the kernel 2.6.32-431.50.1.el6 that is included
in the errata RHSA-2015:0284-1 issued on 3-Mar-2015.

Configuration of Content View:

#  hammer -c /opt/hoici/etc/sat6/hammer-hoici.yaml content-view info --id=6
ID:                 6
Name:               product-HOIOS-6.5.0-sp17
Label:              product-HOIOS-6_5_0-sp17
Composite:
Description:
Content Host Count:
Organization:       Hilti
Repositories:
 1) ID:    76
    Name:  HOIOS-6.5.0-sp17
    Label: HOIOS-6_5_0-sp17
 2) ID:    24
    Name:  Red Hat Enterprise Linux 6 Server - Extended Update Support - Optional RPMs x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_-_Extended_Update_Support_-_Optional_RPMs_x86_64_6_5
 3) ID:    30
    Name:  Red Hat Enterprise Linux 6 Server - Extended Update Support - Oracle Java RPMs x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_-_Extended_Update_Support_-_Oracle_Java_RPMs_x86_64_6_5
 4) ID:    21
    Name:  Red Hat Enterprise Linux 6 Server - Extended Update Support RPMs x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_-_Extended_Update_Support_RPMs_x86_64_6_5
 5) ID:    1
    Name:  Red Hat Enterprise Linux 6 Server Kickstart x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_Kickstart_x86_64_6_5
 6) ID:    13
    Name:  Red Hat Enterprise Linux 6 Server - RH Common RPMs x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_-_RH_Common_RPMs_x86_64_6_5
 7) ID:    37
    Name:  Red Hat Software Collections RPMs for Red Hat Enterprise Linux 6 RHEL 6 Server EUS x86_64 6.5
    Label: Red_Hat_Software_Collections_RPMs_for_Red_Hat_Enterprise_Linux_6_RHEL_6_Server_EUS_x86_64_6_5


# hammer -c /opt/hoici/etc/sat6/hammer-hoici.yaml content-view filter list --content-view-id=6
----------|------------------------------------------------|---------|----------
FILTER ID | NAME                                           | TYPE    | INCLUSION
----------|------------------------------------------------|---------|----------
12        | product-HOIOS-6.5.0-sp17 Post Freeze Additions | erratum | true
11        | product-HOIOS-6.5.0-sp17 Freeze Date           | erratum | true
10        | product-HOIOS-6.5.0-sp17 Original Packages     | rpm     | true
----------|------------------------------------------------|---------|----------

# hammer -c /opt/hoici/etc/sat6/hammer-hoici.yaml content-view filter info --id=10
Filter ID:    10
Name:         product-HOIOS-6.5.0-sp17 Original Packages
Type:         rpm
Inclusion:    true
Repositories:

Rules:

# hammer -c /opt/hoici/etc/sat6/hammer-hoici.yaml content-view filter info --id=11
Filter ID:    11
Name:         product-HOIOS-6.5.0-sp17 Freeze Date
Type:         erratum
Inclusion:    true
Repositories:

Rules:
 1) ID:         4
    Start Date: 2000-01-01
    End Date:   2015-02-24
    Types:      enhancement, bugfix, security
    Created:    2015/03/04 07:17:57
    Updated:    2015/03/04 07:17:58

# hammer -c /opt/hoici/etc/sat6/hammer-hoici.yaml content-view filter info --id=12
Filter ID:    12
Name:         product-HOIOS-6.5.0-sp17 Post Freeze Additions
Type:         erratum
Inclusion:    true
Repositories:

Rules:



Client output

$ sudo yum list kernel
Loaded plugins: changelog, downloadonly, package_upload, product-id, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
Hilti_HOIOS_HOIOS-6_5_0-sp17                                                                                           | 2.1 kB     00:00
Hilti_HOIPRODUCTS_HOIPRODUCTS-1_0_0-sp17                                                                               | 2.1 kB     00:00
rhel-6-server-eus-optional-rpms                                                                                        | 1.8 kB     00:00
rhel-6-server-eus-rpms                                                                                                 | 2.1 kB     00:00
Installed Packages
kernel.x86_64                           2.6.32-431.el6                                 @anaconda-RedHatEnterpriseLinux-201311111358.x86_64/6.5
kernel.x86_64                           2.6.32-431.40.2.el6                            @rhel-6-server-eus-rpms
kernel.x86_64                           2.6.32-431.46.2.el6                            @rhel-6-server-eus-rpms
Available Packages
kernel.x86_64                           2.6.32-431.50.1.el6                            rhel-6-server-eus-rpms



Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. Create a Content View with the RedHat Repos and Filters listed above
2. Publish Content View
4. Client: check sudo yum list kernel

Actual results:
Kernel 2.6.32-431.50.1.el6 is listed

Expected results:
Kernel 2.6.32-431.50.1.el6 is not listed and also not available.
The latest kernel shall be 2.6.32-431.46.2.el6 that has an errata issued on 20-Jan-2015

Additional info:

Comment 1 RHEL Program Management 2015-03-05 13:23:16 UTC
Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

Comment 3 Peter Vreman 2015-03-10 16:56:50 UTC
With a new Content View build i see the same error again with the ksh errata RHBA-2015:0654-1

The Content View has a freeze date of 2015-03-08, when i republished the content view today to add a include to the Custom product. I also got unexpected an update for ksh:

$ sudo yum update --changelog ksh
Loaded plugins: changelog, downloadonly, package_upload, product-id, security, subscription-manager
...
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package ksh.x86_64 0:20120801-10.el6_5.12 will be updated
---> Package ksh.x86_64 0:20120801-10.el6_5.13 will be an update
--> Finished Dependency Resolution

Changes in packages about to be updated:

ChangeLog for: ksh-20120801-10.el6_5.13.x86_64
* Tue Feb 24 12:00:00 2015 Michal Hlavinka <mhlavink> - 20120801-10.13
- do not inherit invalid variables during shell initializaton (#1195648)


The errata for 6.5-EUS that i as a user are attended on:

Advisory: 	RHBA-2015:0654-1
Type: 	Bug Fix Advisory
Severity: 	N/A
Issued on: 	2015-03-09
Last updated on: 	2015-03-09

It might be that it used the date of the original 6Server errata:

Advisory: 	RHBA-2015:0273-1
Type: 	Bug Fix Advisory
Severity: 	N/A
Issued on: 	2015-03-02
Last updated on: 	2015-03-02


For me as a user this is not clear. I am notified with an mail on Mo 09.03.2015 19:05 that refers to an errata with an issue date of 2015-03-09.
My expectation is that this errata is then also not included, even when the original build was from some days earlier.

Comment 7 Justin Sherrill 2015-06-04 15:56:10 UTC
This is currently a blocker for 6.1, so it should get included.

Comment 8 Justin Sherrill 2015-06-04 16:49:08 UTC
Out of curiosity, did either of you have both el6 and el7 synced?  

I am still investigating this, but https://bugzilla.redhat.com/show_bug.cgi?id=1171278  could be the root cause of this.

Comment 9 Justin Sherrill 2015-06-04 17:22:44 UTC
Oops,  https://bugzilla.redhat.com/show_bug.cgi?id=1171283  is the correct bug.  A hotfix is available for 6.0, and it will be fixed in 6.1.

I am not able to reproduce this issue on 6.1 and am 95% certain the mentioned bz is the root cause.  Moving to ON_QA

Comment 10 sthirugn@redhat.com 2015-06-04 18:30:57 UTC
I am not able to reproduce this in recent Sat 6.1 GA Snap 7 build.

Verification steps:
1. Sync rhel 7Server repo.  Create a content view with rhel 7Server repo.

2. Create a filter to filter out errata from Dec 1 2014 to today.

3. Attempt to install a package from RHSA-2015:0986 which was issued on 5/12/2015
# yum install kexec-tools
Loaded plugins: package_upload, product-id, subscription-manager
rhel-7-server-rpms                               | 2.1 kB     00:00     
sat6-tools                                       | 2.1 kB     00:00     
(1/2): sat6-tools/primary                          |  20 kB   00:00     
(2/2): sat6-tools/updateinfo                       |   93 B   00:00     
sat6-tools                                                        82/82
Package matching kexec-tools-2.0.4-32.el7_0.5.x86_64 already installed. Checking for update.
Nothing to do

4. Add a new product with a new repo - sync it.  Add this repo to the content view mentioned in Step 1 - republish, repromote.  Also added the new custom product to activation key and re-registered the content host inorder to get the custom product subscriptions

5. Attempt to install a package from RHSA-2015:0986 again to see if it is included in the content view
# yum install kexec-tools
Loaded plugins: package_upload, product-id, subscription-manager
clKdwrkW_fakeproduct1_fakerepo1                    | 2.1 kB     00:00     
rhel-7-server-rpms                                 | 2.1 kB     00:00     
Package matching kexec-tools-2.0.4-32.el7_0.5.x86_64 already installed. Checking for update.
Nothing to do

6. Attempt to install a package from the newly added custom product
[root@cloud-qe-4 ~]# yum install Antelope
Loaded plugins: package_upload, product-id, subscription-manager
clKdwrkW_fakeproduct1_fakerepo1                    | 2.1 kB     00:00     
rhel-7-server-rpms                                 | 2.1 kB     00:00     
Resolving Dependencies
--> Running transaction check
---> Package Antelope.noarch 0:10.6.9-1.elfake will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================
 Package  Arch   Version            Repository                       Size
==========================================================================
Installing:
 Antelope noarch 10.6.9-1.elfake    clKdwrkW_fakeproduct1_fakerepo1  13 k

Transaction Summary
==========================================================================
Install  1 Package

Total download size: 13 k
Installed size: 10 k
Is this ok [y/d/N]:

Comment 11 Peter Vreman 2015-06-11 08:53:01 UTC
We have the repositories for the following redhat releases enabled:

6.5
6.5-EUS
6.6
6.6-EUS
6Server
7.1
7.1-EUS
7Server

Comment 12 sthirugn@redhat.com 2015-06-16 23:19:49 UTC
I retested again adding EUS repos to my rhel 6 content view:

hammer> content-view info --id 12
ID:                     12
Name:                   rhel6cv
Label:                  rhel6cv
Composite:              
Description:            
Content Host Count:     1
Organization:           cOTN7gdN
Yum Repositories:       
 1) ID:    27
    Name:  Red Hat Enterprise Linux 6 Server - Extended Update Support RPMs x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_-_Extended_Update_Support_RPMs_x86_64_6_5
 2) ID:    28
    Name:  Red Hat Enterprise Linux 6 Server - Extended Update Support RPMs x86_64 6.6
    Label: Red_Hat_Enterprise_Linux_6_Server_-_Extended_Update_Support_RPMs_x86_64_6_6
 3) ID:    21
    Name:  Red Hat Enterprise Linux 6 Server RPMs x86_64 6.3
    Label: Red_Hat_Enterprise_Linux_6_Server_RPMs_x86_64_6_3
 4) ID:    22
    Name:  Red Hat Enterprise Linux 6 Server RPMs x86_64 6.4
    Label: Red_Hat_Enterprise_Linux_6_Server_RPMs_x86_64_6_4
 5) ID:    19
    Name:  Red Hat Enterprise Linux 6 Server RPMs x86_64 6.5
    Label: Red_Hat_Enterprise_Linux_6_Server_RPMs_x86_64_6_5
 6) ID:    20
    Name:  Red Hat Enterprise Linux 6 Server RPMs x86_64 6.6
    Label: Red_Hat_Enterprise_Linux_6_Server_RPMs_x86_64_6_6
Docker Repositories:    

Puppet Modules:         

Lifecycle Environments: 
 1) ID:   4
    Name: QE
 2) ID:   3
    Name: DEV
 3) ID:   2
    Name: Library
Versions:               
 1) ID:        11
    Version:   1.0
    Published: 2015/06/16 22:04:11
Components:             

Activation Keys:        
 1) rhel6ak




hammer> content-view filter list --content-view-id=12
----------|------|---------|----------
FILTER ID | NAME | TYPE    | INCLUSION
----------|------|---------|----------
4         | cvf1 | erratum | true     
----------|------|---------|----------


hammer> content-view filter info --id=4
Filter ID:    4
Name:         cvf1
Type:         erratum
Inclusion:    true
Repositories: 

Rules:        
 1) ID:         4
    Start Date: 2000-01-02T00:00:00.000Z
    End Date:   2015-03-04T05:00:00.000Z
    Types:      security, enhancement, bugfix
    Created:    2015/06/16 22:03:41
    Updated:    2015/06/16 22:04:07


On the client:
# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.5 (Santiago)

# yum info kernel
Loaded plugins: package_upload, product-id, security, subscription-
              : manager
This system is receiving updates from Red Hat Subscription Management.
rhel-6-server-eus-rpms                         | 2.1 kB     00:00     
rhel-6-server-rpms                             | 2.1 kB     00:00     
Installed Packages
Name        : kernel
Arch        : x86_64
Version     : 2.6.32
Release     : 431.el6
Size        : 121 M
Repo        : installed
From repo   : anaconda-RedHatEnterpriseLinux-201311111358.x86_64
Summary     : The Linux kernel
URL         : http://www.kernel.org/
License     : GPLv2
Description : The kernel package contains the Linux kernel (vmlinuz),
            : the core of any Linux operating system.  The kernel
            : handles the basic functions of the operating system:
            : memory allocation, process allocation, device input and
            : output, etc.

Available Packages
Name        : kernel
Arch        : x86_64
Version     : 2.6.32
Release     : 431.50.1.el6
Size        : 28 M
Repo        : rhel-6-server-eus-rpms
Summary     : The Linux kernel
URL         : http://www.kernel.org/
License     : GPLv2
Description : The kernel package contains the Linux kernel (vmlinuz),
            : the core of any Linux operating system.  The kernel
            : handles the basic functions of the operating system:
            : memory allocation, process allocation, device input and
            : output, etc.


Note the release version of the kernel Version:2.6.32, Release: 431.50.1.el6 - This belongs to errata 'RHSA-2015:0284' which was issues on 3/3/2015.

So this correctly excluded two kernel erratas:
- RHSA-2015:0782 - kernel-2.6.32-431.53.2.el6.x86_64 - Issued on 5/19/15
- RHBA-2015:1017 - kernel-2.6.32-431.56.1.el6.x86_64 - Issued on 4/17/15

Comment 13 sthirugn@redhat.com 2015-06-16 23:20:18 UTC
Marking this verified for Sat 6.1 GA Snap 8.

Comment 14 sthirugn@redhat.com 2015-06-16 23:22:24 UTC
Hi Peter, 
Thank you for your inputs.  My tests show that this works fine. See Comment 12. Please reopen this issue if you find this happening in any newer builds. Thanks you!

Comment 15 Bryan Kearney 2015-08-11 13:25:53 UTC
This bug is slated to be released with Satellite 6.1.

Comment 16 Bryan Kearney 2015-08-12 14:00:30 UTC
This bug was fixed in version 6.1.1 of Satellite which was released on 12 August, 2015.


Note You need to log in before you can comment on or make changes to this bug.