Bug 2170485

Summary:	Importing Red Hat Repository Import on Disconnected Red Hat Satellite taking huge time around 5 hours
Product:	Red Hat Satellite	Reporter:	Yogendra <yyadav>
Component:	Pulp	Assignee:	satellite6-bugs <satellite6-bugs>
Status:	VERIFIED ---	QA Contact:	Vladimír Sedmík <vsedmik>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.11.4	CC:	ahumbe, dalley, dkliban, ggainey, jpasqual, lmjachky, rchan, rlavi
Target Milestone:	6.14.0	Keywords:	Performance, Triaged
Target Release:	Unused
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	pulpcore-3.21.0, pulpcore-3.16.16, pulpcore-3.18.14	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	2191657 (view as bug list)		Environment:
Last Closed:		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 Yogendra 2023-02-16 13:47:52 UTC

Description of problem:

- Customer importing Red Hat Repository on Disconnected Red Hat Satellite taking huge time around 5 hours.
 
Version-Release number of selected component (if applicable):

- Red Hat Satellite Version 6.11.4

How reproducible:

- Try to import Rhel 7 or Rhel 8 AppsSream or Rel 8 BaseOs repository sync will complete but it will take huge time (Approximate 5-6 hours)

Steps to Reproduce:

1. Customer having 36 GB Ram and 8 CPU.
 
2. Import Huge Red Hat Repository on Disconnected Satellite and observe the time taken to complete.


 Actual results:

- Importing huge repository takes 5 hours

Expected results:

- Customer want to improve this and need time similar to Repository sync.

Additional info:

- NA

Comment 10 Daniel Alley 2023-02-23 04:16:44 UTC

I released z-streams upstream and I'm moving this to POST

Comment 11 Brad Buckingham 2023-07-26 16:13:05 UTC

Removing Triaged keyword to go back through high-level triage for the proposed releases.

Comment 13 Vladimír Sedmík 2023-08-04 18:11:03 UTC

Verified in 6.14.0 snap 10 (python39-pulpcore-3.22.9-1.1.el8pc.noarch) on a VM with 24 GB RAM, 6 CPUs, 100 GB storage. Unpatched reference VM had exactly the same HW properties.

Steps to verify were practically the same like https://bugzilla.redhat.com/show_bug.cgi?id=2191657#c1, but this time I used smaller repo (rhel-server-rhscl-7-rpms in particular) due to time and storage constraints. Complete export took 17 GB of space, incremental export took 42 MB.

On the unpatched Satellite the complete import took
real	36m23.556s
user	0m5.876s
sys	0m0.740s

and incremental import took
real	29m40.049s
user	0m5.027s
sys	0m0.597s

On the patched Satellite the complete import took
real	25m52.096s
user	0m4.431s
sys	0m0.525s

and incremental import took
real	17m42.946s
user	0m3.224s
sys	0m0.433s

As we can see:
1) the complete import time was improved by ~29 %
2) the incremental import time was improved by ~40 %
3) incremental/complete import time ratio improved from ~82 % to ~69 %.

Given the results I consider the BZ as verified.