Bug 468690 - rhnVirtualization.__db_get_domain does a full table scan
Summary: rhnVirtualization.__db_get_domain does a full table scan
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 530
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Martin Korbel
URL:
Whiteboard: us=54970
Depends On:
Blocks: sat550-lowbug
TreeView+ depends on / blocked
 
Reported: 2008-10-27 13:49 UTC by James Bowes
Modified: 2013-01-10 09:59 UTC (History)
4 users (show)

Fixed In Version: spacewalk-schema-1.4.7-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-09-21 09:34:00 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)

Comment 1 Michael Mráka 2011-03-03 14:14:18 UTC 
Fixed in spacewalk master by
commit 63a29bbc93b47465851b130a797e879c0e061840
    upgrade script for rhnVirtualization.uuid index
commit 136da793d9460e94f9b79594b53de7f02008f435
    468690 - added index to rhnVirtualization.uuid

Fixed spacewalk package: spacewalk-schema-1.4.7-1
Comment 4 Clifford Perry 2012-09-21 09:34:00 UTC 
This issue is resolved with the release of RHN Satellite 5.5. 

As of September 20th 2012, RHN Satellite 5.5 has been generally available. 

Release Notes and other 5.5 documentation can be found here:

 https://access.redhat.com/knowledge/docs/Red_Hat_Network_Satellite/

The associated Errata for the 5.5 release are:

5.5 Satellite GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1296.html

5.5 Upgrade Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1298.html

5.5 RHN Proxy GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1297.html

5.5 RHN Tools GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1299.html

Regards,
Clifford
- Engineering Manager, Satellite
Note You need to log in before you can comment on or make changes to this bug.