Description of problem:
Customer is running into a problem when bringing up certain parts of the UI. One example is the Channels section. Based on a couple of queries on the db he's seeing at least one view that is responding very slowly:
select count(*) from rhnavailablechannels;
This returns a value of 425 but takes 10-15 seconds to complete. He tried to run this on a separate (non-production) db that has near duplicate data and it at least seems to return much quicker, about 1.5 seconds.
Another example would be: try running through uploading a package and going through the errata publishing process. Each step takes a big of time causing errata publishing to take quite a while.
create errata -> attach packages -> publish -> select channels
Version-Release number of selected component (if applicable):
Red Hat Network (RHN) Satellite 5.3.0
Always (cusotmer db dump avilable).
Steps to Reproduce:
1. Import customer db onto 5.3 Satellite;
2. via sqlplus query "select count(*) from rhnavailablechannels;"
3. click on Channels tab to browse channels section
4. upload package and go through errata publication process
step 2 takes 10-15 seconds
step 3 is slow
step 4 takes about 10 seconds on each stage (I could only see this once though)
Queries/pages return faster.
Rough deployment size indicators -
SQL> select count(*) from rhnServerNeededErrataCache;
SQL> select count(*) from rhnServerNeededCache;
SQL> select count(*) from rhnServer;
SQL> select count(*) from rhnChannel;
SQL> select count(*) from rhnPackage;
SQL> select count(*) from rhnErrata;
SQL> select count(*) from rhnServerpackage;
Taking a look at this.
Ok, i think should be fixed now:
Since this is a view change, we cannot release it for everyone via the errata process, but there is no harm in teh customer applying a one-off fix. It should not affect upgrades either.
Will attach upgrade script for the customer.
Created attachment 430497 [details]
Patch for this bug
To apply the patch simply download it and run:
sqlplus rhnsat/rhnsat@rhnsat @rhnAvailableChannels.sql
(assuming the db connect string is rhnsat/rhnsat@rhnsat).
The database will need to be running while this is run.
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release.
RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade
RHEA-2010:0803 - RHN Tools enhancement update
RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update
RHEA-2010:0800 - RHN Satellite Server 5.4.0
Docs are available: