Started PUT "/hosts/nmagnezi_quantum_metadata.scl.fqdn" for IP_Net.4.171 at 2013-08-04 12:16:40 +0300

Processing by HostsController#update as */*

Parameters: {"utf8"=>"✓", "authenticity_token"=>"jkBY/G9Yo15DS32wR/7J25pFpFQAOmkRZzvIppj7Gdw=", "host"=>{"name"=>"nmagnezi_neutron_metadata", "hostgroup_id"=>"45", "environment_id"=>"10", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "puppetclass_ids"=>[""], "managed"=>"1", "progress_report_id"=>"[FILTERED]", "mac"=>"00:1a:4a:16:97:3c", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"IP_Net.161.60", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"1", "operatingsystem_id"=>"7", "provision_method"=>"build", "medium_id"=>"9", "ptable_id"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"12-Users", "enabled"=>"1", "model_id"=>"3", "comment"=>"", "overwrite"=>"false"}, "id"=>"nmagnezi_quantum_metadata.scl.fqdn"}

User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT 1 [["id", 12]]

Setting current user thread-local variable to nmagnezi

(0.4ms) SELECT `taxonomies`.id FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'User' AND (taxonomies.type='Organization')

(0.2ms) SELECT COUNT(*) FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND ( (taxonomies.id in (1)))

