Project

General

Profile

Actions

Bug #2011

closed

Param Class optimization fails on Postges

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

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
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 1 (0 open1 closed)

Related to Foreman - Refactor #2003: improve pararmetize classes params retrivial speedClosedOhad Levy12/05/2012Actions
Actions #1

Updated by Ohad Levy over 11 years ago

  • Target version set to 1.1
Actions #2

Updated by Ohad Levy over 11 years ago

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

Also available in: Atom PDF