Bug 467463
| Summary: | Eliminate full table scan on rhnkickstartabletree | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Network | Reporter: | James Bowes <jbowes> |
| Component: | RHN/Backend | Assignee: | rhn-dev-list |
| Status: | CLOSED EOL | QA Contact: | Red Hat Network Quality Assurance <rhn-qa-list> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | rhn500 | CC: | bkearney, rhn-bugs |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | us=54975 | ||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2017-07-05 15:23:42 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: | 428922 | ||
should be 54975 As you may already be aware, Red Hat is transitioning from the Red Hat Network (RHN) hosted interface to the Red Hat Subscription Management (RHSM) interface in July 2017. Red Hat has invested in and seen success from RHN for many years, and used that experience to build more robust technologies like RHSM. If you have not yet migrated your RHN systems to RHSM or you are a Red Hat Satellite customer, please review the information from. https://access.redhat.com/products/red-hat-subscription-management#migration. Since we are shutting down RHN, no further actions will be taken with this bug or enhancement request. You can find additional information at RHSM product page (https://access.redhat.com/products/red-hat-subscription-management). If you have further questions, please contact support (https://access.redhat.com/products/red-hat-subscription-management#support). |
The offending query is: SELECT ks.base_path FROM rhnkstreefile kstf, rhnkickstartabletree ks, rhnchannel c WHERE kstf.relative_filename = :relative_path AND kstf.kstree_id = ks.ID AND ks.label = :ks_label AND ks.channel_id = c.ID AND c.label = :channel