|
|
|
|
| Started GET "/hostgroups/1-CentOS7-VM_S-MA/clone" for 192.168.245.75 at 2016-03-17 10:54:03 +0100
|
|
2016-03-17 10:54:03 [app] [I] Processing by HostgroupsController#clone as HTML
|
|
2016-03-17 10:54:03 [app] [I] Parameters: {"id"=>"1-CentOS7-VM_S-MA"}
|
|
2016-03-17 10:54:03 [sql] [D] User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
|
|
2016-03-17 10:54:03 [app] [D] Setting current user thread-local variable to Example User
|
|
2016-03-17 10:54:03 [sql] [D] (0.3ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
|
|
2016-03-17 10:54:03 [app] [D] Setting current organization thread-local variable to none
|
|
2016-03-17 10:54:03 [sql] [D] (0.1ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
|
|
2016-03-17 10:54:03 [app] [D] Setting current location thread-local variable to none
|
|
2016-03-17 10:54:03 [sql] [D] AuthSource Load (0.2ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 3 LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] (0.2ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] (0.1ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Load (0.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = '1-CentOS7-VM_S-MA' ORDER BY hostgroups.title LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Load (0.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY hostgroups.title LIMIT 1 [["id", "1-CentOS7-VM_S-MA"]]
|
|
2016-03-17 10:54:03 [sql] [D] ConfigGroup Load (0.3ms) SELECT "config_groups".* 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" = 'Hostgroup' ORDER BY config_groups.name
|
|
2016-03-17 10:54:03 [sql] [D] LookupValue Load (0.2ms) SELECT "lookup_values".* FROM "lookup_values" WHERE "lookup_values"."match" = 'hostgroup=CentOS7-VM_S-MA'
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Load (0.2ms) SELECT "hostgroup_classes".* FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 1
|
|
2016-03-17 10:54:03 [sql] [D] Taxonomy Load (0.4ms) SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."taxonomy_id" WHERE "taxable_taxonomies"."taxable_id" = 1 AND "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND (taxonomies.type='Location') ORDER BY title
|
|
2016-03-17 10:54:03 [sql] [D] Taxonomy Load (0.4ms) SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."taxonomy_id" WHERE "taxable_taxonomies"."taxable_id" = 1 AND "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND (taxonomies.type='Organization') ORDER BY title
|
|
2016-03-17 10:54:03 [sql] [D] GroupParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
|
|
2016-03-17 10:54:03 [sql] [D] Architecture Load (0.2ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Operatingsystem Load (0.2ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY title LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Domain Load (0.2ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Subnet Load (0.3ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 1 ORDER BY vlanid LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Environment Load (0.2ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 4 ORDER BY environments.name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Realm Load (0.2ms) SELECT "realms".* FROM "realms" WHERE "realms"."id" = 1 ORDER BY realms.name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Setting Load (0.4ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Exists (0.3ms) SELECT 1 AS one FROM "hostgroups" WHERE (LOWER("hostgroups"."name") = LOWER('') AND "hostgroups"."ancestry" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Exists (0.2ms) SELECT 1 AS one FROM "hostgroups" WHERE "hostgroups"."title" = '' LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY title LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Exists (0.3ms) SELECT 1 AS one FROM "hostgroup_classes" WHERE ("hostgroup_classes"."puppetclass_id" = 6 AND "hostgroup_classes"."hostgroup_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Exists (0.2ms) SELECT 1 AS one FROM "hostgroup_classes" WHERE ("hostgroup_classes"."puppetclass_id" = 9 AND "hostgroup_classes"."hostgroup_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Exists (0.2ms) SELECT 1 AS one FROM "hostgroup_classes" WHERE ("hostgroup_classes"."puppetclass_id" = 10 AND "hostgroup_classes"."hostgroup_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Exists (0.2ms) SELECT 1 AS one FROM "hostgroup_classes" WHERE ("hostgroup_classes"."puppetclass_id" = 14 AND "hostgroup_classes"."hostgroup_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Exists (0.2ms) SELECT 1 AS one FROM "hostgroup_classes" WHERE ("hostgroup_classes"."puppetclass_id" = 11 AND "hostgroup_classes"."hostgroup_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] HostgroupClass Exists (0.2ms) SELECT 1 AS one FROM "hostgroup_classes" WHERE ("hostgroup_classes"."puppetclass_id" = 45 AND "hostgroup_classes"."hostgroup_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] GroupParameter Exists (0.3ms) SELECT 1 AS one FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND ("parameters"."name" = 'kt_activation_keys' AND "parameters"."reference_id" IS NULL) LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Katello::ContentView Load (0.2ms) SELECT "katello_content_views".* FROM "katello_content_views" WHERE "katello_content_views"."id" = $1 LIMIT 1 [["id", 3]]
|
|
2016-03-17 10:54:03 [sql] [D] Katello::KTEnvironment Load (0.2ms) SELECT "katello_environments".* FROM "katello_environments" WHERE "katello_environments"."id" = $1 LIMIT 1 [["id", 3]]
|
|
2016-03-17 10:54:03 [sql] [D] Katello::KTEnvironment Exists (0.2ms) SELECT 1 AS one FROM "katello_environments" INNER JOIN "katello_content_view_environments" ON "katello_environments"."id" = "katello_content_view_environments"."environment_id" WHERE "katello_content_view_environments"."content_view_id" = 3 AND "katello_environments"."id" = 3 LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hostgroups"
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Load (0.3ms) SELECT "hostgroups".* FROM "hostgroups" WHERE (1=1) ORDER BY title
|
|
2016-03-17 10:54:03 [sql] [D] Organization Load (0.4ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') ORDER BY title
|
|
2016-03-17 10:54:03 [sql] [D] Katello::KTEnvironment Load (0.2ms) SELECT "katello_environments".* FROM "katello_environments" WHERE "katello_environments"."organization_id" = 1
|
|
2016-03-17 10:54:03 [sql] [D] Katello::KTEnvironment Load (0.2ms) SELECT "katello_environments".* FROM "katello_environments" WHERE "katello_environments"."id" = 3 LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Katello::ContentView Load (0.4ms) SELECT "katello_content_views".* FROM "katello_content_views" INNER JOIN "katello_content_view_environments" ON "katello_content_view_environments"."content_view_id" = "katello_content_views"."id" WHERE (katello_content_view_environments.environment_id = 3)
|
|
2016-03-17 10:54:03 [sql] [D] Environment Load (0.2ms) SELECT "environments".* FROM "environments" ORDER BY environments.name
|
|
2016-03-17 10:54:03 [sql] [D] (0.2ms) SELECT COUNT(*) FROM "smart_proxies" WHERE (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] SmartProxy Load (0.2ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] (0.3ms) SELECT COUNT(DISTINCT "compute_profiles"."id") FROM "compute_profiles" LEFT OUTER JOIN "compute_attributes" ON "compute_attributes"."compute_profile_id" = "compute_profiles"."id" WHERE (compute_attributes.id > 0)
|
|
2016-03-17 10:54:03 [sql] [D] SQL (0.4ms) SELECT "compute_profiles"."id" AS t0_r0, "compute_profiles"."name" AS t0_r1, "compute_profiles"."created_at" AS t0_r2, "compute_profiles"."updated_at" AS t0_r3, "compute_attributes"."id" AS t1_r0, "compute_attributes"."compute_profile_id" AS t1_r1, "compute_attributes"."compute_resource_id" AS t1_r2, "compute_attributes"."name" AS t1_r3, "compute_attributes"."vm_attrs" AS t1_r4, "compute_attributes"."created_at" AS t1_r5, "compute_attributes"."updated_at" AS t1_r6 FROM "compute_profiles" LEFT OUTER JOIN "compute_attributes" ON "compute_attributes"."compute_profile_id" = "compute_profiles"."id" WHERE (compute_attributes.id > 0) ORDER BY compute_profiles.name
|
|
2016-03-17 10:54:03 [sql] [D] (0.3ms) SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet CA') AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] SmartProxy Load (0.4ms) SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet CA') AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] (0.4ms) SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet') AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] SmartProxy Load (0.3ms) SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet') AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] (0.1ms) SELECT COUNT(*) FROM "config_groups"
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Load (0.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IS NULL ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] (0.1ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 4 ORDER BY environments.name LIMIT 1
|
|
2016-03-17 10:54:03 [sql] [D] Puppetclass Load (0.7ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (6, 9, 10, 14, 11, 45) ORDER BY puppetclasses.name
|
|
2016-03-17 10:54:03 [app] [I] Rendered puppetclasses/_selectedClasses.html.erb (4.2ms)
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IS NULL ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
|
|
2016-03-17 10:54:03 [sql] [D] Puppetclass Load (0.4ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL) ORDER BY puppetclasses.name
|
|
2016-03-17 10:54:03 [app] [I] Rendered puppetclasses/_classes_in_groups.html.erb (0.0ms)
|
|
2016-03-17 10:54:03 [sql] [D] Puppetclass Load (1.2ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 ORDER BY puppetclasses.name
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IS NULL ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
|
|
2016-03-17 10:54:03 [sql] [D] (0.2ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
|
|
2016-03-17 10:54:03 [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" = 4 AND "puppetclasses"."id" IN (6, 9, 10, 14, 11, 45) ORDER BY puppetclasses.name
|
|
2016-03-17 10:54:03 [app] [I] Rendered puppetclasses/_classes.html.erb (200.6ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered puppetclasses/_class_selection.html.erb (223.8ms)
|
|
2016-03-17 10:54:03 [sql] [D] Domain Load (0.4ms) SELECT "domains".* FROM "domains" WHERE (1=1) ORDER BY name
|
|
2016-03-17 10:54:03 [sql] [D] (0.3ms) SELECT subnets.id FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 ORDER BY vlanid
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT subnets.id FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 ORDER BY vlanid
|
|
2016-03-17 10:54:03 [sql] [D] (0.3ms) SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (1) AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT subnets.id FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 ORDER BY vlanid
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (1) AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT subnets.id FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 ORDER BY vlanid
|
|
2016-03-17 10:54:03 [sql] [D] Subnet Load (0.4ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" IN (1) AND (1=1) ORDER BY name
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" IN (1) AND (1=1) ORDER BY name
|
|
2016-03-17 10:54:03 [sql] [D] Realm Load (0.4ms) SELECT "realms".* FROM "realms" WHERE (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] Architecture Load (0.3ms) SELECT "architectures".* FROM "architectures"
|
|
2016-03-17 10:54:03 [sql] [D] Operatingsystem Load (0.6ms) SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN "architectures_operatingsystems" ON "operatingsystems"."id" = "architectures_operatingsystems"."operatingsystem_id" WHERE "architectures_operatingsystems"."architecture_id" = 1 ORDER BY title
|
|
2016-03-17 10:54:03 [app] [I] Rendered common/os_selection/_architecture.html.erb (4.2ms)
|
|
2016-03-17 10:54:03 [sql] [D] (0.5ms) SELECT COUNT(*) FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 AND (1=1)
|
|
2016-03-17 10:54:03 [sql] [D] Medium Load (0.3ms) SELECT "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 AND (1=1) ORDER BY media.name
|
|
2016-03-17 10:54:03 [sql] [D] Ptable Load (0.7ms) SELECT "templates".* FROM "templates" INNER JOIN "operatingsystems_ptables" ON "templates"."id" = "operatingsystems_ptables"."ptable_id" WHERE "templates"."type" IN ('Ptable') AND "operatingsystems_ptables"."operatingsystem_id" = 1 ORDER BY templates.name
|
|
2016-03-17 10:54:03 [app] [I] Rendered common/os_selection/_operatingsystem.html.erb (12.1ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered common/os_selection/_initial.html.erb (19.9ms)
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IS NULL ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
|
|
2016-03-17 10:54:03 [sql] [D] (0.7ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (6, 9, 10, 14, 11, 45)
|
|
2016-03-17 10:54:03 [sql] [D] (0.4ms) SELECT DISTINCT puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" IN (6, 11, 14, 45, 9, 10)
|
|
2016-03-17 10:54:03 [sql] [D] (1.0ms) SELECT DISTINCT environment_classes.puppetclass_id FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" IN (6, 11, 14, 45, 9, 10)
|
|
2016-03-17 10:54:03 [sql] [D] Puppetclass Load (1.2ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (6, 9, 10, 14, 11, 45) AND "puppetclasses"."id" IN (6, 14, 45, 10, 11, 9) ORDER BY puppetclasses.name
|
|
2016-03-17 10:54:03 [sql] [D] PuppetclassLookupKey Load (1.1ms) SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."puppetclass_lookup_key_id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" = 6 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 4 AND (environment_classes.puppetclass_lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] VariableLookupKey Load (0.4ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" = 6 ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] PuppetclassLookupKey Load (0.8ms) SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."puppetclass_lookup_key_id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" = 9 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 4 AND (environment_classes.puppetclass_lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] VariableLookupKey Load (0.4ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" = 9 ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] PuppetclassLookupKey Load (0.7ms) SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."puppetclass_lookup_key_id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" = 10 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 4 AND (environment_classes.puppetclass_lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] VariableLookupKey Load (0.3ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" = 10 ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] PuppetclassLookupKey Load (0.9ms) SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."puppetclass_lookup_key_id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" = 11 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 4 AND (environment_classes.puppetclass_lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] VariableLookupKey Load (0.3ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" = 11 ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] Hostgroup Load (0.4ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] PuppetclassLookupKey Load (1.0ms) SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."puppetclass_lookup_key_id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" = 45 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 4 AND (environment_classes.puppetclass_lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] VariableLookupKey Load (0.4ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" = 45 ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] PuppetclassLookupKey Load (0.9ms) SELECT DISTINCT "lookup_keys".* FROM "lookup_keys" INNER JOIN "environment_classes" ON "lookup_keys"."id" = "environment_classes"."puppetclass_lookup_key_id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" = 14 AND "lookup_keys"."override" = 't' AND "environment_classes"."environment_id" = 4 AND (environment_classes.puppetclass_lookup_key_id is NOT NULL) ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] VariableLookupKey Load (0.4ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" = 14 ORDER BY lookup_keys.key
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
|
|
2016-03-17 10:54:03 [app] [I] Rendered puppetclasses/_class_parameters.html.erb (59.3ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered puppetclasses/_classes_parameters.html.erb (73.0ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered common_parameters/_puppetclass_parameter.html.erb (2.3ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered common_parameters/_puppetclasses_parameters.html.erb (3.7ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered common_parameters/_parameter.html.erb (1.4ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered common_parameters/_parameter.html.erb (1.3ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered common_parameters/_parameters.html.erb (4.7ms)
|
|
2016-03-17 10:54:03 [sql] [D] (0.4ms) SELECT COUNT(*) FROM "permissions" WHERE "permissions"."name" = 'view_locations'
|
|
2016-03-17 10:54:03 [sql] [D] Location Load (0.3ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') ORDER BY title
|
|
2016-03-17 10:54:03 [sql] [D] (0.2ms) SELECT COUNT(*) FROM "permissions" WHERE "permissions"."name" = 'view_organizations'
|
|
2016-03-17 10:54:03 [sql] [D] CACHE (0.0ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') ORDER BY title
|
|
2016-03-17 10:54:03 [app] [I] Rendered taxonomies/_loc_org_tabs.html.erb (7.1ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered hostgroups/_form.html.erb (386.1ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered hostgroups/new.html.erb within layouts/application (387.0ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered home/_user_dropdown.html.erb (1.3ms)
|
|
2016-03-17 10:54:03 [app] [I] Read fragment views/tabs_and_title_records-4 (0.1ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered home/_topbar.html.erb (2.3ms)
|
|
2016-03-17 10:54:03 [app] [I] Rendered layouts/base.html.erb (3.4ms)
|
|
2016-03-17 10:54:03 [app] [I] Completed 200 OK in 445ms (Views: 369.0ms | ActiveRecord: 31.3ms)
|
|
2016-03-17 10:54:04 [app] [I]
|
|
|
