Ok, thank you for the update. Is there a fix for this issue? When it should be released?
On Monday, June 12, 2017 at 9:16:37 AM UTC+3, Ido Kaplan wrote: > > Hi, > > Foreman version 1.14.3, Discovery plugin version 8.0.1. > > During provisioning a server with multiple interfaces, domain is not set > from a host group. > Error - Failed to save: Domain can't be blank, Interfaces.domain can't > find domain with this id > The same issue like this bug - http://projects.theforeman.org/issues/19445 > Can you please advise? > > 2017-06-11 13:41:16 f825c503 [app] [I] Started GET > "/discovered_hosts/mac000000000000/edit?utf8=%E2%9C%93&host%5Bhostgroup_id%5D=1" > > for 1.1.1.1 at 2017-06-11 13:41:16 +0000 > 2017-06-11 13:41:16 f825c503 [app] [I] Processing by > DiscoveredHostsController#edit as HTML > 2017-06-11 13:41:16 f825c503 [app] [I] Parameters: {"utf8"=>"✓", > "host"=>{"hostgroup_id"=>"1"}, "id"=>"mac000000000000"} > 2017-06-11 13:41:16 f825c503 [sql] [D] > ActiveRecord::SessionStore::Session Load (0.9ms) SELECT "sessions".* FROM > "sessions" WHERE "sessions"."session_id" = $1 ORDER BY "sessions"."id" ASC > LIMIT 1 [["session_id", "f825c5039243217a9989ad65570411fe"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] User Load (0.8ms) SELECT > "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 3]] > 2017-06-11 13:41:16 f825c503 [app] [D] Setting current user thread-local > variable to admin > 2017-06-11 13:41:16 f825c503 [sql] [D] AuthSource Load (0.7ms) SELECT > "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 LIMIT > 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Host::Discovered Load (0.9ms) > SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Discovered') > AND "hosts"."id" = $1 ORDER BY hosts.created_at DESC LIMIT 1 [["id", 0]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Host::Discovered Load (1.0ms) > SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Discovered') > AND "hosts"."name" = $1 ORDER BY hosts.created_at DESC LIMIT 1 [["name", > "mac000000000000"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.9ms) SELECT > "nics".* FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY > "nics"."identifier" ASC [["host_id", 12]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.2ms) BEGIN > 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet Load (0.7ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND "subnets"."type" = > $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "2.2.2.2"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > "nics".* FROM "nics" WHERE "nics"."domain_id" IS NULL AND "nics"."name" = > $1 [["name", "mac000000000000"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.5ms) SELECT > "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "192.168.0.120"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) COMMIT > 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.8ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = $1 ORDER BY > hostgroups.title LIMIT 1 [["title", "1"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.9ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > hostgroups.title LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (1.0ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > hostgroups.title LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Architecture Load (0.7ms) > SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = > $1 LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Operatingsystem Load (0.8ms) > SELECT "operatingsystems".* FROM "operatingsystems" WHERE > "operatingsystems"."id" = $1 ORDER BY "operatingsystems"."title" ASC LIMIT > 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Domain Load (0.7ms) SELECT > "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY > domains.name LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet Load (0.7ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 ORDER BY vlanid LIMIT > 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered hosts/_progress.html.erb > (0.2ms) > 2017-06-11 13:41:16 f825c503 [app] [D] Setting current organization > thread-local variable to none > 2017-06-11 13:41:16 f825c503 [app] [D] Setting current location > thread-local variable to none > 2017-06-11 13:41:16 f825c503 [sql] [D] SmartProxy Load (1.3ms) SELECT > "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" > ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER > JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" > WHERE (1=1) AND "features"."name" = 'Puppet' ORDER BY > "smart_proxies"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY > domains.name LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.8ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE (1=1) ORDER BY "hostgroups"."title" > ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] Environment Load (0.6ms) SELECT > "environments".* FROM "environments" WHERE (1=1) ORDER BY > "environments"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" > ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER > JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" > WHERE (1=1) AND "features"."name" = 'Puppet' ORDER BY > "smart_proxies"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] SmartProxy Load (1.1ms) SELECT > "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" > ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER > JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" > WHERE (1=1) AND "features"."name" = 'Puppet CA' ORDER BY > "smart_proxies"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] Realm Load (0.6ms) SELECT > "realms".* FROM "realms" WHERE (1=1) ORDER BY "realms"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" > ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER > JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" > WHERE (1=1) AND "features"."name" = 'Puppet' ORDER BY > "smart_proxies"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "nics".* > FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY "nics"."identifier" ASC > [["host_id", 12]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Domain Load (0.6ms) SELECT > "domains".* FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet::Ipv4 Load (0.8ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND > (1=1) ORDER BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet::Ipv6 Load (0.7ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND > (1=1) ORDER BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND "subnets"."type" = > $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]] > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (20.9ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.2ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (23.9ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (14.5ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (17.1ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.5ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.0ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.0ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.4ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.0ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.0ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.8ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/bmcs/_bmc.html.erb > (16.4ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.8ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.0ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.4ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.5ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.0ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.1ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.6ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_virtual_form.html.erb (1.0ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.2ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > hosts/_interfaces.html.erb (144.4ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] Architecture Load (0.5ms) SELECT > "architectures".* FROM "architectures" ORDER BY "architectures"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "architectures".* FROM "architectures" WHERE "architectures"."id" = $1 > LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.9ms) SELECT COUNT(*) FROM > "operatingsystems" INNER JOIN "architectures_operatingsystems" ON > "operatingsystems"."id" = > "architectures_operatingsystems"."operatingsystem_id" WHERE > "architectures_operatingsystems"."architecture_id" = $1 > [["architecture_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Operatingsystem Load (0.9ms) > SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN > "architectures_operatingsystems" ON "operatingsystems"."id" = > "architectures_operatingsystems"."operatingsystem_id" WHERE > "architectures_operatingsystems"."architecture_id" = $1 ORDER BY > "operatingsystems"."name" ASC [["architecture_id", 1]] > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > common/os_selection/_architecture.html.erb (5.7ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.9ms) SELECT COUNT(*) FROM > "media" INNER JOIN "media_operatingsystems" ON "media"."id" = > "media_operatingsystems"."medium_id" WHERE > "media_operatingsystems"."operatingsystem_id" = $1 AND (1=1) > [["operatingsystem_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Medium Load (1.0ms) SELECT > "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" > = "media_operatingsystems"."medium_id" WHERE > "media_operatingsystems"."operatingsystem_id" = $1 AND (1=1) ORDER BY > "media"."name" ASC [["operatingsystem_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.9ms) SELECT COUNT(*) FROM > "templates" INNER JOIN "operatingsystems_ptables" ON "templates"."id" = > "operatingsystems_ptables"."ptable_id" WHERE "templates"."type" IN > ('Ptable') AND "operatingsystems_ptables"."operatingsystem_id" = $1 AND > (1=1) [["operatingsystem_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Ptable Load (0.9ms) SELECT > "templates".* FROM "templates" INNER JOIN "operatingsystems_ptables" ON > "templates"."id" = "operatingsystems_ptables"."ptable_id" WHERE > "templates"."type" IN ('Ptable') AND > "operatingsystems_ptables"."operatingsystem_id" = $1 AND (1=1) ORDER BY > "templates"."name" ASC [["operatingsystem_id", 1]] > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > common/os_selection/_pxe_loader.html.erb (1.2ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > common/os_selection/_operatingsystem.html.erb (14.2ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > hosts/provision_method/build/_form.html.erb (15.5ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > hosts/provision_method/image/_form.html.erb (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > hosts/_operating_system.html.erb (26.7ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > hosts/_unattended.html.erb (26.8ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.9ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1) ORDER BY > coalesce("hostgroups"."ancestry", '') > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.6ms) SELECT > "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON > "config_groups"."id" = "host_config_groups"."config_group_id" WHERE > "host_config_groups"."host_id" = $1 AND "host_config_groups"."host_type" = > $2 ORDER BY config_groups.name [["host_id", 1], ["host_type", > "Hostgroup"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.6ms) SELECT > "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON > "config_groups"."id" = "host_config_groups"."config_group_id" WHERE > "host_config_groups"."host_id" = $1 AND "host_config_groups"."host_type" = > $2 ORDER BY config_groups.name [["host_id", 12], ["host_type", > "Host::Base"]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) SELECT > "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE > 1=0 > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) SELECT > "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE > "hostgroup_classes"."hostgroup_id" = 1 > 2017-06-11 13:41:16 f825c503 [sql] [D] HostClass Load (0.3ms) SELECT > "host_classes".* FROM "host_classes" WHERE "host_classes"."host_id" = $1 > [["host_id", 12]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.3ms) SELECT puppetclasses.id > FROM "puppetclasses" WHERE 1=0 > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.5ms) SELECT DISTINCT > "lookup_keys"."puppetclass_id" FROM "lookup_keys" WHERE > "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.6ms) SELECT DISTINCT > environment_classes.puppetclass_id FROM "lookup_keys" INNER JOIN > "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" > = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') > AND 1=0 > 2017-06-11 13:41:16 f825c503 [sql] [D] Puppetclass Load (0.3ms) SELECT > "puppetclasses".* FROM "puppetclasses" WHERE 1=0 AND 1=0 ORDER BY > puppetclasses.name > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > puppetclasses/_class_parameters.html.erb (0.0ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > puppetclasses/_classes_parameters.html.erb (14.4ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] CommonParameter Load (0.5ms) > SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('CommonParameter') ORDER BY parameters.name > 2017-06-11 13:41:16 f825c503 [sql] [D] DomainParameter Load (0.4ms) > SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('DomainParameter') AND "parameters"."reference_id" = $1 ORDER BY > parameters.name [["reference_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] SubnetParameter Load (0.4ms) > SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('SubnetParameter') AND "parameters"."reference_id" = $1 ORDER BY > parameters.name [["reference_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" > = $1 ORDER BY "operatingsystems"."title" ASC LIMIT 1 [["id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] OsParameter Load (0.5ms) SELECT > "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('OsParameter') AND "parameters"."reference_id" = $1 ORDER BY > parameters.name [["reference_id", 1]] > 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.5ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE 1=0 ORDER BY > coalesce("hostgroups"."ancestry", '') > 2017-06-11 13:41:16 f825c503 [sql] [D] GroupParameter Load (0.4ms) > SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('GroupParameter') AND "parameters"."reference_id" = $1 ORDER BY > parameters.name [["reference_id", 1]] > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > common_parameters/_inherited_parameters.html.erb (0.2ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] HostParameter Load (0.3ms) > SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('HostParameter') AND "parameters"."reference_id" = $1 ORDER BY > parameters.name [["reference_id", 12]] > 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('HostParameter') AND "parameters"."reference_id" = $1 ORDER BY > parameters.name [["reference_id", 12]] > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > common_parameters/_parameter.html.erb (1.5ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > common_parameters/_parameters.html.erb (5.3ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) SELECT auth_sources.id > FROM "auth_sources" WHERE "auth_sources"."type" IN ('AuthSourceHidden') > 2017-06-11 13:41:16 f825c503 [sql] [D] User Load (0.4ms) SELECT > "users".* FROM "users" WHERE ("users"."auth_source_id" NOT IN (2)) ORDER > BY firstname > 2017-06-11 13:41:16 f825c503 [sql] [D] Usergroup Load (0.3ms) SELECT > "usergroups".* FROM "usergroups" ORDER BY usergroups.name > 2017-06-11 13:41:16 f825c503 [sql] [D] Model Load (0.4ms) SELECT > "models".* FROM "models" ORDER BY "models"."name" ASC > 2017-06-11 13:41:16 f825c503 [sql] [D] Model Load (0.3ms) SELECT > "models".* FROM "models" WHERE "models"."id" = $1 ORDER BY models.name > LIMIT 1 [["id", 3]] > 2017-06-11 13:41:16 f825c503 [app] [D] Setting current location > thread-local variable to none > 2017-06-11 13:41:16 f825c503 [app] [D] Setting current organization > thread-local variable to none > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered hosts/_form.html.erb > (241.9ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered hosts/edit.html.erb > within layouts/application (243.7ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > layouts/_application_content.html.erb (0.2ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > home/_user_dropdown.html.erb (1.7ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Read fragment > views/tabs_and_title_records-3 (0.1ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered home/_topbar.html.erb > (5.8ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Rendered layouts/base.html.erb > (7.2ms) > 2017-06-11 13:41:16 f825c503 [app] [I] Completed 200 OK in 423ms (Views: > 229.1ms | ActiveRecord: 37.0ms) > 2017-06-11 13:41:16 f825c503 [sql] [D] (0.1ms) BEGIN > 2017-06-11 13:41:16 f825c503 [sql] [D] SQL (0.4ms) UPDATE "sessions" > SET "data" = $1, "updated_at" = $2 WHERE "sessions"."id" = $3 [["data", > "BAh7CkkiCXVzZXIGOgZFRmkISSIPZXhwaXJlc19hdAY7AEZsKweMVj1ZSSIL\nbG9jYWxlBjsARiIHZW5JIhBfY3NyZl90b2tlbgY7AEZJIjFRSGFaN2JqanVP\nOXdBUmV0anRSaFVHVEpEaUF2SFFpckZtMDBCWjBMVURrPQY7AEZJIiVyZWRp\ncmVjdF90b191cmxfZGlzY292ZXJlZF9ob3N0cwY7AFQiKmh0dHBzOi8vMTcy\nLjIwLjEwMC4yL2Rpc2NvdmVyZWRfaG9zdHM=\n"], > > ["updated_at", "2017-06-11 13:41:16.864800"], ["id", 2785]] > 2017-06-11 13:41:16 f825c503 [sql] [D] (8.6ms) COMMIT > 2017-06-11 13:41:22 f825c503 [app] [I] Started PATCH > "/discovered_hosts/mac000000000000" for 1.1.1.1 at 2017-06-11 13:41:22 +0000 > 2017-06-11 13:41:22 f825c503 [app] [I] Processing by > DiscoveredHostsController#update as */* > 2017-06-11 13:41:22 f825c503 [app] [I] Parameters: {"utf8"=>"✓", > "authenticity_token"=>"kx1mdDcNjoqaWjU1Jx24eCjhmc7crAVJVcj42Tt01uLTa/+Zj+42ZepbIpipydkoTCiX7vOxDeJDpczcpn+G2w==", > > "host"=>{"name"=>"mac000000000000", "hostgroup_id"=>"1", "managed"=>"true", > "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", > "interfaces_attributes"=>{"0"=>{"_destroy"=>"0", > "mac"=>"00:00:00:00:00:00", "identifier"=>"em1", "name"=>"mac000000000000", > "domain_id"=>"", "subnet_id"=>"1", "ip"=>"2.2.2.2", "ip6"=>"", > "managed"=>"1", "primary"=>"1", "provision"=>"1", "tag"=>"", > "attached_to"=>"", "id"=>"21"}, "1"=>{"_destroy"=>"0", > "mac"=>"00:00:00:00:00:00", "identifier"=>"em2", "name"=>"", > "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", "managed"=>"0", > "primary"=>"0", "provision"=>"0", "tag"=>"", "attached_to"=>"", > "id"=>"22"}, "2"=>{"_destroy"=>"0", "mac"=>"00:00:00:00:00:00", > "identifier"=>"em3", "name"=>"", "domain_id"=>"", "subnet_id"=>"", > "ip"=>"", "ip6"=>"", "managed"=>"0", "primary"=>"0", "provision"=>"0", > "tag"=>"", "attached_to"=>"", "id"=>"23"}, "3"=>{"_destroy"=>"0", > "mac"=>"00:00:00:00:00:00", "identifier"=>"em4", "name"=>"", > "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", "managed"=>"0", > "primary"=>"0", "provision"=>"0", "tag"=>"", "attached_to"=>"", > "id"=>"24"}, "4"=>{"_destroy"=>"0", "mac"=>"00:00:00:00:00:00", > "identifier"=>"ipmi", "name"=>"", "domain_id"=>"", "subnet_id"=>"", > "ip"=>"192.168.0.120", "ip6"=>"", "managed"=>"0", "primary"=>"0", > "provision"=>"0", "username"=>"", "provider"=>"IPMI", "id"=>"27"}, > "5"=>{"_destroy"=>"0", "mac"=>"00:00:00:00:00:00", "identifier"=>"p3p1", > "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", > "managed"=>"0", "primary"=>"0", "provision"=>"0", "tag"=>"", > "attached_to"=>"", "id"=>"25"}, "6"=>{"_destroy"=>"0", > "mac"=>"00:00:00:00:00:00", "identifier"=>"p3p2", "name"=>"", > "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", "managed"=>"0", > "primary"=>"0", "provision"=>"0", "tag"=>"", "attached_to"=>"", > "id"=>"26"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", > "build"=>"1", "medium_id"=>"9", "ptable_id"=>"80", "pxe_loader"=>"PXELinux > BIOS", "disk"=>"", "is_owned_by"=>"3-Users", "enabled"=>"1", > "model_id"=>"3", "comment"=>"", "overwrite"=>"false"}, > "fakepassword"=>"[FILTERED]", "bare_metal_capabilities"=>"build", > "id"=>"mac000000000000"} > 2017-06-11 13:41:22 f825c503 [sql] [D] > ActiveRecord::SessionStore::Session Load (0.7ms) SELECT "sessions".* FROM > "sessions" WHERE "sessions"."session_id" = $1 ORDER BY "sessions"."id" ASC > LIMIT 1 [["session_id", "f825c5039243217a9989ad65570411fe"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] User Load (0.6ms) SELECT > "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 3]] > 2017-06-11 13:41:22 f825c503 [app] [D] Setting current user thread-local > variable to admin > 2017-06-11 13:41:22 f825c503 [sql] [D] AuthSource Load (0.6ms) SELECT > "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 LIMIT > 1 [["id", 1]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Host::Discovered Load (0.7ms) > SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Discovered') > AND "hosts"."id" = $1 ORDER BY hosts.created_at DESC LIMIT 1 [["id", 0]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Host::Discovered Load (0.8ms) > SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Discovered') > AND "hosts"."name" = $1 ORDER BY hosts.created_at DESC LIMIT 1 [["name", > "mac000000000000"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (1.1ms) SELECT > "nics".* FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY > "nics"."identifier" ASC [["host_id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] (0.3ms) BEGIN > 2017-06-11 13:41:22 f825c503 [sql] [D] Subnet Load (1.0ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND "subnets"."type" = > $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.7ms) SELECT > "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "2.2.2.2"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > "nics".* FROM "nics" WHERE "nics"."domain_id" IS NULL AND "nics"."name" = > $1 [["name", "mac000000000000"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "192.168.0.120"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > 2017-06-11 13:41:22 f825c503 [sql] [D] (0.2ms) COMMIT > 2017-06-11 13:41:22 f825c503 [sql] [D] Hostgroup Load (0.6ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = $1 ORDER BY > hostgroups.title LIMIT 1 [["title", "1"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Hostgroup Load (0.6ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > hostgroups.title LIMIT 1 [["id", 1]] > 2017-06-11 13:41:22 f825c503 [sql] [D] User Load (0.6ms) SELECT > "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1 > [["id", 3]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.7ms) SELECT > "nics".* FROM "nics" WHERE "nics"."host_id" = $1 AND "nics"."id" IN (21, > 22, 23, 24, 27, 25, 26) ORDER BY "nics"."identifier" ASC [["host_id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Hostgroup Load (0.7ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > hostgroups.title LIMIT 1 [["id", 1]] > 2017-06-11 13:41:22 f825c503 [sql] [D] FactValue Load (1.3ms) SELECT > "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = $1 > [["host_id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] FactName Load (2.9ms) SELECT > "fact_names".* FROM "fact_names" WHERE "fact_names"."id" IN (365, 370, 3, > 65, 404, 77, 244, 257, 255, 258, 260, 261, 259, 59, 74, 395, 396, 397, 398, > 399, 400, 401, 402, 403, 202, 197, 405, 406, 407, 408, 117, 118, 200, 300, > 75, 447, 448, 449, 450, 451, 452, 453, 454, 455, 385, 456, 457, 458, 459, > 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, > 393, 394, 60, 63, 378, 306, 445, 446, 62, 64, 20, 21, 22, 8, 9, 7, 97, 312, > 327, 309, 307, 310, 379, 94, 11, 12, 10, 17, 18, 16, 19, 301, 302, 303, > 304, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, > 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 305, > 24, 26, 437, 364, 380, 66, 67, 438, 206, 381, 382, 383, 384, 439, 440, 441, > 442, 443, 444) ORDER BY fact_names.name > 2017-06-11 13:41:22 f825c503 [sql] [D] Setting Load (0.6ms) SELECT > "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY > "settings"."name" ASC LIMIT 1 [["name", "discovery_clean_facts"]] > 2017-06-11 13:41:22 f825c503 [app] [D] Setting current organization > thread-local variable to none > 2017-06-11 13:41:22 f825c503 [app] [D] Setting current location > thread-local variable to none > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = $1 > [["host_id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "fact_names".* FROM "fact_names" WHERE "fact_names"."id" IN (365, 370, 3, > 65, 404, 77, 244, 257, 255, 258, 260, 261, 259, 59, 74, 395, 396, 397, 398, > 399, 400, 401, 402, 403, 202, 197, 405, 406, 407, 408, 117, 118, 200, 300, > 75, 447, 448, 449, 450, 451, 452, 453, 454, 455, 385, 456, 457, 458, 459, > 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, > 393, 394, 60, 63, 378, 306, 445, 446, 62, 64, 20, 21, 22, 8, 9, 7, 97, 312, > 327, 309, 307, 310, 379, 94, 11, 12, 10, 17, 18, 16, 19, 301, 302, 303, > 304, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, > 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 305, > 24, 26, 437, 364, 380, 66, 67, 438, 206, 381, 382, 383, 384, 439, 440, 441, > 442, 443, 444) ORDER BY fact_names.name > 2017-06-11 13:41:22 f825c503 [sql] [D] (0.4ms) BEGIN > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "nics".* > FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY "nics"."identifier" ASC > [["host_id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Host::Base Load (1.0ms) SELECT > "hosts".* FROM "hosts" WHERE "hosts"."id" = $1 LIMIT 1 [["id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "hosts".* > FROM "hosts" WHERE "hosts"."id" = $1 LIMIT 1 [["id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "hosts".* > FROM "hosts" WHERE "hosts". > ... -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