Organization Load (0.2ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND ( (taxonomies.id in (1))) ORDER BY type, name LIMIT 1

Setting current organization thread-local variable to QE-Test

Role Load (0.3ms) SELECT `roles`.* FROM `roles` INNER JOIN `user_roles` ON `roles`.`id` = `user_roles`.`role_id` WHERE `user_roles`.`user_id` = 12

Usergroup Load (0.3ms) SELECT `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON `usergroups`.`id` = `usergroup_members`.`usergroup_id` WHERE `usergroup_members`.`member_id` = 12 AND `usergroup_members`.`member_type` = 'User' ORDER BY LOWER(usergroups.name)

(0.3ms) SELECT `domains`.id FROM `domains` INNER JOIN `user_domains` ON `domains`.`id` = `user_domains`.`domain_id` WHERE `user_domains`.`user_id` = 12 AND (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name

(0.3ms) SELECT `compute_resources`.id FROM `compute_resources` INNER JOIN `user_compute_resources` ON `compute_resources`.`id` = `user_compute_resources`.`compute_resource_id` WHERE `user_compute_resources`.`user_id` = 12 AND (compute_resources.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'ComputeResource' AND taxonomy_id in (1) ) ) ORDER BY compute_resources.name

(0.4ms) SELECT `hostgroups`.id FROM `hostgroups` INNER JOIN `user_hostgroups` ON `hostgroups`.`id` = `user_hostgroups`.`hostgroup_id` WHERE `user_hostgroups`.`user_id` = 12 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )

CACHE (0.0ms) SELECT `taxonomies`.id FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'User' AND (taxonomies.type='Organization')

(0.3ms) SELECT `taxonomies`.id FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'User' AND (taxonomies.type='Location')

UserFact Load (0.3ms) SELECT `user_facts`.* FROM `user_facts` WHERE `user_facts`.`user_id` = 12

ComputeResource Load (0.7ms) SELECT `compute_resources`.* FROM `compute_resources` INNER JOIN `user_compute_resources` ON `compute_resources`.`id` = `user_compute_resources`.`compute_resource_id` WHERE `user_compute_resources`.`user_id` = 12 AND (compute_resources.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'ComputeResource' AND taxonomy_id in (1) ) ) ORDER BY compute_resources.name

Domain Load (0.3ms) SELECT `domains`.* FROM `domains` INNER JOIN `user_domains` ON `domains`.`id` = `user_domains`.`domain_id` WHERE `user_domains`.`user_id` = 12 AND (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name

(0.4ms) SELECT COUNT(*) FROM `hostgroups` INNER JOIN `user_hostgroups` ON `hostgroups`.`id` = `user_hostgroups`.`hostgroup_id` WHERE `user_hostgroups`.`user_id` = 12 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )

(0.2ms) SELECT COUNT(*) FROM `fact_names` INNER JOIN `user_facts` ON `fact_names`.`id` = `user_facts`.`fact_name_id` WHERE `user_facts`.`user_id` = 12

(0.3ms) SELECT COUNT(*) FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'User' AND (taxonomies.type='Location')

(0.3ms) SELECT COUNT(*) FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'User' AND (taxonomies.type='Organization')

Host::Base Load (0.6ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`name` = 'nmagnezi_quantum_metadata.scl.fqdn' AND ((hosts.organization_id in (1)) ) LIMIT 1

Setting current organization thread-local variable to none

Setting current location thread-local variable to none

SQL (0.1ms) BEGIN

Puppetclass Load (0.3ms) SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 231 ORDER BY puppetclasses.name

User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = ? ORDER BY firstname LIMIT 1 [["id", 12]]

Hostgroup Load (0.3ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 45 AND (1=1) LIMIT 1

Environment Load (0.2ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 ORDER BY environments.name LIMIT 1

Domain Load (0.2ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1

SmartProxy Load (0.2ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1

CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1

Operatingsystem Load (0.3ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 7 ORDER BY LOWER(operatingsystems.name) LIMIT 1

Architecture Load (0.2ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1

Medium Load (0.3ms) SELECT `media`.* FROM `media` WHERE `media`.`id` = 9 ORDER BY media.name LIMIT 1

Ptable Load (0.2ms) SELECT `ptables`.* FROM `ptables` WHERE `ptables`.`id` = 1 ORDER BY LOWER(ptables.name) LIMIT 1

Subnet Load (0.3ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 ORDER BY vlanid LIMIT 1

LookupValue Load (0.2ms) SELECT lookup_values.* FROM lookup_values WHERE (lookup_values.match = 'fqdn=nmagnezi_neutron_metadata.scl.fqdn')

Host::Base Exists (0.3ms) SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'nmagnezi_neutron_metadata.scl.fqdn' AND `hosts`.`id` != 231) LIMIT 1

Host::Managed Exists (0.7ms) SELECT 1 AS one FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND (`hosts`.`ip` = BINARY 'IP_Net.161.60' AND `hosts`.`id` != 231) LIMIT 1

Host::Managed Exists (0.7ms) SELECT 1 AS one FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND (`hosts`.`mac` = BINARY '00:1a:4a:16:97:3c' AND `hosts`.`id` != 231) LIMIT 1

CACHE (0.0ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 ORDER BY vlanid LIMIT 1

CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1

ConfigTemplate Load (0.8ms) SELECT `config_templates`.* FROM `config_templates` INNER JOIN `config_templates_operatingsystems` ON `config_templates_operatingsystems`.`config_template_id` = `config_templates`.`id` INNER JOIN `operatingsystems` ON `operatingsystems`.`id` = `config_templates_operatingsystems`.`operatingsystem_id` INNER JOIN `template_kinds` ON `template_kinds`.`id` = `config_templates`.`template_kind_id` INNER JOIN `template_combinations` ON `template_combinations`.`config_template_id` = `config_templates`.`id` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` INNER JOIN `template_combinations` `template_combinations_config_templates_join` ON `template_combinations_config_templates_join`.`config_template_id` = `config_templates`.`id` INNER JOIN `environments` ON `environments`.`id` = `template_combinations_config_templates_join`.`environment_id` WHERE `operatingsystems`.`id` = 7 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 45 AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1

ConfigTemplate Load (0.6ms) SELECT `config_templates`.* FROM `config_templates` INNER JOIN `config_templates_operatingsystems` ON `config_templates_operatingsystems`.`config_template_id` = `config_templates`.`id` INNER JOIN `operatingsystems` ON `operatingsystems`.`id` = `config_templates_operatingsystems`.`operatingsystem_id` INNER JOIN `template_kinds` ON `template_kinds`.`id` = `config_templates`.`template_kind_id` INNER JOIN `template_combinations` ON `template_combinations`.`config_template_id` = `config_templates`.`id` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 7 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 45 ORDER BY config_templates.name LIMIT 1

ConfigTemplate Load (0.7ms) SELECT `config_templates`.* FROM `config_templates` INNER JOIN `config_templates_operatingsystems` ON `config_templates_operatingsystems`.`config_template_id` = `config_templates`.`id` INNER JOIN `operatingsystems` ON `operatingsystems`.`id` = `config_templates_operatingsystems`.`operatingsystem_id` INNER JOIN `template_kinds` ON `template_kinds`.`id` = `config_templates`.`template_kind_id` INNER JOIN `template_combinations` ON `template_combinations`.`config_template_id` = `config_templates`.`id` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 7 AND `template_kinds`.`name` = 'PXELinux' AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1

ConfigTemplate Load (0.7ms) SELECT `config_templates`.* FROM `config_templates` INNER JOIN `config_templates_operatingsystems` ON `config_templates_operatingsystems`.`config_template_id` = `config_templates`.`id` INNER JOIN `operatingsystems` ON `operatingsystems`.`id` = `config_templates_operatingsystems`.`operatingsystem_id` INNER JOIN `template_kinds` ON `template_kinds`.`id` = `config_templates`.`template_kind_id` INNER JOIN `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 7 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 7 ORDER BY config_templates.name LIMIT 1

Ptable Exists (0.2ms) SELECT 1 AS one FROM `ptables` INNER JOIN `operatingsystems_ptables` ON `ptables`.`id` = `operatingsystems_ptables`.`ptable_id` WHERE `operatingsystems_ptables`.`operatingsystem_id` = 7 AND `ptables`.`id` = 1 ORDER BY LOWER(ptables.name) LIMIT 1

Medium Exists (0.2ms) SELECT 1 AS one FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 7 AND `media`.`id` = 9 ORDER BY media.name LIMIT 1

Architecture Exists (0.2ms) SELECT 1 AS one FROM `architectures` INNER JOIN `architectures_operatingsystems` ON `architectures`.`id` = `architectures_operatingsystems`.`architecture_id` WHERE `architectures_operatingsystems`.`operatingsystem_id` = 7 AND `architectures`.`id` = 1 LIMIT 1

Puppetclass Load (0.3ms) SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 231 ORDER BY puppetclasses.name

(0.1ms) ROLLBACK

Organization Load (0.2ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` IS NULL LIMIT 1

Location Load (0.2ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` IS NULL LIMIT 1

Organization Load (0.2ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` = 1 LIMIT 1

CACHE (0.0ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` IS NULL LIMIT 1

CACHE (0.0ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` IS NULL LIMIT 1

Failed to save: Ip has already been taken, Mac has already been taken

Rendered hosts/_progress.erb (0.1ms)

Setting current organization thread-local variable to QE-Test

Setting current location thread-local variable to none

(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` = 'Puppet' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) )

CACHE (0.0ms) SELECT COUNT(*) FROM `hostgroups` INNER JOIN `user_hostgroups` ON `hostgroups`.`id` = `user_hostgroups`.`hostgroup_id` WHERE `user_hostgroups`.`user_id` = 12 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )

Hostgroup Load (1.1ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )

Environment Load (0.4ms) SELECT `environments`.* FROM `environments` WHERE (environments.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Environment' AND taxonomy_id in (1) ) ) ORDER BY environments.name

(0.2ms) 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` = 'Puppet CA' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) )

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` = 'Puppet CA' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) ) ORDER BY smart_proxies.name

CACHE (0.0ms) 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` = 'Puppet' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) )

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` = 'Puppet' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) ) ORDER BY smart_proxies.name

Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)

Puppetclass Load (0.6ms) SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `hostgroup_classes` ON `hostgroup_classes`.`puppetclass_id` = `puppetclasses`.`id` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `hostgroup_classes`.`hostgroup_id` WHERE `hostgroups`.`id` IN (13, 25, 45) ORDER BY puppetclasses.name

CACHE (0.0ms) SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `hostgroup_classes` ON `hostgroup_classes`.`puppetclass_id` = `puppetclasses`.`id` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `hostgroup_classes`.`hostgroup_id` WHERE `hostgroups`.`id` IN (13, 25, 45) ORDER BY puppetclasses.name

Started POST "/fact_values/create" for IP_Net.16.190 at 2013-08-04 12:16:40 +0300

Processing by FactValuesController#create as */*

Parameters: {"facts"=>"[FILTERED]"}

Puppetclass Load (0.8ms) SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 10 ORDER BY puppetclasses.name

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` = 'Puppet' ORDER BY smart_proxies.name

