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 How reproducible: 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 Actual results: 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) Expected results: Queries/pages return faster. Additional info: Rough deployment size indicators - SQL> select count(*) from rhnServerNeededErrataCache; COUNT(*) ---------- 1847052 SQL> select count(*) from rhnServerNeededCache; COUNT(*) ---------- 4295066 SQL> select count(*) from rhnServer; COUNT(*) ---------- 26921 SQL> select count(*) from rhnChannel; COUNT(*) ---------- 391 SQL> select count(*) from rhnPackage; COUNT(*) ---------- 61514 SQL> select count(*) from rhnErrata; COUNT(*) ---------- 10973 SQL> select count(*) from rhnServerpackage; COUNT(*) ---------- 13795711
Taking a look at this.
Ok, i think should be fixed now: spacewalk master: 78172547e9e0b5263c20ac991b71b0e2520391f9 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 https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332 RHEA-2010:0803 - RHN Tools enhancement update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333 RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334 RHEA-2010:0800 - RHN Satellite Server 5.4.0 https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335 Docs are available: http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html Regards, Clifford