Bug 468690

Summary: rhnVirtualization.__db_get_domain does a full table scan
Product: Red Hat Satellite 5 Reporter: James Bowes <jbowes>
Component: ServerAssignee: Michael Mráka <mmraka>
Status: CLOSED CURRENTRELEASE QA Contact: Martin Korbel <mkorbel>
Severity: medium Docs Contact:
Priority: medium    
Version: 530CC: bkearney, cperry, mkorbel, rhn-bugs
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard: us=54970
Fixed In Version: spacewalk-schema-1.4.7-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-09-21 09:34:00 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 819081    

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