Bug 1101765

Summary: content views with date filters skip packages with no errata
Product: Red Hat Satellite Reporter: Erik M Jacobs <ejacobs>
Component: Content ManagementAssignee: Justin Sherrill <jsherril>
Status: CLOSED CURRENTRELEASE QA Contact: Ales Dujicek <adujicek>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.0.3CC: adujicek, cwelton, jmontleo, jsherril, mmccune
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-07-02 14:06:50 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Erik M Jacobs 2014-05-27 21:06:58 UTC
Description of problem:
When creating a content view on rhel-6-server-rpms, using an Errata by Date and Type filter results in packages that never had errata being missing from the published view.

Version-Release number of selected component (if applicable):
createrepo-0.9.9-21.2.pulp.el6sat.noarch
foreman-1.6.0.13-1.el6sat.noarch
foreman-compute-1.6.0.13-1.el6sat.noarch
foreman-gce-1.6.0.13-1.el6sat.noarch
foreman-libvirt-1.6.0.13-1.el6sat.noarch
foreman-ovirt-1.6.0.13-1.el6sat.noarch
foreman-postgresql-1.6.0.13-1.el6sat.noarch
foreman-proxy-1.6.0.6-1.el6sat.noarch
foreman-vmware-1.6.0.13-1.el6sat.noarch
katello-1.5.0-24.el6sat.noarch
katello-ca-1.0-1.noarch
katello-certs-tools-1.5.5-1.el6sat.noarch
katello-installer-0.0.44-1.el6sat.noarch
m2crypto-0.21.1.pulp-8.el6sat.x86_64
mod_wsgi-3.4-1.pulp.el6sat.x86_64
pulp-katello-plugins-0.3-1.el6sat.noarch
pulp-nodes-common-2.4.0-0.18.beta.el6sat.noarch
pulp-nodes-parent-2.4.0-0.18.beta.el6sat.noarch
pulp-puppet-plugins-2.4.0-0.18.beta.el6sat.noarch
pulp-puppet-tools-2.4.0-0.18.beta.el6sat.noarch
pulp-rpm-plugins-2.4.0-0.18.beta.el6sat.noarch
pulp-selinux-2.3.1-1.el6.noarch
pulp-server-2.4.0-0.18.beta.el6sat.noarch
python-isodate-0.5.0-1.pulp.el6sat.noarch
python-kombu-3.0.15-5.pulp.el6sat.noarch
python-pulp-bindings-2.4.0-0.18.beta.el6sat.noarch
python-pulp-common-2.4.0-0.18.beta.el6sat.noarch
python-pulp-puppet-common-2.4.0-0.18.beta.el6sat.noarch
python-pulp-rpm-common-2.4.0-0.18.beta.el6sat.noarch
ruby193-rubygem-foreman_bootdisk-2.0.6-1.1.el6sat.noarch
ruby193-rubygem-foreman_discovery-1.3.0-0.1.rc2.el6sat.noarch
ruby193-rubygem-foreman_hooks-0.3.5-2.el6sat.noarch
ruby193-rubygem-foreman-redhat_access-0.0.3-1.el6sat.noarch
ruby193-rubygem-foreman-tasks-0.5.4-2.el6sat.noarch
ruby193-rubygem-katello-1.5.0-48.el6sat.noarch
rubygem-hammer_cli_foreman-0.1.0-15.el6sat.noarch
rubygem-hammer_cli_foreman_tasks-0.0.2-6.el6sat.noarch
rubygem-hammer_cli_katello-0.0.3-26.el6sat.noarch

How reproducible:
100%

Steps to Reproduce:
1. Create a content view
2. Add the RHEL6 Server product/repos
3. Create an Errata by Date & Type filter for "19-November-2013"
4. Publish and promote it
5. Do a content search or a "yum info" on compat-readline5

Actual results:
The package is not in the promoted/published repo.

Expected results:
The package should be there.

Additional info:
https://rhn.redhat.com/rhn/software/packages/details/Overview.do?pid=585642

compat-readline5 was introduced in EL6 and never had any updates, therefore there are no errata related to it.

It appears that only packages that had some kind of errata at least once are included when using this date filter.

I think what we need to be doing is something like:

- When a user creates an "Errata by Date & Type" filter and sets a date
  - We should include all packages' errata before that date
  - We should include all packages with no errata in the repo

Comment 1 Justin Sherrill 2014-05-27 21:08:23 UTC
http://projects.theforeman.org/issues/5449

Comment 2 RHEL Program Management 2014-05-27 21:13:35 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 6 Ales Dujicek 2014-06-24 13:13:26 UTC
Verified. Satellite-6.0.3-RHEL-6-20140620.0

compat-readline5 was listed using content search

Comment 7 Bryan Kearney 2014-07-02 14:06:50 UTC
This was delivered with 6.0.3, which is the Satellite 6 Beta.