Bug 1222673 - Incorrect errata count shown on Content -> Errata page
Summary: Incorrect errata count shown on Content -> Errata page
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Content Management
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: Walden Raines
QA Contact: sthirugn@redhat.com
URL:
Whiteboard: rails-3.2.8
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-05-18 19:23 UTC by sthirugn@redhat.com
Modified: 2017-02-23 20:01 UTC (History)
6 users (show)

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


Attachments (Terms of Use)
Incorrect errata count (101.47 KB, image/png)
2015-05-18 19:23 UTC, sthirugn@redhat.com
no flags Details
RHEL 7 repository shows 555 errata (186.51 KB, image/png)
2015-06-10 15:00 UTC, Og Maciel
no flags Details
Applicable errata count is 29 (160.86 KB, image/png)
2015-06-10 15:01 UTC, Og Maciel
no flags Details
Showing all the 555 errata (146.27 KB, image/png)
2015-06-10 15:02 UTC, Og Maciel
no flags Details
Reproduced the issue on SNAP 7 Compose 2 (197.37 KB, image/png)
2015-06-10 18:08 UTC, Og Maciel
no flags Details
verification screenshot (324.66 KB, application/zip)
2015-07-07 16:38 UTC, sthirugn@redhat.com
no flags Details
another verification screenshot (151.29 KB, image/png)
2015-07-07 16:38 UTC, sthirugn@redhat.com
no flags Details

Description sthirugn@redhat.com 2015-05-18 19:23:56 UTC
Created attachment 1026844 [details]
Incorrect errata count

Description of problem:
Incorrect errata count shown on Content -> Errata page

Version-Release number of selected component (if applicable):
Sat 6.1 GA Snap 4

How reproducible:
Always

Steps to Reproduce:
1. Sync 7Server repo - Red Hat Enterprise Linux 7 Server RPMs x86_64 7Server - I got 
* 6984 Packages
* 551 Errata 
2. Create a content view with this repo and add the content view to an activation key.  Add right subscriptions to activation key
3. Register and subscribe a content host using the activation key and make sure it is green
4. Now, navigate to Content -> Errata -> in the repo dropdown, select the 7Server repo

Actual results:
It showed:
* Showing 14 of 14 (26 Total)

I am not sure what 26 is referring to.  I am expecting to see 14 Total.

Then I uncheck Applicable check box. It showed:
* Showing 20 of 551 (551 Total)

This seems to be correct as I have shown in the Steps to Reproduce -> Step 1

Expected results:
Explained above

Additional info:

Comment 3 Walden Raines 2015-05-27 19:12:12 UTC
Haven't started on this yet so changing back to NEW in case any one else wants to grab it.

Comment 4 Walden Raines 2015-05-27 22:14:41 UTC
I cannot reproduce this given the steps provided.  Is there anything else I need to do?

Comment 5 sthirugn@redhat.com 2015-06-01 15:06:42 UTC
Updated Steps to reproduce:
1. Sync 7Server repo - Red Hat Enterprise Linux 7 Server RPMs x86_64 7Server - I got 
* 6984 Packages
* 551 Errata 
2. Create a content view cv1 with this repo.  Add cv1 to an activation key ak1.
3. Create another content view cv2 with the same repo and add errata type filters.  Add cv2 to an activation key ak2.
4. Register and subscribe two cotnent hosts to ak1 and ak2 make sure it is green
5. Now, navigate to Content -> Errata -> in the repo dropdown, select the 7Server repo

Comment 6 Justin Sherrill 2015-06-05 22:41:38 UTC
I think the way to reproduce this is:

1.  Sync a rhel 6 or 7 OS repo
2.  Publish a content view with some or all of the errata from that repo
3.  Register a system that needs errata, visit the errata page and note that some errata are applicable>  The counts should be wrong
4.  publish to a new content view, seems to increase this count. 

The more content views the higher the count

Comment 7 Og Maciel 2015-06-10 15:00:09 UTC
Created attachment 1037341 [details]
RHEL 7 repository shows 555 errata

RHEL 7 repository shows 555 errata

Comment 8 Og Maciel 2015-06-10 15:01:29 UTC
Created attachment 1037343 [details]
Applicable errata count is 29

Here we see that the number of applicable errata is 29 and we are listing 20/29

Comment 9 Og Maciel 2015-06-10 15:02:36 UTC
Created attachment 1037344 [details]
Showing all the 555 errata

When I uncheck the 'Applicable' checkbox I get the expected 555 errata listed

Comment 10 Og Maciel 2015-06-10 16:21:49 UTC
Comments #7 thru #9 are the screenshots that cover the scenario:

* Sync RHEL 7 RPMs
* Create content view with RHEL 7 RPMs and an **exclude** filter of Errata by DATE
* Published/Promoted content view
* Created activation key associated with content view
* Provisioned a RHEL 7 host using a host group associated to the activation key

It looks like the expected behavior is working.

Comment 11 Walden Raines 2015-06-10 16:33:25 UTC
Moving to ON_QA per comment#10

Comment 12 Og Maciel 2015-06-10 18:08:02 UTC
Created attachment 1037395 [details]
Reproduced the issue on SNAP 7 Compose 2

Finally was able to reproduce it. I believe that there are 2 important steps to verify this:

* Make sure to select the 'All Repositories' entry (and not filter by 'RHEL 7' repo as stated in the issue)
* Make sure that you synchronize RPMs for RHEL 7 **and** RHEL 6 (Walden only had RHEL 7 content when he tried to reproduce it)

The attached screenshot shows the discrepancy (20 of 29 (100 total))

Comment 13 Og Maciel 2015-06-10 18:08:40 UTC
This has failed on SNAP 7 Compose 2 as per comment #12.

Comment 15 Walden Raines 2015-06-19 13:14:29 UTC
Merged downstream 400fe2b732a554fe0139aaa0856128882fa33add.

Comment 16 Bryan Kearney 2015-06-26 14:32:47 UTC
Delivered in Snap10

Comment 17 sthirugn@redhat.com 2015-07-07 16:37:46 UTC
Verified in GA Snap 11.  Screenshots attached.

Comment 18 sthirugn@redhat.com 2015-07-07 16:38:10 UTC
Created attachment 1049461 [details]
verification screenshot

Comment 19 sthirugn@redhat.com 2015-07-07 16:38:36 UTC
Created attachment 1049462 [details]
another verification screenshot

Comment 20 Bryan Kearney 2015-08-12 16:03:16 UTC
This bug was fixed in Satellite 6.1.1 which was delivered on 12 August, 2015.


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