Project

General

Profile

Actions

Bug #22760

closed

Invalid search: PG::UndefinedColumn: ERROR: column katello_product_contents.name does not exist - on searching by name

Added by roman plevka about 6 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Category:
Repositories
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

2018-03-05T04:24:45 a808d606 [app] [I] Started GET "/katello/api/products/337/repository_sets?name=Red+Hat+Enterprise+Virtualization+Agents+for+RHEL+6+Server+%28RPMs%29" for 10.8.30.100 at 2018-03-05 04:24:45 -0500
2018-03-05T04:24:45 a808d606 [app] [I] Processing by Katello::Api::V2::RepositorySetsController#index as JSON
2018-03-05T04:24:45 a808d606 [app] [I]   Parameters: {"name"=>"Red Hat Enterprise Virtualization Agents for RHEL 6 Server (RPMs)", "api_version"=>"v2", "product_id"=>"337", "repository_set"=>{}}
2018-03-05T04:24:45 a808d606 [app] [I] Current user: foreman_admin (administrator)
2018-03-05T04:24:45 a808d606 [app] [I] Authorized user admin(Admin User)
2018-03-05T04:24:45 a808d606 [app] [I] Current user: admin (administrator)
2018-03-05T04:24:45 a808d606 [app] [E] Invalid search: PG::UndefinedColumn: ERROR:  column katello_product_contents.name does not exist
 | LINE 1: ...contents.content_type IN ('containerimage'))) AND "katello_p...
 |                                                              ^
 | : SELECT COUNT(DISTINCT "katello_product_contents"."id") FROM "katello_product_contents" INNER JOIN "katello_contents" ON "katello_contents"."id" = "katello_product_contents"."content_id" WHERE "katello_product_contents"."product_id" = $1 AND (NOT (katello_contents.content_type IN ('containerimage'))) AND "katello_product_contents"."name" = $2
2018-03-05T04:24:45 a808d606 [app] [I]   Rendering /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/views/katello/api/v2/repository_sets/index.json.rabl within katello/api/v2/layouts/collection
2018-03-05T04:24:45 a808d606 [app] [I]   Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.7.0/app/views/katello/api/v2/repository_sets/index.json.rabl within katello/api/v2/layouts/collection (3.0ms)
2018-03-05T04:24:45 a808d606 [app] [I] Completed 200 OK in 41ms (Views: 5.5ms | ActiveRecord: 7.3ms)
2018-03-05T04:24:52  [dynflow] [F] /opt/theforeman/tfm/root/usr/share/gems/gems/dynflow-0.8.34/lib/dynflow/delayed_plan.rb:21:in `plan'
...
 | /opt/rh/tfm-ror51/root/usr/share/gems/gems/concurrent-ruby-1.0.5/lib/concurrent/executor/ruby_thread_pool_executor.rb:319:in `block in create_worker'
 | /opt/theforeman/tfm/root/usr/share/gems/gems/logging-2.2.2/lib/logging/diagnostic_context.rb:474:in `block in create_with_logging_context'

Hammer triggers the same GET request on providing `--name` parameter

Actions #1

Updated by John Mitsch about 6 years ago

  • Assignee set to Jonathon Turel
  • translation missing: en.field_release set to 338
Actions #2

Updated by The Foreman Bot about 6 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/7227 added
Actions #3

Updated by Anonymous about 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF