Bug 162491 - Slow search for package names on RHN server
Slow search for package names on RHN server
Status: CLOSED CURRENTRELEASE
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server (Show other bugs)
360
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:
Environment:
Last Closed: 2009-09-10 14:24:22 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
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:
Always

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
TESTPLAN:

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
on_dev
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.

http://rhn.redhat.com/errata/RHEA-2009-1434.html

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