Bug 1134021 – pulp-manage-db drops and rebuilds all indices every run

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1134021 - pulp-manage-db drops and rebuilds all indices every run

Summary:	pulp-manage-db drops and rebuilds all indices every run

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Satellite 6
Classification:	Red Hat
Component:	Pulp (Show other bugs)
Sub Component:
Version:	Unspecified
Hardware:	x86_64 All

Priority	medium Severity medium (vote)
Target Milestone:	Beta
Target Release:	Unused
Assigned To:	satellite6-bugs
QA Contact:	Jitendra Yejare
Docs Contact:

URL:
Whiteboard:
Keywords:	Reopened, Triaged

Depends On:
Blocks:	sat6-pulp-future
	Show dependency tree / graph

Reported:	2014-08-26 12:06 EDT by Randy Barlow
Modified:	2018-09-19 11:23 EDT (History)
CC List:	11 users (show)

See Also:
Fixed In Version:
Doc Type:	Bug Fix
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2016-07-27 05:10:54 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Pulp Redmine	502	Normal	CLOSED - CURRENTRELEASE	pulp-manage-db drops and rebuilds all indices every run	Never
Red Hat Product Errata	RHBA-2016:1501	normal	SHIPPED_LIVE	Red Hat Satellite 6.2 Capsule and Server	2016-07-27 08:28:58 EDT

Groups: None (edit)

Description Randy Barlow 2014-08-26 12:06:01 EDT

Description of problem:
Every time pulp-manage-db is run, it drops all DB indices and rebuilds them. This is very inefficient.

Version-Release number of selected component (if applicable):
2.4.0-1

How reproducible:
Very

Steps to Reproduce:
1. Run pulp-manage-db on a Pulp installation with data (repos with units, for example).

Actual results:
Observe that it takes a while before applying migrations.

Expected results:
There is no need to drop indices that we are going to just regenerate.

Additional info:
If we switch to Mongoengine, it will take care of index management for us.

Comment 1 Brian Bouterse 2015-02-28 17:16:52 EST

Moved to https://pulp.plan.io/issues/502

Comment 2 RHEL Product and Program Management 2015-03-04 06:24:12 EST

Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

Comment 4 pulp-infra@redhat.com 2015-06-15 15:00:49 EDT

The Pulp upstream bug status is at ON_QA. Updating the external tracker on this bug.

Comment 6 pulp-infra@redhat.com 2015-11-06 15:01:19 EST

The Pulp upstream bug status is at CLOSED - CURRENTRELEASE. Updating the external tracker on this bug.

Comment 10 Brian Bouterse 2016-04-22 06:47:57 EDT

This looks like the expected output to me.

Comment 12 Jitendra Yejare 2016-04-25 02:51:40 EDT

As per comment 9 of output from Sat 6.2 snap 9.0 and the comment 11 of confirmation of expected behavior, I am moving this bug to verified.

Comment 14 errata-xmlrpc 2016-07-27 05:10:54 EDT

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2016:1501

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