Verifying request from ["theforeman.eng.fqdn"] against ["theforeman.eng.fqdn"]

User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' LIMIT 1

Setting current user thread-local variable to admin

Setting current organization thread-local variable to none

Setting current location thread-local variable to none

Host::Managed Load (0.5ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`name` = 'mars.scl.fqdn' LIMIT 1

FactValue Load (0.7ms) SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 102

FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` IN (73, 89, 3285, 35, 152, 6, 3325, 24, 64, 23, 150, 3255, 52, 51, 19, 157, 37, 21, 45, 47, 10, 17, 91, 39, 22, 32, 65, 28, 88, 40, 155, 54, 5, 31, 92, 43, 156, 9, 34, 26, 20, 53, 33, 38, 74, 7, 5365, 75, 2, 3324, 49, 63, 57, 68, 1663, 62, 46, 3265, 61, 1661, 90, 55, 154, 42, 36, 48, 3, 27, 71, 153, 30, 4, 70, 56, 69, 1, 3326, 2061, 16, 15, 2062, 2063, 2064, 50, 59, 8, 18, 14) ORDER BY LOWER(fact_names.name)

SQL (5.1ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (64692550)

Rendered puppetclasses/_classes.html.erb (59.3ms)

Rendered puppetclasses/_class_selection.html.erb (163.2ms)

Domain Load (0.4ms) SELECT `domains`.* FROM `domains` WHERE (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name

(0.2ms) SELECT COUNT(*) FROM `subnets` INNER JOIN `subnet_domains` ON `subnets`.`id` = `subnet_domains`.`subnet_id` WHERE `subnet_domains`.`domain_id` = 1

CACHE (0.0ms) SELECT COUNT(*) FROM `subnets` INNER JOIN `subnet_domains` ON `subnets`.`id` = `subnet_domains`.`subnet_id` WHERE `subnet_domains`.`domain_id` = 1

Subnet Load (0.7ms) SELECT `subnets`.* FROM `subnets` INNER JOIN `subnet_domains` ON `subnets`.`id` = `subnet_domains`.`subnet_id` WHERE `subnet_domains`.`domain_id` = 1 ORDER BY vlanid

Rendered common/_domain.html.erb (15.8ms)

Nic::Base Load (0.2ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 231

CACHE (0.0ms) SELECT `domains`.* FROM `domains` WHERE (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name

CACHE (0.0ms) SELECT `domains`.* FROM `domains` WHERE (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name

CACHE (0.0ms) SELECT `domains`.* FROM `domains` WHERE (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name

Rendered hosts/_interfaces.html.erb (10.4ms)

Architecture Load (0.2ms) SELECT `architectures`.* FROM `architectures`

Operatingsystem Load (0.3ms) SELECT `operatingsystems`.* FROM `operatingsystems` INNER JOIN `architectures_operatingsystems` ON `operatingsystems`.`id` = `architectures_operatingsystems`.`operatingsystem_id` WHERE `architectures_operatingsystems`.`architecture_id` = 1 ORDER BY LOWER(operatingsystems.name)

Rendered common/os_selection/_architecture.html.erb (3.6ms)

Medium Load (0.2ms) SELECT `media`.* FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 7 ORDER BY media.name

Ptable Load (0.2ms) SELECT `ptables`.* FROM `ptables` INNER JOIN `operatingsystems_ptables` ON `ptables`.`id` = `operatingsystems_ptables`.`ptable_id` WHERE `operatingsystems_ptables`.`operatingsystem_id` = 7 ORDER BY LOWER(ptables.name)

Rendered common/os_selection/_operatingsystem.html.erb (4.5ms)

Rendered hosts/_operating_system.html.erb (12.5ms)

Rendered hosts/_unattended.html.erb (45.0ms)

CACHE (0.0ms) SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `hostgroup_classes` ON `hostgroup_classes`.`puppetclass_id` = `puppetclasses`.`id` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `hostgroup_classes`.`hostgroup_id` WHERE `hostgroups`.`id` IN (13, 25, 45) ORDER BY puppetclasses.name

(0.2ms) SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM `lookup_keys` WHERE `lookup_keys`.`puppetclass_id` IN (123, 422, 112, 113, 451, 114, 119, 439, 110, 120) GROUP BY puppetclass_id

(0.3ms) SELECT COUNT(*) AS count_all, environment_classes.puppetclass_id AS environment_classes_puppetclass_id FROM `lookup_keys` INNER JOIN `environment_classes` ON `environment_classes`.`lookup_key_id` = `lookup_keys`.`id` WHERE `environment_classes`.`puppetclass_id` IN (123, 422, 112, 113, 451, 114, 119, 439, 110, 120) GROUP BY environment_classes.puppetclass_id

Rendered puppetclasses/_class_parameters.html.erb (0.0ms)

Rendered puppetclasses/_classes_parameters.html.erb (4.1ms)

CommonParameter Load (0.2ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter')

DomainParameter Load (0.2ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('DomainParameter') AND `parameters`.`reference_id` = 1

OsParameter Load (0.2ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('OsParameter') AND `parameters`.`reference_id` = 7

Hostgroup Load (0.4ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (13, 25, 45) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )

GroupParameter Load (0.2ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('GroupParameter') AND `parameters`.`reference_id` IN (13, 25, 45)

Rendered common_parameters/_inherited_parameters.erb (1.8ms)

Rendered common_parameters/_puppetclasses_parameters.erb (0.4ms)

HostParameter Load (0.2ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 231

Rendered common_parameters/_parameters.erb (1.6ms)

User Load (0.9ms) SELECT `users`.* FROM `users` WHERE (users.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'User' AND taxonomy_id in (1) ) OR users.admin = 1) ORDER BY firstname

Usergroup Load (0.2ms) SELECT `usergroups`.* FROM `usergroups` ORDER BY LOWER(usergroups.name)

Model Load (0.3ms) SELECT `models`.* FROM `models` ORDER BY LOWER(models.name)

Setting current location thread-local variable to none

Setting current organization thread-local variable to none

Rendered hosts/_form.html.erb (266.9ms)

Rendered hosts/edit.html.erb within layouts/application (268.5ms)

Rendered home/_user_dropdown.html.erb (1.1ms)

Read fragment views/tabs_and_title_records-12 (0.1ms)

Rendered home/_topbar.html.erb (2.6ms)

Setting current location thread-local variable to none

Setting current organization thread-local variable to QE-Test

Completed 200 OK in 373ms (Views: 265.3ms | ActiveRecord: 25.6ms)

(197.6ms) SELECT MAX(`fact_names`.`id`) AS maximum_id, name AS name FROM `fact_names` GROUP BY name ORDER BY LOWER(fact_names.name)

SQL (0.1ms) BEGIN

(0.3ms) UPDATE `hosts` SET `last_compile` = '2013-08-04 09:16:40', `updated_at` = '2013-08-04 09:16:41' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 102

SQL (103.1ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["fact_name_id", 12], ["host_id", 102], ["updated_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["value", "580"]]

SQL (1.2ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["fact_name_id", 1655], ["host_id", 102], ["updated_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["value", "04-08-13 12:16"]]

SQL (1.0ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["fact_name_id", 41], ["host_id", 102], ["updated_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["value", "13.20 GB"]]

SQL (1.1ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["fact_name_id", 29], ["host_id", 102], ["updated_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["value", "2089829"]]

SQL (1.6ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["fact_name_id", 14], ["host_id", 102], ["updated_at", Sun, 04 Aug 2013 09:16:41 UTC +00:00], ["value", 2013-08-04 12:16:40 +0300]]

(10.9ms) COMMIT

Model Load (0.6ms) SELECT `models`.* FROM `models` WHERE `models`.`name` = 'PowerEdge R210 II' ORDER BY LOWER(models.name) LIMIT 1

Domain Load (0.2ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`name` = 'scl.fqdn' ORDER BY domains.name LIMIT 1

Architecture Load (0.2ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`name` = 'x86_64' LIMIT 1

Operatingsystem Load (0.4ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`name` = 'RedHat' AND `operatingsystems`.`major` = '6' AND `operatingsystems`.`minor` = '4' ORDER BY LOWER(operatingsystems.name) LIMIT 1

CACHE (0.0ms) SELECT `models`.* FROM `models` WHERE `models`.`name` = 'PowerEdge R210 II' ORDER BY LOWER(models.name) LIMIT 1

Environment Load (0.2ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`name` = 'qe_common' ORDER BY environments.name LIMIT 1

Environment Load (0.2ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 ORDER BY environments.name LIMIT 1

SQL (0.1ms) BEGIN

(0.1ms) COMMIT

SQL (0.1ms) BEGIN

(0.1ms) COMMIT

Rendered text template (0.0ms)

Setting current location thread-local variable to none

Setting current organization thread-local variable to none

Completed 200 OK in 471ms (Views: 0.8ms | ActiveRecord: 326.7ms)

Started GET "/node/mars.scl.fqdn?format=yml" for IP_Net.16.190 at 2013-08-04 12:16:41 +0300

Processing by HostsController#externalNodes as YML

Parameters: {"name"=>"mars.scl.fqdn"}

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` = 'Puppet' ORDER BY smart_proxies.name

Verifying request from ["theforeman.eng.fqdn"] against ["theforeman.eng.fqdn"]

User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' LIMIT 1

Setting current user thread-local variable to admin

Host::Managed Load (0.4ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`certname` = 'mars.scl.fqdn' LIMIT 1

SmartProxy Load (0.2ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1

Domain Load (0.2ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1

Hostgroup Load (0.2ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 25 AND (1=1) LIMIT 1

Organization Load (0.2ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` = 1 LIMIT 1

CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1

Environment Load (0.1ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 ORDER BY environments.name LIMIT 1

User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 36 ORDER BY firstname LIMIT 1

CommonParameter Load (0.2ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter')

DomainParameter Load (0.3ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('DomainParameter') AND `parameters`.`reference_id` = 1

Operatingsystem Load (0.2ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 7 ORDER BY LOWER(operatingsystems.name) LIMIT 1

OsParameter Load (0.3ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('OsParameter') AND `parameters`.`reference_id` = 7

Hostgroup Load (0.3ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (13, 25) AND (1=1)

GroupParameter Load (0.4ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('GroupParameter') AND `parameters`.`reference_id` IN (13, 25)

HostParameter Load (0.3ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 102

(0.2ms) SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 102

(0.2ms) SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IN (13, 25)

LookupKey Load (0.4ms) SELECT `lookup_keys`.* FROM `lookup_keys` WHERE `lookup_keys`.`puppetclass_id` IN (123, 112, 113, 119, 120, 110, 422) ORDER BY lookup_keys.key

CACHE (0.0ms) SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 102

CACHE (0.0ms) SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IN (13, 25)

SQL (1.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`.`is_param` AS t0_r10, `lookup_keys`.`key_type` AS t0_r11, `lookup_keys`.`override` AS t0_r12, `lookup_keys`.`required` AS t0_r13, `lookup_keys`.`lookup_values_count` AS t0_r14, `environment_classes`.`id` AS t1_r0, `environment_classes`.`puppetclass_id` AS t1_r1, `environment_classes`.`environment_id` AS t1_r2, `environment_classes`.`lookup_key_id` AS t1_r3 FROM `lookup_keys` INNER JOIN `environment_classes` ON `environment_classes`.`lookup_key_id` = `lookup_keys`.`id` WHERE `lookup_keys`.`override` = 1 AND `environment_classes`.`puppetclass_id` IN (123, 112, 113, 119, 120, 110, 422) AND `environment_classes`.`environment_id` = 10 ORDER BY lookup_keys.key

Puppetclass Load (0.3ms) SELECT `puppetclasses`.* FROM `puppetclasses` WHERE `puppetclasses`.`id` IN (123, 112, 113, 119, 120, 110, 422) ORDER BY puppetclasses.name

Rendered text template (0.0ms)

Completed 200 OK in 40ms (Views: 0.8ms | ActiveRecord: 6.4ms)

Started POST "/reports/create?format=yml" for IP_Net.16.190 at 2013-08-04 12:16:42 +0300

Processing by ReportsController#create as YML

Parameters: {"report"=>"[FILTERED]"}

Started GET "/tasks/7bffa388-47d3-4d53-b951-4fbbba394929" for IP_Net.4.171 at 2013-08-04 12:16:42 +0300

SmartProxy Load (0.5ms) 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` = 'Puppet' ORDER BY smart_proxies.name

Verifying request from ["theforeman.eng.fqdn"] against ["theforeman.eng.fqdn"]

User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' LIMIT 1

Setting current user thread-local variable to admin

Setting current organization thread-local variable to none

Setting current location thread-local variable to none

Processing by TasksController#show as */*

Parameters: {"id"=>"7bffa388-47d3-4d53-b951-4fbbba394929"}

User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT 1 [["id", 12]]

Setting current user thread-local variable to nmagnezi

Role Load (0.3ms) SELECT `roles`.* FROM `roles` INNER JOIN `user_roles` ON `roles`.`id` = `user_roles`.`role_id` WHERE `user_roles`.`user_id` = 12

Rendered tasks/_list.html.erb (0.1ms)

Completed 200 OK in 6ms (Views: 0.8ms | ActiveRecord: 0.7ms)

processing report for mars.scl.fqdn

Host::Managed Load (0.7ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`certname` = 'mars.scl.fqdn' LIMIT 1

SQL (0.1ms) BEGIN

(0.3ms) UPDATE `hosts` SET `last_report` = '2013-08-04 09:16:39', `updated_at` = '2013-08-04 09:16:42' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 102

(5.9ms) COMMIT

SQL (0.1ms) BEGIN

Report Exists (0.3ms) SELECT 1 AS one FROM `reports` WHERE (`reports`.`reported_at` = BINARY '2013-08-04 09:16:39' AND `reports`.`host_id` = 102) LIMIT 1

SQL (1.9ms) INSERT INTO `reports` (`created_at`, `host_id`, `metrics`, `reported_at`, `status`, `updated_at`) VALUES (?, ?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:16:42 UTC +00:00], ["host_id", 102], ["metrics", "--- \n time: \n config_retrieval: 1.04876208305359\n file: 0.001825\n filebucket: 0.000129\n package: 0.00073\n schedule: 0.000726\n service: 0.107853\n ssh_authorized_key: 0.002753\n total: 1.16277808305359\n resources: \n total: 21\n changes: \n total: 0\n events: \n total: 0"], ["reported_at", Sun, 04 Aug 2013 09:16:39 UTC +00:00], ["status", 0], ["updated_at", Sun, 04 Aug 2013 09:16:42 UTC +00:00]]

(7.8ms) COMMIT

Rendered text template (0.0ms)

Setting current location thread-local variable to none

Setting current organization thread-local variable to none

Completed 200 OK in 60ms (Views: 0.7ms | ActiveRecord: 18.0ms)