Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1190601 - While defining discovery rule, any fact with integer value suggested by auto search raises PGError and ISE in production.log
Summary: While defining discovery rule, any fact with integer value suggested by auto ...
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: WebUI
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: Unspecified
Assignee: Lukas Zapletal
QA Contact: Sachin Ghai
URL: http://projects.theforeman.org/issues...
Whiteboard:
Depends On:
Blocks: 1193977
TreeView+ depends on / blocked
 
Reported: 2015-02-09 09:22 UTC by Sachin Ghai
Modified: 2019-09-26 17:39 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-06-18 13:21:08 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
On selecting any fact with integer value from auto-search under New discovery rule form, raises 500 ISE (53.59 KB, image/png)
2015-02-09 09:22 UTC, Sachin Ghai
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 9088 0 None None None 2016-04-22 16:44:13 UTC

Description Sachin Ghai 2015-02-09 09:22:26 UTC
Created attachment 989589 [details]
On selecting any fact with integer value from auto-search under New discovery rule form, raises 500 ISE

Description of problem:
While defining the discovery rule, in search box I choose the auto-search and defined "cpu_count = 1" 

As soon as I defined "cpu_count = 1" in serach, UI raises 500 ISE in firebug and poduction.log thrown:

--
Processing by DiscoveredHostsController#auto_complete_search as JSON
  Parameters: {"search"=>" cpu_count = 1"}
Operation FAILED: PGError: ERROR:  operator does not exist: integer ~~ unknown
LINE 1: ...s"  WHERE ("discovery_attribute_sets"."cpu_count" LIKE '1%')...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT  DISTINCT "discovery_attribute_sets"."cpu_count" FROM "discovery_attribute_sets"  WHERE ("discovery_attribute_sets"."cpu_count" LIKE '1%') ORDER BY "discovery_attribute_sets"."cpu_count" LIMIT 20
  Rendered common/500.html.erb (5.2ms)
Completed 500 Internal Server Error in 22ms (Views: 6.0ms | ActiveRecord: 2.0ms)

--

Version-Release number of selected component (if applicable):
Satellite-6.1.0-RHEL-6-20150205.0
Sat6.1 Beta snap1 compose3

How reproducible:
always

Steps to Reproduce:
1. go to configure --> New discovery rule
2. from auto-serach choose any fact like cpu_count = 1
3. see production.log

Actual results:
firebug raises following:

"NetworkError: 500 Internal Server Error - https://dhcp201-137.englab.pnq.redhat.com/discovered_hosts/auto_complete_search?search=+cpu_count+%3D+1

production.log raises:

-
--
Processing by DiscoveredHostsController#auto_complete_search as JSON
  Parameters: {"search"=>" cpu_count = 1"}
Operation FAILED: PGError: ERROR:  operator does not exist: integer ~~ unknown
LINE 1: ...s"  WHERE ("discovery_attribute_sets"."cpu_count" LIKE '1%')...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT  DISTINCT "discovery_attribute_sets"."cpu_count" FROM "discovery_attribute_sets"  WHERE ("discovery_attribute_sets"."cpu_count" LIKE '1%') ORDER BY "discovery_attribute_sets"."cpu_count" LIMIT 20
  Rendered common/500.html.erb (5.2ms)
Completed 500 Internal Server Error in 22ms (Views: 6.0ms | ActiveRecord: 2.0ms)

--

On selecting any fact with integer value from auto-search under New discovery rule form.

Expected results:
No error should appear in production.log and Firebug shouln't raise any error on selecting fact from auto-search with integer value

Additional info:

Comment 1 Sachin Ghai 2015-02-09 09:23:03 UTC
Upstream issue: http://projects.theforeman.org/issues/9088

Comment 8 Lukas Zapletal 2015-03-19 09:48:22 UTC
When you see 500 in the UI that's totally blocker, but in this case we only see 500 only in the production.log. Satellite 6 operates well. For this reason I gave it lower prio.

Comment 9 Lukas Zapletal 2015-06-18 13:21:08 UTC
This appears to be fixed in develop branch. I am going to close this bug as the code will ship with 6.2. Reopen if needed.


Note You need to log in before you can comment on or make changes to this bug.