Bug 472595 - Extreme kickstart performance problem
Extreme kickstart performance problem
Product: Spacewalk
Classification: Community
Component: Server (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Mike McCune
Jesus M. Rodriguez
: Reopened
: 470234 (view as bug list)
Depends On: 491978
Blocks: space04 swcobbler05 525339
  Show dependency treegraph
Reported: 2008-11-21 17:06 EST by Mike McCune
Modified: 2012-03-06 03:57 EST (History)
6 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 525339 (view as bug list)
Last Closed: 2009-09-17 03:08:39 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 Mike McCune 2008-11-21 17:06:36 EST
Kickstarts from Spacewalk take roughly 2-3 times as long as they should and the load on the Spacewalk server is around 4-5 on rlx-0-04.rhndev.

The slowness starts as the machine is downloading packages from the Spacewalk box.  Watch top and you can see httpd and oracle taking up most of the resources on the box.
Comment 1 Justin Sherrill 2009-01-09 16:52:56 EST
I think this may have just been a temporary problem, as the issue has gone away.  Moving to modified just to be tested.
Comment 2 Mike McCune 2009-01-28 17:54:43 EST
Customers are still reporting this in 0.4.  Re-opening.
Comment 3 Mike McCune 2009-02-03 18:16:08 EST
Short term workaround for this bug:

* Edit: /etc/httpd/conf.d/zz-spacewalk-server.conf

Add: EnableMMAP off, EnableSendfile off to the Directory stanza:

<Directory "/var/www/html">
        AllowOverride all
        EnableMMAP off
        EnableSendfile off

* Add this index to your database:

# sqlplus spacewalk/spacewalk@xe

SQL> CREATE INDEX rhn_package_path_idx
ON rhnPackage(id, path);
Comment 4 Jesus M. Rodriguez 2009-02-24 16:06:43 EST

*** This bug has been marked as a duplicate of bug 470234 ***
Comment 5 Mike McCune 2009-02-24 17:32:07 EST
*** Bug 470234 has been marked as a duplicate of this bug. ***
Comment 6 Mike McCune 2009-03-12 01:49:12 EDT
i have the java port of the kickstart file downloader 90% complete but it is failing a few of my testcases.  Might not make 0.5 but I may release packages right after 0.5 goes out.
Comment 7 Mike McCune 2009-03-23 17:19:51 EDT
Comment 8 Milan Zázrivec 2009-03-24 06:56:43 EDT
Greetings Mike, I think you forgot to create rhn_package_path_idx index
in the schema itself; right now the index is present in the sql upgrade
script (153-rhnPackage-pathidx.sql) only.
Comment 9 Michael Mráka 2009-03-24 09:08:18 EDT
FAILS_QA, see comment #8
Comment 10 Mike McCune 2009-03-25 13:17:20 EDT
will fix!
Comment 11 Mike McCune 2009-03-25 13:28:01 EDT
schema fix: 7b974a41d4ec7f7ea0bc02257ee5d90941b71ccb
Comment 12 Mike McCune 2009-03-25 16:49:11 EDT
This actually should still be in FAILS_QA.  Discovered some fatal errors while kickstarting systems so it should not be tested.
Comment 13 Jesus M. Rodriguez 2009-04-14 10:11:55 EDT
Spacewalk 0.5 released.
Comment 14 Miroslav Suchý 2009-09-17 03:08:39 EDT
Spacewalk 0.5 has been released for long time ago.

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