Will be fixed in Discovery 9.1, we are having some troubles with our builder so the update is delayed.
LZ On Mon, Jun 12, 2017 at 8:16 AM, Ido Kaplan <[email protected]> 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"."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"."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] HostStatus::Status Load (1.0ms) > SELECT "host_status".* FROM "host_status" WHERE "host_status"."host_id" = $1 > [["host_id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Setting Load (0.5ms) SELECT > "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY > "settings"."name" ASC LIMIT 1 [["name", "token_duration"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Token Load (0.8ms) SELECT > "tokens".* FROM "tokens" WHERE "tokens"."host_id" = $1 LIMIT 1 [["host_id", > 12]] > 2017-06-11 13:41:22 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:22 f825c503 [sql] [D] Setting Load (0.5ms) SELECT > "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY > "settings"."name" ASC LIMIT 1 [["name", "use_uuid_for_certificates"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Operatingsystem Load (0.7ms) > SELECT "operatingsystems".* FROM "operatingsystems" WHERE > "operatingsystems"."id" = $1 ORDER BY "operatingsystems"."title" ASC LIMIT > 1 [["id", 1]] > 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"."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"."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"."id" = $1 LIMIT 1 [["id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.5ms) SELECT > "nics".* FROM "nics" WHERE "nics"."virtual" = $1 AND "nics"."managed" = $2 > AND "nics"."mac" = $3 [["virtual", "f"], ["managed", "t"], ["mac", > "00:00:00:00:00:00"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Domain Load (0.6ms) SELECT > "domains".* FROM "domains" WHERE "domains"."id" IS NULL ORDER BY > domains.name LIMIT 1 > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "nics".* FROM > "nics" WHERE "nics"."ip" = $1 [["ip", "2.2.2.2"]] > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) 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] SmartProxy Load (0.5ms) SELECT > "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = $1 > ORDER BY smart_proxies.name LIMIT 1 [["id", 1]] > 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] ProvisioningTemplate Load (1.9ms) > SELECT "templates".* FROM "templates" INNER JOIN > "operatingsystems_provisioning_templates" ON > "operatingsystems_provisioning_templates"."provisioning_template_id" = > "templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = > "operatingsystems_provisioning_templates"."operatingsystem_id" INNER JOIN > "template_kinds" ON "template_kinds"."id" = "templates"."template_kind_id" > INNER JOIN "template_combinations" ON > "template_combinations"."provisioning_template_id" = "templates"."id" WHERE > "templates"."type" IN ('ProvisioningTemplate') AND "operatingsystems"."id" = > 1 AND "template_kinds"."name" = 'PXELinux' AND > "template_combinations"."hostgroup_id" = 1 AND > "template_combinations"."environment_id" IS NULL ORDER BY templates.name > LIMIT 1 > 2017-06-11 13:41:22 f825c503 [sql] [D] ProvisioningTemplate Load (1.7ms) > SELECT "templates".* FROM "templates" INNER JOIN > "operatingsystems_provisioning_templates" ON > "operatingsystems_provisioning_templates"."provisioning_template_id" = > "templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = > "operatingsystems_provisioning_templates"."operatingsystem_id" INNER JOIN > "template_kinds" ON "template_kinds"."id" = "templates"."template_kind_id" > INNER JOIN "os_default_templates" ON > "os_default_templates"."provisioning_template_id" = "templates"."id" WHERE > "templates"."type" IN ('ProvisioningTemplate') AND "operatingsystems"."id" = > 1 AND "template_kinds"."name" = 'PXELinux' AND > "os_default_templates"."operatingsystem_id" = 1 ORDER BY templates.name > LIMIT 1 > 2017-06-11 13:41:22 f825c503 [app] [D] Setting current location thread-local > variable to none > 2017-06-11 13:41:22 f825c503 [app] [D] Setting current organization > thread-local variable to none > 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"."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"."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"."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"."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"."id" = $1 LIMIT 1 [["id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.1ms) 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"."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"."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"."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"."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"."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"."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"."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"."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 "nics".* FROM > "nics" WHERE "nics"."ip" = $1 [["ip", "192.168.0.120"]] > 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"."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"."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"."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"."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"."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"."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"."id" = $1 LIMIT 1 [["id", 12]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Host::Base Exists (0.8ms) SELECT > 1 AS one FROM "hosts" WHERE ("hosts"."name" = 'mac000000000000' AND > "hosts"."id" != 12) LIMIT 1 > 2017-06-11 13:41:22 f825c503 [sql] [D] HostParameter Load (0.8ms) 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:22 f825c503 [sql] [D] HostStatus::Status Exists (0.8ms) > SELECT 1 AS one FROM "host_status" WHERE ("host_status"."host_id" = 12 AND > "host_status"."type" = 'HostStatus::BuildStatus') LIMIT 1 > 2017-06-11 13:41:22 f825c503 [sql] [D] Domain Load (0.6ms) SELECT > "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY domains.name > LIMIT 1 [["id", 1]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Queueing Realm > 2017-06-11 13:41:22 f825c503 [sql] [D] Ptable Load (0.7ms) SELECT > "templates".* FROM "templates" WHERE "templates"."type" IN ('Ptable') AND > "templates"."id" = $1 ORDER BY templates.name LIMIT 1 [["id", 80]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Ptable Exists (0.6ms) SELECT 1 AS > one 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 "templates"."id" = > $2 LIMIT 1 [["operatingsystem_id", 1], ["id", 80]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Medium Load (0.6ms) SELECT > "media".* FROM "media" WHERE "media"."id" = $1 ORDER BY media.name LIMIT 1 > [["id", 9]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Medium Exists (0.5ms) SELECT 1 AS > one FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = > "media_operatingsystems"."medium_id" WHERE > "media_operatingsystems"."operatingsystem_id" = $1 AND "media"."id" = $2 > LIMIT 1 [["operatingsystem_id", 1], ["id", 9]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Architecture Load (0.6ms) SELECT > "architectures".* FROM "architectures" WHERE "architectures"."id" = $1 LIMIT > 1 [["id", 1]] > 2017-06-11 13:41:22 f825c503 [sql] [D] Architecture Exists (0.5ms) SELECT > 1 AS one FROM "architectures" INNER JOIN "architectures_operatingsystems" ON > "architectures"."id" = "architectures_operatingsystems"."architecture_id" > WHERE "architectures_operatingsystems"."operatingsystem_id" = $1 AND > "architectures"."id" = $2 LIMIT 1 [["operatingsystem_id", 1], ["id", 1]] > 2017-06-11 13:41:22 f825c503 [sql] [D] (0.3ms) ROLLBACK > 2017-06-11 13:41:22 f825c503 [app] [I] Failed to save: Domain can't be > blank, Interfaces.domain can't find domain with this id > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered hosts/_progress.html.erb > (0.6ms) > 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] SmartProxy Load (0.7ms) 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:22 f825c503 [sql] [D] Hostgroup Load (0.5ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE (1=1) ORDER BY "hostgroups"."title" > ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] Environment Load (0.4ms) SELECT > "environments".* FROM "environments" WHERE (1=1) ORDER BY > "environments"."name" ASC > 2017-06-11 13:41:22 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:22 f825c503 [sql] [D] SmartProxy Load (0.7ms) 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:22 f825c503 [sql] [D] Realm Load (0.4ms) SELECT > "realms".* FROM "realms" WHERE (1=1) ORDER BY "realms"."name" ASC > 2017-06-11 13:41:22 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:22 f825c503 [sql] [D] Domain Load (0.3ms) SELECT > "domains".* FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] Subnet::Ipv4 Load (0.4ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND > (1=1) ORDER BY "subnets"."name" ASC > 2017-06-11 13:41:22 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:22 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:22 f825c503 [sql] [D] Subnet::Ipv6 Load (0.4ms) SELECT > "subnets".* FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND > (1=1) ORDER BY "subnets"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.1ms) SELECT "subnets".* > FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) ORDER > BY "subnets"."name" ASC > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (22.3ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.7ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.6ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (33.7ms) > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 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:22 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:22 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:22 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:22 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:22 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.8ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.0ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.3ms) > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:22 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:22 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:22 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:22 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:22 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:22 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.3ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.1ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:22 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (15.7ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 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:23 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:23 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:23 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:23 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:23 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.4ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (15.9ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 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:23 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:23 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:23 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:23 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:23 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.8ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered nic/bmcs/_bmc.html.erb > (20.2ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 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:23 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:23 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:23 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:23 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:23 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.8ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.4ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 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:23 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:23 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:23 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:23 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:23 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.4ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (16.0ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] CACHE (0.0ms) SELECT "domains".* > FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > 2017-06-11 13:41:23 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:23 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:23 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:23 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:23 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:23 f825c503 [app] [I] Rendered nic/_base_form.html.erb > (13.8ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered nic/_virtual_form.html.erb > (1.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/_provider_specific_form.html.erb (0.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > nic/manageds/_managed.html.erb (19.2ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered hosts/_interfaces.html.erb > (164.5ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] Architecture Load (0.7ms) SELECT > "architectures".* FROM "architectures" ORDER BY "architectures"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.5ms) 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:23 f825c503 [sql] [D] Operatingsystem Load (0.5ms) > 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:23 f825c503 [app] [I] Rendered > common/os_selection/_architecture.html.erb (5.9ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.5ms) 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:23 f825c503 [sql] [D] Medium Load (0.5ms) 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:23 f825c503 [sql] [D] (0.5ms) 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:23 f825c503 [sql] [D] Ptable Load (0.6ms) 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:23 f825c503 [app] [I] Rendered > common/os_selection/_pxe_loader.html.erb (1.8ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > common/os_selection/_operatingsystem.html.erb (14.7ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > hosts/provision_method/build/_form.html.erb (18.7ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > hosts/provision_method/image/_form.html.erb (0.4ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > hosts/_operating_system.html.erb (36.5ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered hosts/_unattended.html.erb > (38.7ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] Hostgroup Load (0.6ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1) ORDER BY > coalesce("hostgroups"."ancestry", '') > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.5ms) 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:23 f825c503 [sql] [D] (0.4ms) 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:23 f825c503 [sql] [D] (0.3ms) SELECT > "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE > 1=0 > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.3ms) SELECT > "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE > "hostgroup_classes"."hostgroup_id" = 1 > 2017-06-11 13:41:23 f825c503 [sql] [D] HostClass Load (0.2ms) SELECT > "host_classes".* FROM "host_classes" WHERE "host_classes"."host_id" = $1 > [["host_id", 12]] > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.3ms) SELECT puppetclasses.id > FROM "puppetclasses" WHERE 1=0 > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.4ms) SELECT DISTINCT > "lookup_keys"."puppetclass_id" FROM "lookup_keys" WHERE "lookup_keys"."type" > IN ('VariableLookupKey') AND 1=0 > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.4ms) 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:23 f825c503 [sql] [D] Puppetclass Load (0.4ms) SELECT > "puppetclasses".* FROM "puppetclasses" WHERE 1=0 AND 1=0 ORDER BY > puppetclasses.name > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > puppetclasses/_class_parameters.html.erb (0.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > puppetclasses/_classes_parameters.html.erb (15.3ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] CommonParameter Load (0.4ms) > SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > ('CommonParameter') ORDER BY parameters.name > 2017-06-11 13:41:23 f825c503 [sql] [D] DomainParameter Load (0.3ms) > 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:23 f825c503 [sql] [D] SubnetParameter Load (0.3ms) > 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:23 f825c503 [sql] [D] OsParameter Load (0.3ms) 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:23 f825c503 [sql] [D] Hostgroup Load (0.3ms) SELECT > "hostgroups".* FROM "hostgroups" WHERE 1=0 ORDER BY > coalesce("hostgroups"."ancestry", '') > 2017-06-11 13:41:23 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:23 f825c503 [app] [I] Rendered > common_parameters/_inherited_parameters.html.erb (1.2ms) > 2017-06-11 13:41:23 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:23 f825c503 [app] [I] Rendered > common_parameters/_parameter.html.erb (2.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > common_parameters/_parameters.html.erb (7.7ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.4ms) SELECT auth_sources.id > FROM "auth_sources" WHERE "auth_sources"."type" IN ('AuthSourceHidden') > 2017-06-11 13:41:23 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:23 f825c503 [sql] [D] Usergroup Load (0.3ms) SELECT > "usergroups".* FROM "usergroups" ORDER BY usergroups.name > 2017-06-11 13:41:23 f825c503 [sql] [D] Model Load (0.3ms) SELECT > "models".* FROM "models" ORDER BY "models"."name" ASC > 2017-06-11 13:41:23 f825c503 [sql] [D] Model Load (0.4ms) SELECT > "models".* FROM "models" WHERE "models"."id" = $1 ORDER BY models.name > LIMIT 1 [["id", 3]] > 2017-06-11 13:41:23 f825c503 [app] [D] Setting current location thread-local > variable to none > 2017-06-11 13:41:23 f825c503 [app] [D] Setting current organization > thread-local variable to none > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered hosts/_form.html.erb > (286.4ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered hosts/edit.html.erb within > layouts/application (290.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > layouts/_application_content.html.erb (0.9ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered > home/_user_dropdown.html.erb (2.3ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Read fragment > views/tabs_and_title_records-3 (0.1ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered home/_topbar.html.erb > (8.9ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Rendered layouts/base.html.erb > (12.8ms) > 2017-06-11 13:41:23 f825c503 [app] [D] Setting current location thread-local > variable to none > 2017-06-11 13:41:23 f825c503 [app] [D] Setting current organization > thread-local variable to none > 2017-06-11 13:41:23 f825c503 [app] [I] Completed 200 OK in 1179ms (Views: > 293.7ms | ActiveRecord: 62.9ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.2ms) BEGIN > 2017-06-11 13:41:23 f825c503 [sql] [D] SQL (0.4ms) UPDATE "sessions" SET > "data" = $1, "updated_at" = $2 WHERE "sessions"."id" = $3 [["data", > "BAh7CkkiCXVzZXIGOgZFRmkISSIPZXhwaXJlc19hdAY7AEZsKweSVj1ZSSIL\nbG9jYWxlBjsARiIHZW5JIhBfY3NyZl90b2tlbgY7AEZJIjFRSGFaN2JqanVP\nOXdBUmV0anRSaFVHVEpEaUF2SFFpckZtMDBCWjBMVURrPQY7AEZJIiVyZWRp\ncmVjdF90b191cmxfZGlzY292ZXJlZF9ob3N0cwY7AFQiKmh0dHBzOi8vMTcy\nLjIwLjEwMC4yL2Rpc2NvdmVyZWRfaG9zdHM=\n"], > ["updated_at", "2017-06-11 13:41:23.206041"], ["id", 2785]] > 2017-06-11 13:41:23 f825c503 [sql] [D] (9.0ms) COMMIT > 2017-06-11 13:41:23 f825c503 [app] [I] Started GET > "/tasks/f500a0e8-ffe3-4360-8292-189350991d14" for 1.1.1.1 at 2017-06-11 > 13:41:23 +0000 > 2017-06-11 13:41:23 f825c503 [app] [I] Processing by TasksController#show as > */* > 2017-06-11 13:41:23 f825c503 [app] [I] Parameters: > {"id"=>"f500a0e8-ffe3-4360-8292-189350991d14"} > 2017-06-11 13:41:23 f825c503 [sql] [D] ActiveRecord::SessionStore::Session > Load (0.8ms) SELECT "sessions".* FROM "sessions" WHERE > "sessions"."session_id" = $1 ORDER BY "sessions"."id" ASC LIMIT 1 > [["session_id", "f825c5039243217a9989ad65570411fe"]] > 2017-06-11 13:41:23 f825c503 [sql] [D] User Load (0.7ms) SELECT > "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 3]] > 2017-06-11 13:41:23 f825c503 [app] [D] Setting current user thread-local > variable to admin > 2017-06-11 13:41:23 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:23 f825c503 [app] [I] Rendered tasks/_list.html.erb > (1.0ms) > 2017-06-11 13:41:23 f825c503 [app] [I] Completed 200 OK in 23ms (Views: > 10.8ms | ActiveRecord: 2.3ms) > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.2ms) BEGIN > 2017-06-11 13:41:23 f825c503 [sql] [D] (0.2ms) COMMIT > > > Thanks! > Ido > > -- > 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.
