Project

General

Profile

Actions

Bug #11942

closed

Host conversion fails on PostgreSQL during provisioning

Added by Sachin Ghai over 8 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Discovery plugin
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

Description:

I was trying to provision a discovered host by associating hostgroup and got following:

 | Started PUT "/discovered_hosts/mac525400104461" for 10.65.193.85 at 2015-09-24 05:30:36 -0400
2015-09-24 05:30:36 [app] [I] Processing by DiscoveredHostsController#update as */*
2015-09-24 05:30:36 [app] [I]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"JyoCCHL+YxUtdumkEf2PrunpbY2nqYJwTcFIzTS38Xc=", "host"=>{"name"=>"mac525400104461", "hostgroup_id"=>"1", "environment_id"=>"1", "content_source_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "interfaces_attributes"=>{"0"=>{"_destroy"=>"0", "mac"=>"52:54:00:10:44:61", "identifier"=>"eth0", "name"=>"mac525400104461", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"192.168.100.24", "managed"=>"1", "primary"=>"1", "provision"=>"1", "tag"=>"", "attached_to"=>"", "id"=>"7"}}, "architecture_id"=>"1", "operatingsystem_id"=>"2", "build"=>"1", "medium_id"=>"8", "ptable_id"=>"53", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"3-Users", "enabled"=>"1", "model_id"=>"2", "comment"=>"", "overwrite"=>"false"}, "hostgroup"=>{"lifecycle_environment_id"=>"2", "content_view_id"=>"2", "puppetclass_ids"=>[""]}, "id"=>"mac525400104461"}
2015-09-24 05:30:37 [app] [W] Action failed
 | ActiveRecord::StatementInvalid: PGError: ERROR:  column reference "id" is ambiguous
 | LINE 1: SELECT id FROM "fact_values" INNER JOIN "fact_names" ON "fac...
 |                ^
 | : SELECT id FROM "fact_values" INNER JOIN "fact_names" ON "fact_names"."id" = "fact_values"."fact_name_id" WHERE (host_id = 3) AND (fact_names.name like 'discovery_%')
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1158:in `async_exec'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1158:in `exec_no_cache'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:664:in `block in exec_query'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:663:in `exec_query'
 | /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:1253:in `select'

Reproducible with version:
---------------------------
tfm-rubygem-foreman_discovery-4.1.0-1.fm1_10.git.56.4380f1d.git.56.4380f1d.git.56.4380f1d.el7.noarch
foreman-release-1.10.0-0.develop.201509171905gitd7b8c7a.el7.noarch
foreman-libvirt-1.10.0-0.develop.201509171905gitd7b8c7a.el7.noarch
foreman-1.10.0-0.develop.201509171905gitd7b8c7a.el7.noarch
discovery image tar fdi-image-3.0.1.tar


Files

pgerror.png View pgerror.png 38.4 KB Sachin Ghai, 09/24/2015 05:35 AM

Related issues 1 (0 open1 closed)

Related to Discovery - Tracker #10294: PXEless discovery featureClosedLukas Zapletal04/28/2015

Actions
Actions #1

Updated by Sachin Ghai over 8 years ago

Actions #2

Updated by The Foreman Bot over 8 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman_discovery/pull/220 added
  • Pull request deleted ()
Actions #3

Updated by Anonymous over 8 years ago

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

Also available in: Atom PDF