Bug 1335044
| Summary: | ISE on scoped search for Content Hosts | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Roman Plevka <rplevka> |
| Component: | Provisioning | Assignee: | John Mitsch <jomitsch> |
| Status: | CLOSED ERRATA | QA Contact: | Roman Plevka <rplevka> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.2.0 | CC: | bbuckingham, ehelms, jhutar |
| Target Milestone: | Unspecified | Keywords: | Triaged |
| Target Release: | Unused | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| URL: | http://projects.theforeman.org/issues/15050 | ||
| Whiteboard: | |||
| Fixed In Version: | rubygem-katello-3.0.0.38-1 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2016-07-27 11:35:35 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Created redmine issue http://projects.theforeman.org/issues/15050 from this bug Upstream bug component is Provisioning Moving to POST since upstream bug http://projects.theforeman.org/issues/15050 has been closed VERIFIED on sat6.2.0 beta(GA14.0) - there no longer seem to be a way of producing the traceback. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2016:1501 |
Description of problem: There is a nasty traceback while searching for an existing hostname in Content Hosts using scoped search. search query: "my-host-1.domain.org" production.log: 2016-05-11 04:30:59 [app] [I] Processing by Api::V2::HostsController#index as JSON 2016-05-11 04:30:59 [app] [I] Parameters: {"organization_id"=>"1", "page"=>"1", "search"=>"my-host-1.lab.eng.brq.redhat.com", "sort_by"=>"name", "sort_order"=>"ASC", "apiv"=>"v2"} 2016-05-11 04:30:59 [app] [W] Action failed | PG::Error: ERROR: missing FROM-clause entry for table "organizations_hosts" | LINE 1: ...14_r9, "taxonomies"."katello_default" AS t14_r10, "organizat... searching for non-existing hostname works fine. Version-Release number of selected component (if applicable): 6.2.0 Beta GA10.1 How reproducible: always Steps to Reproduce: 1. register a host to your satellite so it appears in Content Hosts 2. Try to put its hostname to the search field and hit search 3. check production.log Actual results: ISE Expected results: Search query is being validated performed on all applicable fields. Additional info: Workaround is to use the explicit-field search query: name = my-host-1.domain.org or name ~ my-host-1.domain.org - I'm requesting a blocker flag for this BZ as this will be hit quite often by users (single word search queries are the most commonly used)