Bug 1250760

Summary: Content View Filter by Date filter seems to be off a day
Product: Red Hat Satellite Reporter: jnikolak
Component: Content ViewsAssignee: Chris Peters <chpeters>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: high Docs Contact:
Priority: high    
Version: 6.0.8CC: bbuckingham, cwelton, jsherril, mmccune, walden
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: 2016-03-29 17:23:34 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:
Attachments:
Description Flags
after_filters
none
cv_filters
none
foreman_debug none

Description jnikolak 2015-08-06 00:59:40 UTC 
Created attachment 1059683 [details]
after_filters

Description of problem:

Customer has Satellite with Rhev environment, they are using Satellite 6 to provision hyper-visors.

The Satellite successfully provisions the hypervisor, however when they try to install a specific package they get and error:

That package is:
# libvirt-lock-sanlock

How reproducible:

Steps to Reproduce:
1. Create Satellite 6.0.8
2. Create RhevM, Cluster
3. Setup Satellite with provisioning
4. Setup Satellite with repositories

5. Setup Satellite with the following channels
-> rhel-6-server-rhev-mgmt-agent-rpms
-> rhel-6-server-rpms

6. Create the Host Groups, Activation Keys, Environment, OS
7. Create the Content view, for the above repos
8. Create an errata filter to filter out:

Exclude all packages after 29/04/2015.
(screenshot attached)


9. In Rhev create the machine, that will end up being provisioned
10. Provision the server using Satellite, with deploy on parameter, adding the network details in step 9(above step)

11. Check to see if the repo's exist on the hypervisor that was built. 

The package doesnt exist, that the installation is asking for.

yum list libvirt*
Loaded plugins: package_upload, product-id, security, subscription-manager
Installed Packages

libvirt.x86_64  0.10.2-46.el6_6.6             @rhel-6-server-rpms
libvirt-client.x86_64  0.10.2-46.el6_6.6      @rhel-6-server-rpms
libvirt-lock-sanlock.x86_64 0.10.2-46.el6_6.6 @rhel-6-server-rhev-mgmt-agent-rpms


12. yum install 

Failed to install Host DEV-nsdadbe101t. Failed to execute stage 'Package installation': [u'libvirt-lock-sanlock-0.10.2-46.el6_6.4.x86_64 requires libvirt = 0.10.2-46.el6_6.4'].
	
Failed to install Host DEV-nsdadbe101t. Yum [u'libvirt-lock-sanlock-0.10.2-46.el6_6.4.x86_64 requires libvirt = 0.10.2-46.el6_6.4'].
 


Why is the package being excluded when the package date
# 4/11/15 6:23:55 AM EST

The filter we excluded is only after the 29th.
"Exclude all packages after 29/04/2015."

See: https://rhn.redhat.com/rhn/software/packages/details/Overview.do?pid=1061668

When not excluding by date, the package is seen by the client.


Is the following bugzilla related to this? 
Do we have any workarounds?

Content view filter errata by date not working:
--> https://bugzilla.redhat.com/show_bug.cgi?id=1199100
Comment 1 jnikolak 2015-08-06 01:00:10 UTC 
Created attachment 1059684 [details]
cv_filters
Comment 2 jnikolak 2015-08-06 01:04:19 UTC 
Created attachment 1059686 [details]
foreman_debug
Comment 3 Justin Sherrill 2015-08-07 00:09:08 UTC 
tldr; 

publishing a content view with an errata exclude list of all errata after 4/29/2015 leaves you with a content view with errata from 4/29 and earlier.  Something is going wrong and we are off by 1 day.
Comment 6 Walden Raines 2015-12-03 15:50:30 UTC 
Is it possible that this is a duplicate of bug #1215756?  I changed the issued and updated columns to dates instead of timestamps which could fix this issue.
Comment 8 Chris Peters 2016-03-29 17:23:34 UTC 

*** This bug has been marked as a duplicate of bug 1215756 ***