Red Hat Bugzilla – Bug 1372757
ERROR: invalid reference to FROM-clause entry for table "smart_proxies"
Last modified: 2017-06-29 03:32:45 EDT
Description of problem: While searching for hosts on Satellite WebUI, observing following error message: Oops, we're sorry but something went wrong ERROR: invalid reference to FROM-clause entry for table "smart_proxies" LINE 1: SELECT smart_proxies.id FROM "smart_proxies" "puppet_ca_prox... ^ HINT: Perhaps you meant to reference the table alias "puppet_ca_proxies_hosts". Version-Release number of selected component (if applicable): 6.2 How reproducible: Frequent Additional info: This has been fixed in upstream: http://projects.theforeman.org/issues/14730 foreman: 1.11.2
Build :Satellite 6.3 snap 5 Steps: With locations enabled. Switch context to any location, and search for Host with hostname on the dashboard page. Error occured on a widget , please see attachment for detail view. Failure: PG::Error: ERROR: missing FROM-clause entry for table "models" LINE 1: ...agtap-sat6.abc.com%' OR "models"."... ^ : SELECT 1 AS one FROM "reports" INNER JOIN "hosts" ON "hosts"."id" = "reports"."host_id" AND "hosts"."type" IN ('Host::Managed') AND "hosts"."organization_id" = 1 AND "hosts"."location_id" = 2 WHERE "reports"."type" IN ('ConfigReport') AND (1=0) AND (status <> 0) AND "reports"."host_id" IN (SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."organization_id" = 1 AND "hosts"."location_id" = 2 AND (("hosts"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "hosts"."comment" ILIKE '%sjagtap-sat6.abc.com%' OR "models"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "hostgroups"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "hostgroups"."title" ILIKE '%sjagtap-sat6.abc.com%' OR "hostgroups"."title" ILIKE '%sjagtap-sat6.abc.com%' OR "domains"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "realms"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "environments"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "architectures"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "compute_resources"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "images"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."description" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."title" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."major" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."minor" ILIKE '%sjagtap-sat6.abc.com%' OR "nics"."ip" ILIKE '%sjagtap-sat6.abc.com%' OR "nics"."ip" ILIKE '%sjagtap-sat6.abc.com%' OR "nics"."mac" ILIKE '%sjagtap-sat6.abc.com%' OR "taxonomies"."title" ILIKE '%sjagtap-sat6.abc.com%' OR "subnets"."network" ILIKE '%sjagtap-sat6.abc.com%' OR "subnets"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "subnets"."network" ILIKE '%sjagtap-sat6.abc.com%' OR "subnets"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "hosts"."uuid" ILIKE '%sjagtap-sat6.abc.com%' OR "nics"."mac" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."description" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."title" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."major" ILIKE '%sjagtap-sat6.abc.com%' OR "operatingsystems"."minor" ILIKE '%sjagtap-sat6.abc.com%' OR "smart_proxies"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_host_collections"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_content_views"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_environments"."name" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_subscription_facets"."release_version" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_subscription_facets"."service_level" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_subscription_facets"."registered_through" ILIKE '%sjagtap-sat6.abc.com%' OR "katello_subscription_facets"."uuid" ILIKE '%sjagtap-sat6.abc.com%' OR 1=0 OR "discovery_rules"."name" ILIKE '%sjagtap-sat6.abc.com%'))) AND (("reports"."reported_at" >= '2016-10-15')) LIMIT 1
Upstream bug assigned to tbrisker@redhat.com
Upstream bug component is Search
@Snaket - That is a separate bug that has also boon fixed in upstream, I have cloned it to BZ1391365 Moving this back to ONQA as this issue deals with broken search on the host list page.
Build: Satellite 6.3 snap 6 Steps: With locations enabled. Switch context to any location, and search for Host with hostname on the hosts page. No error was seen on hosts page. Verified.
*** Bug 1385882 has been marked as a duplicate of this bug. ***
Moving to 6.2.z based on suggestion from Tomer.
Note: This only occurs when searching in a location or organization context that has "all capsules" associated with it (under Administer->Locations/Organizations->Edit). A workaround is possible by unchecking the "All capsules" checkbox in the above form and manually selecting all capsules.
*** Bug 1410673 has been marked as a duplicate of this bug. ***
Build: Satellite 6.2.7 snap 1 Steps: Checked all capsules for a particular Org/Loc , searched successfully for the host with hostname on hosts page. Also, Searched Hosts with any context successfully
Dear Diogo, Please, follow the steps below on Satellite Server # cd /usr/share/foreman # git init . # git add . # git commit -m 'original' // Save the attached patch on this path (foreman_inv_ref.patch), then execute command below # patch -p1 < foreman_inv_ref.patch // The output should be something similar to patching file app/models/concerns/hostext/search.rb // Now, restart the httpd service and try again via webUI # systemctl restart httpd Let me know if you need something else. Best Regards -- Waldirio M Pinheiro | Senior Software Maintenance Engineer
Created attachment 1241361 [details] hot fix
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-2017:0197