Project

General

Profile

Bug #2011

Param Class optimization fails on Postges

Added by Greg Sutcliffe over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:

Description

foreman/hosts/new

x PG::Error: ERROR: column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ss_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_key... ^ : SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_keys.key
If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace and relevant log entries.

ActiveRecord::StatementInvalid
PG::Error: ERROR: column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ss_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_key... ^ : SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_keys.key
app/helpers/hosts_and_hostgroups_helper.rb:83:in `interesting_klasses'
app/views/puppetclasses/_classes_parameters.html.erb:11:in `_app_views_puppetclasses__classes_parameters_html_erb__786019820_107278740_909626628'
app/views/hosts/_form.html.erb:74:in `block in _app_views_hosts__form_html_erb___702716785_109829890_127430104'
app/helpers/layout_helper.rb:155:in `form_for'
app/views/hosts/_form.html.erb:4:in `_app_views_hosts__form_html_erb___702716785_109829890_127430104'
app/views/hosts/new.html.erb:3:in `_app_views_hosts_new_html_erb__861224596_109807200_763432826'
lib/foreman/threadsession.rb:31:in `clear_thread'
Back


Related issues

Related to Foreman - Refactor #2003: improve pararmetize classes params retrivial speedClosed2012-12-05

Associated revisions

Revision 3c2fb3fd (diff)
Added by Ohad Levy over 9 years ago

fixes #2011 - Param Class optimization fails on Postges

History

#1 Updated by Ohad Levy over 9 years ago

  • Target version set to 1.1

#2 Updated by Ohad Levy over 9 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF