Bug 805195 - migration 35 is very slow when lots of errata are present
Summary: migration 35 is very slow when lots of errata are present
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Pulp
Classification: Retired
Component: z_other
Version: 2.0.6
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: James Slagle
QA Contact: Preethi Thomas
URL:
Whiteboard:
Depends On: 805192 805193
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-03-20 16:26 UTC by James Slagle
Modified: 2013-01-09 17:08 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of: 805193
Environment:
Last Closed: 2013-01-09 17:08:23 UTC


Attachments (Terms of Use)

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


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