Project

General

Profile

Bug #17395 » provision_template_get.log

Tomasz Gromowski, 11/23/2016 09:02 AM

 
2016-11-23 14:56:31 5987ebed [app] [I] Started GET "/unattended/provision?token=94c0f4d4-e4f8-4e24-9358-2ee94c924826" for 10.0.200.216 at 2016-11-23 14:56:31 +0100
2016-11-23 14:56:31 5987ebed [app] [I] Processing by UnattendedController#host_template as TEXT
2016-11-23 14:56:31 5987ebed [app] [I] Parameters: {"token"=>"94c0f4d4-e4f8-4e24-9358-2ee94c924826", "kind"=>"provision"}
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: _session_id:5987ebedeb8ac0cabaa7bb2108b234bf
2016-11-23 14:56:31 5987ebed [app] [I] 127.0.0.1:11211 failed (count: 0) EOFError: end of file reached
2016-11-23 14:56:31 5987ebed [app] [D] #<Dalli::NetworkError: Socket operation failed, retrying...>
2016-11-23 14:56:31 5987ebed [app] [D] retrying request with new server
2016-11-23 14:56:31 5987ebed [app] [D] Dalli::Server#connect 127.0.0.1:11211
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: authorize_login_delegation
2016-11-23 14:56:31 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "authorize_login_delegation"]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache write: authorize_login_delegation
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: authorize_login_delegation
2016-11-23 14:56:31 5987ebed [sql] [D] Host::Managed Load (0.6ms) SELECT hosts.* FROM "hosts" INNER JOIN "tokens" ON "tokens"."host_id" = "hosts"."id" WHERE "hosts"."type" IN ('Host::Managed') AND "tokens"."value" = $1 AND (expires >= '2016-11-23 13:56:31') ORDER BY "hosts"."id" ASC LIMIT 1 [["value", "94c0f4d4-e4f8-4e24-9358-2ee94c924826"]]
2016-11-23 14:56:31 5987ebed [sql] [D] Operatingsystem Load (0.2ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = $1 ORDER BY "operatingsystems"."title" ASC LIMIT 1 [["id", 12]]
2016-11-23 14:56:31 5987ebed [app] [D] Found mac525400d1a2d4.tech
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: manage_puppetca
2016-11-23 14:56:31 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "manage_puppetca"]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache write: manage_puppetca
2016-11-23 14:56:31 5987ebed [sql] [D] SmartProxy Load (0.2ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = $1 ORDER BY smart_proxies.name LIMIT 1 [["id", 1]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: manage_puppetca
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: proxy_request_timeout
2016-11-23 14:56:31 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "proxy_request_timeout"]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache write: proxy_request_timeout
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: ssl_certificate
2016-11-23 14:56:31 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "ssl_certificate"]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache write: ssl_certificate
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: ssl_ca_file
2016-11-23 14:56:31 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "ssl_ca_file"]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache write: ssl_ca_file
2016-11-23 14:56:31 5987ebed [app] [D] Cache read: ssl_priv_key
2016-11-23 14:56:31 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "ssl_priv_key"]]
2016-11-23 14:56:31 5987ebed [app] [D] Cache write: ssl_priv_key
2016-11-23 14:56:31 5987ebed [sql] [I] Remove puppet certificate for mac525400d1a2d4.tech
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: use_uuid_for_certificates
2016-11-23 14:56:32 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "use_uuid_for_certificates"]]
2016-11-23 14:56:32 5987ebed [app] [D] Cache write: use_uuid_for_certificates
2016-11-23 14:56:32 5987ebed [sql] [D] Nic::Base Load (0.3ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY "nics"."identifier" ASC [["host_id", 13]]
2016-11-23 14:56:32 5987ebed [sql] [D] Domain Load (0.2ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY domains.name LIMIT 1 [["id", 2]]
2016-11-23 14:56:32 5987ebed [sql] [I] Adding autosign entry for mac525400d1a2d4.tech
2016-11-23 14:56:32 5987ebed [sql] [D] Ptable Load (0.2ms) SELECT "templates".* FROM "templates" WHERE "templates"."type" IN ('Ptable') AND "templates"."id" = $1 ORDER BY templates.name LIMIT 1 [["id", 96]]
2016-11-23 14:56:32 5987ebed [templates] [I] Rendering template 'MY Kickstart LVM'
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:32 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "safemode_render"]]
2016-11-23 14:56:32 5987ebed [app] [D] Cache write: safemode_render
2016-11-23 14:56:32 5987ebed [sql] [D] CommonParameter Load (0.3ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') ORDER BY parameters.name
2016-11-23 14:56:32 5987ebed [sql] [D] DomainParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = $1 AND (1=0) ORDER BY parameters.name [["reference_id", 2]]
2016-11-23 14:56:32 5987ebed [sql] [D] Subnet Load (0.3ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND "subnets"."type" = $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]]
2016-11-23 14:56:32 5987ebed [sql] [D] SubnetParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('SubnetParameter') AND "parameters"."reference_id" = $1 AND (1=0) ORDER BY parameters.name [["reference_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] OsParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = $1 AND (1=0) ORDER BY parameters.name [["reference_id", 12]]
2016-11-23 14:56:32 5987ebed [sql] [D] Hostgroup Load (0.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY hostgroups.title LIMIT 1 [["id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] Hostgroup Load (0.3ms) SELECT "hostgroups".* FROM "hostgroups" WHERE 1=0 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] GroupParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = $1 AND (1=0) ORDER BY parameters.name [["reference_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] HostParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('HostParameter') AND "parameters"."reference_id" = $1 AND (1=0) ORDER BY parameters.name [["reference_id", 13]]
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "Enable_Smart_Variables_in_ENC"]]
2016-11-23 14:56:32 5987ebed [app] [D] Cache write: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] Environment Load (0.2ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = $1 ORDER BY environments.name LIMIT 1 [["id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] Hostgroup Load (0.3ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] (0.2ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] (0.2ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] (0.2ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] (0.2ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] HostClass Load (0.1ms) SELECT "host_classes".* FROM "host_classes" WHERE "host_classes"."host_id" = $1 [["host_id", 13]]
2016-11-23 14:56:32 5987ebed [sql] [D] (0.2ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] VariableLookupKey Load (0.3ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] LookupValue Load (0.3ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] VariableLookupKey Load (0.2ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] Architecture Load (0.2ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = $1 LIMIT 1 [["id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] Medium Load (0.2ms) SELECT "media".* FROM "media" WHERE "media"."id" = $1 ORDER BY media.name LIMIT 1 [["id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] ProvisioningTemplate Load (0.8ms) 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" = 12 AND "template_kinds"."name" = 'provision' AND "template_combinations"."hostgroup_id" = 1 AND "template_combinations"."environment_id" = 1 ORDER BY templates.name LIMIT 1
2016-11-23 14:56:32 5987ebed [sql] [D] ProvisioningTemplate Load (0.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 "template_combinations" ON "template_combinations"."provisioning_template_id" = "templates"."id" WHERE "templates"."type" IN ('ProvisioningTemplate') AND "operatingsystems"."id" = 12 AND "template_kinds"."name" = 'provision' AND "template_combinations"."hostgroup_id" = 1 AND "template_combinations"."environment_id" IS NULL ORDER BY templates.name LIMIT 1
2016-11-23 14:56:32 5987ebed [sql] [D] ProvisioningTemplate Load (0.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 "template_combinations" ON "template_combinations"."provisioning_template_id" = "templates"."id" WHERE "templates"."type" IN ('ProvisioningTemplate') AND "operatingsystems"."id" = 12 AND "template_kinds"."name" = 'provision' AND "template_combinations"."hostgroup_id" IS NULL AND "template_combinations"."environment_id" = 1 ORDER BY templates.name LIMIT 1
2016-11-23 14:56:32 5987ebed [sql] [D] ProvisioningTemplate Load (0.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 "os_default_templates" ON "os_default_templates"."provisioning_template_id" = "templates"."id" WHERE "templates"."type" IN ('ProvisioningTemplate') AND "operatingsystems"."id" = 12 AND "template_kinds"."name" = 'provision' AND "os_default_templates"."operatingsystem_id" = 12 ORDER BY templates.name LIMIT 1
2016-11-23 14:56:32 5987ebed [sql] [D] User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."lower_login" = $1 LIMIT 1 [["lower_login", "foreman_admin"]]
2016-11-23 14:56:32 5987ebed [app] [D] Setting current user thread-local variable to foreman_admin
2016-11-23 14:56:32 5987ebed [templates] [I] Rendering template 'Kickstart default'
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = $1 ORDER BY smart_proxies.name LIMIT 1 [["id", 1]]
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:32 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "legacy_puppet_hostname"]]
2016-11-23 14:56:32 5987ebed [app] [D] Cache write: legacy_puppet_hostname
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:32 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:32 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [sql] [D] User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1 [["id", 5]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: ignore_puppet_facts_for_provisioning
2016-11-23 14:56:33 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "ignore_puppet_facts_for_provisioning"]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache write: ignore_puppet_facts_for_provisioning
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [sql] [D] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "interpolate_erb_in_parameters"]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache write: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Parametrized_Classes_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "Parametrized_Classes_in_ENC"]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache write: Parametrized_Classes_in_ENC
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] SQL (0.3ms) SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."key_type" AS t0_r10, "lookup_keys"."override" AS t0_r11, "lookup_keys"."required" AS t0_r12, "lookup_keys"."merge_overrides" AS t0_r13, "lookup_keys"."avoid_duplicates" AS t0_r14, "lookup_keys"."use_puppet_default" AS t0_r15, "lookup_keys"."type" AS t0_r16, "lookup_keys"."merge_default" AS t0_r17, "lookup_keys"."hidden_value" AS t0_r18, "environment_classes"."puppetclass_id" AS t1_r0, "environment_classes"."environment_id" AS t1_r1, "environment_classes"."id" AS t1_r2, "environment_classes"."puppetclass_lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "lookup_keys"."override" = $1 AND "environment_classes"."environment_id" = $2 AND 1=0 ORDER BY lookup_keys.key [["override", "t"], ["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] SQL (0.3ms) SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."key_type" AS t0_r10, "lookup_keys"."override" AS t0_r11, "lookup_keys"."required" AS t0_r12, "lookup_keys"."merge_overrides" AS t0_r13, "lookup_keys"."avoid_duplicates" AS t0_r14, "lookup_keys"."use_puppet_default" AS t0_r15, "lookup_keys"."type" AS t0_r16, "lookup_keys"."merge_default" AS t0_r17, "lookup_keys"."hidden_value" AS t0_r18, "environment_classes"."puppetclass_id" AS t1_r0, "environment_classes"."environment_id" AS t1_r1, "environment_classes"."id" AS t1_r2, "environment_classes"."puppetclass_lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" = "lookup_keys"."id" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "lookup_keys"."override" = $1 AND "environment_classes"."environment_id" = $2 AND 1=0 ORDER BY lookup_keys.key [["override", "t"], ["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] LookupValue Load (0.3ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."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 "lookup_keys"."override" = $1 AND "environment_classes"."environment_id" = $2 AND 1=0 ORDER BY lookup_keys.key) [["override", "t"], ["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] Puppetclass Load (0.2ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 ORDER BY puppetclasses.name [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: enc_environment
2016-11-23 14:56:33 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "enc_environment"]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache write: enc_environment
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.1ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.1ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [templates] [I] Rendering template 'MY Kickstart LVM'
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] Template Load (0.3ms) SELECT "templates".* FROM "templates" WHERE "templates"."name" = $1 AND "templates"."snippet" = $2 ORDER BY "templates"."id" ASC LIMIT 1 [["name", "kickstart_networking_setup"], ["snippet", "t"]]
2016-11-23 14:56:33 5987ebed [templates] [I] Rendering template 'kickstart_networking_setup'
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [sql] [D] Nic::Base Load (0.3ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = $1 AND "nics"."type" = $2 AND "nics"."managed" = $3 ORDER BY "nics"."identifier" ASC [["host_id", 13], ["type", "Nic::Bond"], ["managed", "t"]]
2016-11-23 14:56:33 5987ebed [sql] [D] Nic::Base Load (0.3ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = $1 AND "nics"."type" = $2 AND "nics"."managed" = $3 ORDER BY "nics"."identifier" ASC [["host_id", 13], ["type", "Nic::Managed"], ["managed", "t"]]
2016-11-23 14:56:33 5987ebed [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"]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: ignore_puppet_facts_for_provisioning
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: interpolate_erb_in_parameters
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Parametrized_Classes_in_ENC
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."key_type" AS t0_r10, "lookup_keys"."override" AS t0_r11, "lookup_keys"."required" AS t0_r12, "lookup_keys"."merge_overrides" AS t0_r13, "lookup_keys"."avoid_duplicates" AS t0_r14, "lookup_keys"."use_puppet_default" AS t0_r15, "lookup_keys"."type" AS t0_r16, "lookup_keys"."merge_default" AS t0_r17, "lookup_keys"."hidden_value" AS t0_r18, "environment_classes"."puppetclass_id" AS t1_r0, "environment_classes"."environment_id" AS t1_r1, "environment_classes"."id" AS t1_r2, "environment_classes"."puppetclass_lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "lookup_keys"."override" = $1 AND "environment_classes"."environment_id" = $2 AND 1=0 ORDER BY lookup_keys.key [["override", true], ["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."key_type" AS t0_r10, "lookup_keys"."override" AS t0_r11, "lookup_keys"."required" AS t0_r12, "lookup_keys"."merge_overrides" AS t0_r13, "lookup_keys"."avoid_duplicates" AS t0_r14, "lookup_keys"."use_puppet_default" AS t0_r15, "lookup_keys"."type" AS t0_r16, "lookup_keys"."merge_default" AS t0_r17, "lookup_keys"."hidden_value" AS t0_r18, "environment_classes"."puppetclass_id" AS t1_r0, "environment_classes"."environment_id" AS t1_r1, "environment_classes"."id" AS t1_r2, "environment_classes"."puppetclass_lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" = "lookup_keys"."id" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "lookup_keys"."override" = $1 AND "environment_classes"."environment_id" = $2 AND 1=0 ORDER BY lookup_keys.key [["override", true], ["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."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 "lookup_keys"."override" = $1 AND "environment_classes"."environment_id" = $2 AND 1=0 ORDER BY lookup_keys.key) [["override", true], ["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 ORDER BY puppetclasses.name [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: enc_environment
2016-11-23 14:56:33 5987ebed [sql] [D] Template Load (0.3ms) SELECT "templates".* FROM "templates" WHERE "templates"."name" = $1 AND "templates"."snippet" = $2 ORDER BY "templates"."id" ASC LIMIT 1 [["name", "remote_execution_ssh_keys"], ["snippet", "t"]]
2016-11-23 14:56:33 5987ebed [templates] [I] Rendering template 'remote_execution_ssh_keys'
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] Template Load (0.2ms) SELECT "templates".* FROM "templates" WHERE "templates"."name" = $1 AND "templates"."snippet" = $2 ORDER BY "templates"."id" ASC LIMIT 1 [["name", "puppet_setup"], ["snippet", "t"]]
2016-11-23 14:56:33 5987ebed [templates] [I] Rendering template 'puppet_setup'
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] Template Load (0.2ms) SELECT "templates".* FROM "templates" WHERE "templates"."name" = $1 AND "templates"."snippet" = $2 ORDER BY "templates"."id" ASC LIMIT 1 [["name", "puppet.conf"], ["snippet", "t"]]
2016-11-23 14:56:33 5987ebed [templates] [I] Rendering template 'puppet.conf'
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: safemode_render
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: Enable_Smart_Variables_in_ENC
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 1 ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) 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", 13], ["host_type", "Host::Base"]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = $1 AND 1=0 [["environment_id", 1]]
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" INNER JOIN "lookup_values" ON "lookup_values"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_values".* FROM "lookup_values" WHERE 1=0 AND "lookup_values"."lookup_key_id" IN (SELECT "lookup_keys"."id" FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key)
2016-11-23 14:56:33 5987ebed [sql] [D] CACHE (0.0ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND 1=0 ORDER BY lookup_keys.key
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: legacy_puppet_hostname
2016-11-23 14:56:33 5987ebed [app] [D] Cache read: unattended_url
2016-11-23 14:56:33 5987ebed [sql] [D] Setting Load (0.2ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."name" ASC LIMIT 1 [["name", "unattended_url"]]
2016-11-23 14:56:33 5987ebed [app] [D] Cache write: unattended_url
2016-11-23 14:56:33 5987ebed [sql] [D] SmartProxy Load (0.2ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = $1 ORDER BY smart_proxies.name LIMIT 1 [["id", 2]]
2016-11-23 14:56:33 5987ebed [sql] [D] Feature Load (0.2ms) SELECT "features".* FROM "features" INNER JOIN "features_smart_proxies" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features_smart_proxies"."smart_proxy_id" = $1 [["smart_proxy_id", 2]]
2016-11-23 14:56:33 5987ebed [sql] [D] Token Load (0.2ms) SELECT "tokens".* FROM "tokens" WHERE "tokens"."host_id" = $1 LIMIT 1 [["host_id", 13]]
2016-11-23 14:56:33 5987ebed [app] [I] Rendered inline template (821.4ms)
2016-11-23 14:56:33 5987ebed [app] [D] Setting current user thread-local variable to nil
2016-11-23 14:56:33 5987ebed [app] [I] Completed 200 OK in 2567ms (Views: 811.2ms | ActiveRecord: 22.8ms)
2016-11-23 14:56:33 5987ebed [app] [D] Cache write: _session_id:7a00103e79284b444b3a4fd642a0a562 ({:expires_in=>86400})
(4-4/6)