Bug 162491 - Slow search for package names on RHN server
Slow search for package names on RHN server
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Mike McCune
Jeff Browning
Depends On:
Blocks: 472497
  Show dependency treegraph
Reported: 2005-07-05 11:40 EDT by Christopher Basquez
Modified: 2009-09-10 14:24 EDT (History)
1 user (show)

See Also:
Fixed In Version: sat530
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2009-09-10 14:24:22 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Terry Jones 2005-07-05 11:40:32 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4

Description of problem:
 The search feature for packages on the upgraded satellite (v3.6) is very, very slow.

Tests have taken 7 minutes to list packages.

This situation did not occur on the previous version of satellite we were using (v3.2) nor on RHN.

Server is running RHEL3. Database is external.

Version-Release number of selected component (if applicable):
rhn-satellite 3.6

How reproducible:

Steps to Reproduce:
1. Log in to satellite
2. Goto package search.
3. Enter package name and start search.........

Actual Results:  Machines takes a lonnnnng time to reach a result. 10+ minutes in some cases. This only became a factor after the upgrade to 3.6

Expected Results:  Return the package list in short order

Additional info:
Comment 2 Terry Jones 2005-07-05 11:51:01 EDT
I have attached the output to the script originally supplied by J Slagle on 4/19
to Dresdner Kleinwort Wasserstein
Comment 4 Mike McCune 2005-07-26 13:48:19 EDT
the work I did had no effect on the speed.  Myself and Vlad both tested package
searching on webqa and it seemed to return in reasonable amounts of time.

I think it would be worth testing out package searching on a fully sat-synched
sat to make sure there isn't some difference.  I'll take a look at this and
report back.
Comment 5 Mike McCune 2005-07-28 00:12:49 EDT
I tested out package searching on a sat with lots of channels/packages and it
was very snappy.  Searches returned in 1 second or less.
Comment 6 Mike McCune 2005-07-28 00:14:16 EDT

1) Login to a sat that has multiple channels synched with a large number of
packages (1000+)
2) Search -> Packages
3) type a name, libjpeg for example
4) click on the name

verify that none of the steps take an unacceptable amount of time (2-3 seconds
or more).
Comment 9 Mike McCune 2008-12-02 15:26:31 EST
Comment 10 Jeff Browning 2008-12-15 12:06:32 EST
Verified. Search takes roughly 1 second when searching through 10,000 packages.
Comment 11 Brandon Perkins 2009-09-10 14:24:22 EDT
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.


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