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})