Project

General

Profile

Actions

Bug #25095

open

Discovered host assign organization or assign location failure

Added by Lukas Zapletal over 5 years ago. Updated over 5 years ago.

Status:
New
Priority:
High
Assignee:
-
Category:
Discovery plugin
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

Description

Steps to Reproduce:
1. Goto Hosts > Discovered hosts
2. Select one discovered host
3. Apply action Assign Organization (or Assign Location)
4. In the dialog box: select the target organization (or Location in case of Assign Location)
5. Press submit

Actual results:
an error Message is displayed:
Oops, we're sorry but something went wrong PG::AmbiguousColumn: ERROR: column reference "id" is ambiguous LINE 1: ...zation_id" = 1 AND "hosts"."location_id" = 2 AND (id IN ('10... ^ : SELECT "hosts"."id" FROM "hosts" LEFT OUTER JOIN "models" ON "models"."id" = "hosts"."model_id" LEFT OUTER JOIN "fact_values" ON "fact_values"."host_id" = "hosts"."id" LEFT OUTER JOIN "nics" ON "nics"."host_id" = "hosts"."id" LEFT OUTER JOIN "taxonomies" ON "taxonomies"."id" = "hosts"."location_id" AND "taxonomies"."type" IN ('Location') LEFT OUTER JOIN "taxonomies" "organizations_hosts" ON "organizations_hosts"."id" = "hosts"."organization_id" AND "organizations_hosts"."type" IN ('Organization') WHERE "hosts"."type" IN ('Host::Discovered') AND "hosts"."organization_id" = 1 AND "hosts"."location_id" = 2 AND (id IN ('10') or name IN (NULL)) ORDER BY hosts.created_at DESC


Related issues 1 (0 open1 closed)

Related to Foreman - Bug #24702: Error while assigning location to a number of hosts that is larger than per_page settingClosedStephen BenjaminActions
Actions #1

Updated by Lukas Zapletal over 5 years ago

Regression created by 1.18-only patch #24702, man this was tough to troubleshoot since it was not in develop.

Actions #2

Updated by Lukas Zapletal over 5 years ago

  • Related to Bug #24702: Error while assigning location to a number of hosts that is larger than per_page setting added
Actions #3

Updated by Lukas Zapletal over 5 years ago

  • Triaged changed from No to Yes
Actions

Also available in: Atom PDF