Bug 1483136

Summary: Bulk package profile update calls right after client registration causes failure of subsequent client registrations to Satellite
Product: Red Hat Satellite Reporter: sthirugn <sthirugn>
Component: RegistrationAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.11CC: bbuckingham, bkearney, oshtaier, sthirugn
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-09-15 17:43:08 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 sthirugn@redhat.com 2017-08-18 20:06:18 UTC
Description of problem:
Bulk package profile update calls right after client registration causes failure of subsequent client registrations to Satellite.

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

How reproducible:
Always

Steps to Reproduce:
1. Register multiple clients (5 to 10) to Satellite6 concurrently - with each of them running puppet modules to pull content from Satellite6 right after registration

Actual results:
In the customer environment, there were 40 package profile updates per host right after client registration which slowed down Satellite and made subsequent client registrations to fail.  Note that the subscription-manager on the client have a 60 sec default timeout which is not configurable at this time.

Expected results:
Reduce the package profile update processing time so cases like this (40 package profile updates per host right after registration) does not consume lot of Satellite resources and delay registration of subsequent clients.

Additional info:
Package profile processing logic needs to be improved to make it faster
- During the investigation, it was found that katello_installed_packages need to be indexed as this table might grow very quickly
- Need to de-duplicate the data in the table

Comment 4 sthirugn@redhat.com 2017-09-15 17:43:08 UTC
@Bryan, this is taken care of https://bugzilla.redhat.com/show_bug.cgi?id=1483677

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