Uploaded image for project: 'Satellite'
  1. Satellite
  2. SAT-17706

Passing invalid value to infrasturcture_facet search key leads to PG::InvalidTextRepresentation error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Normal Normal
    • None
    • 6.11.0
    • Hosts
    • None
    • None
    • None
    • None

      Description of problem:

      Host search can error out on infrasturcture_facet related queries

      Version-Release number of selected component (if applicable):

      Satellite 6.11 snap 14

      How reproducible:
      always

      Steps to Reproduce:
      1. in satellite UI, go to the hosts page
      2. in the search field put "infrastructure_facet.foreman=test" or "infrastructure_facet.smart_proxy_id=test"

      Actual results:
      Error screen with:

      Oops, we're sorry but something went wrong PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean: "test" LINE 1: ...acets_infrastructure_facets"."foreman_instance" = 'test')) O... ^

      (same happens when searching through hammer CLI)

      Expected results:
      no error, host page with no results (as it is when passing wrong values to other search keys"

      Additional info:

          There are no Sub-Tasks for this issue.

              aruzicka@redhat.com Adam Ruzicka
              aruzicka@redhat.com Adam Ruzicka
              Lukas Hellebrandt Lukas Hellebrandt
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: