Bug 805195

Summary: migration 35 is very slow when lots of errata are present
Product: [Retired] Pulp Reporter: James Slagle <jslagle>
Component: z_otherAssignee: James Slagle <jslagle>
Status: CLOSED CURRENTRELEASE QA Contact: Preethi Thomas <pthomas>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 2.0.6CC: kbidarka, sghai, tsanders
Target Milestone: ---Keywords: Triaged
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 805193 Environment:
Last Closed: 2013-01-09 17:08:23 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On: 805192, 805193    
Bug Blocks:    

Description James Slagle 2012-03-20 16:26:25 UTC 
+++ This bug was initially created as a clone of Bug #805193 +++

+++ This bug was initially created as a clone of Bug #805192 +++

migration 35 is very slow when lots of errata are present

The EC2 rhui's have 3000+ errata and migration 35 is taking 2+ hours to run.

--- Additional comment from jslagle on 2012-03-20 12:24:27 EDT ---

Because this is RHUI and no one has yet migrated past version 35, we can modify migration version 35 directly.  This will make it so that we can add the needed indexes and rewrite the slow part of the migration to be much more efficient.

We can do these same changes in pulp, but we need an additional migration (version 39) to add the indexes.

We can then also pull migration 39 back into rhui so that the 2 branches stay on the same db version.  version 39 will essentially be a no-op in the rhui branch since the indexes were already added as part of 35.
Comment 1 James Slagle 2012-03-20 16:49:57 UTC 
committed to pulp master 39e4843eddb3e31d25e9f1f0c447ae13d1d0064f
new migration version actually ended up being version 41 instead of 39
Comment 2 Jeff Ortel 2012-04-12 22:59:14 UTC 
build: 0.282
Comment 3 Preethi Thomas 2012-09-27 17:31:31 UTC 
Moving this to verified as this hasn't been an issue
Comment 4 Preethi Thomas 2013-01-09 17:08:23 UTC 
Pulp v2.0 released