No ETA yet, you can use this scratchbuild it will work: http://koji.katello.org/koji/taskinfo?taskID=6018
Report back if it fixes your issue. LZ On Tue, Jun 13, 2017 at 1:32 PM, Ido Kaplan <[email protected]> wrote: > 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. -- Later, Lukas @lzap Zapletal -- 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.
