|
Started POST "/fact_values/create" for IP_Net.16.190 at 2013-08-04 12:15:12 +0300
|
|
Processing by FactValuesController#create as */*
|
|
Parameters: {"facts"=>"[FILTERED]"}
|
|
SmartProxy Load (0.6ms) 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.4ms) 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.6ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`name` = 'puma01.scl.fqdn' LIMIT 1
|
|
FactValue Load (1.0ms) SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 18
|
|
FactName Load (1.2ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` IN (16, 44, 59, 32, 10, 47, 64, 55, 57, 28, 153, 1663, 65, 35, 52, 3265, 15, 76, 46, 45, 43, 22, 39, 25, 56, 34, 49, 27, 61, 62, 53, 36, 155, 152, 72, 5365, 7, 9, 3289, 63, 154, 24, 54, 67, 2, 33, 37, 157, 73, 156, 3255, 48, 75, 19, 71, 69, 51, 60, 17, 20, 70, 1, 5609, 5608, 68, 74, 31, 26, 3285, 23, 3277, 6, 11, 30, 38, 77, 40, 4, 78, 3, 42, 21, 5, 1654, 92, 1661, 91, 88, 1658, 90, 3324, 3325, 89, 50, 41, 8, 18, 1655, 29, 14) ORDER BY LOWER(fact_names.name)
|
|
SQL (9.0ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (64692547, 64692545, 64692546)
|
|
(214.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:15:12', `updated_at` = '2013-08-04 09:15:12' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 18
|
|
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:15:12 UTC +00:00], ["fact_name_id", 12], ["host_id", 18], ["updated_at", Sun, 04 Aug 2013 09:15:12 UTC +00:00], ["value", "265"]]
|
|
SQL (1.3ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:15:12 UTC +00:00], ["fact_name_id", 14], ["host_id", 18], ["updated_at", Sun, 04 Aug 2013 09:15:12 UTC +00:00], ["value", 2013-08-04 12:15:12 +0300]]
|
|
(12.4ms) COMMIT
|
|
Model Load (0.4ms) SELECT `models`.* FROM `models` WHERE `models`.`name` = 'ProLiant DL170e G6' 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.1ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`name` = 'x86_64' LIMIT 1
|
|
Operatingsystem Load (0.2ms) 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` = 'ProLiant DL170e G6' ORDER BY LOWER(models.name) LIMIT 1
|
|
Environment Load (0.1ms) 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.0ms) BEGIN
|
|
(0.1ms) COMMIT
|
|
SQL (0.0ms) 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 482ms (Views: 0.6ms | ActiveRecord: 244.0ms)
|
|
|
|
|
|
Started GET "/node/puma01.scl.fqdn?format=yml" for IP_Net.16.190 at 2013-08-04 12:15:12 +0300
|
|
Processing by HostsController#externalNodes as YML
|
|
Parameters: {"name"=>"puma01.scl.fqdn"}
|
|
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.4ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' LIMIT 1
|
|
Setting current user thread-local variable to admin
|
|
Host::Managed Load (0.7ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`certname` = 'puma01.scl.fqdn' LIMIT 1
|
|
SmartProxy Load (0.3ms) 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.4ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 25 AND (1=1) LIMIT 1
|
|
Organization Load (0.3ms) 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.3ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 ORDER BY environments.name LIMIT 1
|
|
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 21 ORDER BY firstname LIMIT 1
|
|
CommonParameter Load (0.3ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter')
|
|
DomainParameter Load (0.4ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('DomainParameter') AND `parameters`.`reference_id` = 1
|
|
Operatingsystem Load (0.3ms) 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.4ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (13, 25) AND (1=1)
|
|
GroupParameter Load (0.3ms) 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` = 18
|
|
(0.2ms) SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 18
|
|
(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` = 18
|
|
CACHE (0.0ms) SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IN (13, 25)
|
|
SQL (1.1ms) 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 49ms (Views: 0.7ms | ActiveRecord: 8.0ms)
|
|
|
|
|
|
Started POST "/reports/create?format=yml" for IP_Net.16.190 at 2013-08-04 12:15:14 +0300
|
|
Processing by ReportsController#create as YML
|
|
Parameters: {"report"=>"[FILTERED]"}
|
|
SmartProxy Load (0.7ms) SELECT `smart_proxies`.* FROM `smart_proxies` INNER JOIN `features_smart_proxies` ON `features_smart_proxies`.`smart_proxy_id` = `smart_proxies`.`id` INNER JOIN `features` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features`.`name` = 'Puppet' ORDER BY smart_proxies.name
|
|
Verifying request from ["theforeman.eng.fqdn"] against ["theforeman.eng.fqdn"]
|
|
User Load (0.4ms) 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
|
|
|
|
|
|
Started GET "/hosts/nmagnezi_quantum_metadata.scl.fqdn/setBuild" for IP_Net.4.171 at 2013-08-04 12:15:14 +0300
|
|
processing report for puma01.scl.fqdn
|
|
Host::Managed Load (1.2ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`certname` = 'puma01.scl.fqdn' LIMIT 1
|
|
SQL (0.1ms) BEGIN
|
|
(0.3ms) UPDATE `hosts` SET `last_report` = '2013-08-04 09:15:10', `updated_at` = '2013-08-04 09:15:14' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 18
|
|
(11.6ms) COMMIT
|
|
SQL (0.1ms) BEGIN
|
|
Report Exists (0.5ms) SELECT 1 AS one FROM `reports` WHERE (`reports`.`reported_at` = BINARY '2013-08-04 09:15:10' AND `reports`.`host_id` = 18) LIMIT 1
|
|
SQL (2.3ms) INSERT INTO `reports` (`created_at`, `host_id`, `metrics`, `reported_at`, `status`, `updated_at`) VALUES (?, ?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:15:14 UTC +00:00], ["host_id", 18], ["metrics", "--- \n time: \n config_retrieval: 1.15560483932495\n file: 0.004232\n filebucket: 0.000614\n package: 0.001174\n schedule: 0.001704\n service: 0.247856\n ssh_authorized_key: 0.00647\n total: 1.41765483932495\n resources: \n total: 21\n changes: \n total: 0\n events: \n total: 0"], ["reported_at", Sun, 04 Aug 2013 09:15:10 UTC +00:00], ["status", 0], ["updated_at", Sun, 04 Aug 2013 09:15:14 UTC +00:00]]
|
|
(16.9ms) 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 209ms (Views: 0.9ms | ActiveRecord: 34.0ms)
|
|
Processing by HostsController#setBuild as HTML
|
|
Parameters: {"id"=>"nmagnezi_quantum_metadata.scl.fqdn"}
|
|
User Load (0.7ms) 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.4ms) 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.2ms) SELECT `user_facts`.* FROM `user_facts` WHERE `user_facts`.`user_id` = 12
|
|
ComputeResource Load (0.6ms) 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
|
|
SQL (0.2ms) DELETE FROM `fact_values` WHERE (host_id = 231)
|
|
SQL (0.1ms) DELETE FROM `reports` WHERE (host_id = 231)
|
|
SQL (0.1ms) BEGIN
|
|
Hostgroup Load (0.3ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 45 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) LIMIT 1
|
|
Environment Load (0.2ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 AND (environments.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Environment' AND taxonomy_id in (1) ) ) ORDER BY environments.name LIMIT 1
|
|
Domain Load (0.3ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 AND (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name LIMIT 1
|
|
SmartProxy Load (0.2ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 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 LIMIT 1
|
|
CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 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 LIMIT 1
|
|
Operatingsystem Load (0.2ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 7 ORDER BY LOWER(operatingsystems.name) LIMIT 1
|
|
Architecture Load (0.1ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
|
|
Medium Load (0.2ms) 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
|
|
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 12 AND (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 LIMIT 1
|
|
LookupValue Load (0.2ms) SELECT lookup_values.* FROM lookup_values WHERE (lookup_values.match = 'fqdn=nmagnezi_quantum_metadata.scl.fqdn')
|
|
Host::Base Exists (0.2ms) SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'nmagnezi_quantum_metadata.scl.fqdn' AND `hosts`.`id` != 231) LIMIT 1
|
|
Host::Managed Exists (0.5ms) 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.8ms) 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 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 LIMIT 1
|
|
ConfigTemplate Load (0.5ms) 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.4ms) 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.4ms) 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.5ms) 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.1ms) 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.2ms) 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
|
|
Failed to save: Ip has already been taken, Mac has already been taken
|
|
Redirected to https://theforeman.eng.fqdn/hosts/nmagnezi_quantum_metadata.scl.fqdn
|
|
Completed 302 Found in 517ms (ActiveRecord: 28.7ms)
|
|
|
|
|
|
Started GET "/hosts/nmagnezi_quantum_metadata.scl.fqdn" for IP_Net.4.171 at 2013-08-04 12:15:14 +0300
|
|
Processing by HostsController#show as HTML
|
|
Parameters: {"id"=>"nmagnezi_quantum_metadata.scl.fqdn"}
|
|
User Load (0.4ms) 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.4ms) 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.8ms) 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.7ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`name` = 'nmagnezi_quantum_metadata.scl.fqdn' AND ((hosts.organization_id in (1)) ) LIMIT 1
|
|
Report Load (0.6ms) SELECT status FROM `reports` WHERE `reports`.`host_id` = 231 AND (reported_at > '2013-07-28 09:15:14') ORDER BY reported_at
|
|
Operatingsystem Load (0.5ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 7 ORDER BY LOWER(operatingsystems.name) LIMIT 1
|
|
SmartProxy Load (0.4ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 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 LIMIT 1
|
|
(0.2ms) SELECT COUNT(*) FROM `reports` WHERE `reports`.`host_id` = 231
|
|
Nic::Base Load (0.4ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 231 AND `nics`.`type` = 'Nic::BMC' LIMIT 1
|
|
FactValue Load (0.3ms) SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 231
|
|
(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) ) )
|
|
Domain Load (0.3ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 AND (domains.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Domain' AND taxonomy_id in (1) ) ) ORDER BY domains.name LIMIT 1
|
|
Environment Load (0.3ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 AND (environments.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Environment' AND taxonomy_id in (1) ) ) ORDER BY environments.name LIMIT 1
|
|
Architecture Load (0.3ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
|
|
Hostgroup Load (0.5ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 45 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) LIMIT 1
|
|
Organization Load (0.2ms) SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` = 1 LIMIT 1
|
|
User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 12 AND (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 LIMIT 1
|
|
Rendered hosts/_overview.html.erb (23.3ms)
|
|
TemplateKind Load (0.1ms) SELECT `template_kinds`.* FROM `template_kinds`
|
|
ConfigTemplate Load (0.5ms) 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.4ms) 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.4ms) 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.4ms) 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
|
|
ConfigTemplate Load (0.4ms) 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` = 'gPXE' AND `hostgroups`.`id` = 45 AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'gPXE' AND `hostgroups`.`id` = 45 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'gPXE' AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'gPXE' AND `os_default_templates`.`operatingsystem_id` = 7 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'provision' AND `hostgroups`.`id` = 45 AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'provision' AND `hostgroups`.`id` = 45 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'provision' AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.5ms) 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` = 'finish' AND `hostgroups`.`id` = 45 AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'finish' AND `hostgroups`.`id` = 45 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'finish' AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'finish' AND `os_default_templates`.`operatingsystem_id` = 7 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'script' AND `hostgroups`.`id` = 45 AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'script' AND `hostgroups`.`id` = 45 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'script' AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'script' AND `os_default_templates`.`operatingsystem_id` = 7 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'PXEGrub' AND `hostgroups`.`id` = 45 AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'PXEGrub' AND `hostgroups`.`id` = 45 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.4ms) 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` = 'PXEGrub' AND `environments`.`id` = 10 ORDER BY config_templates.name LIMIT 1
|
|
ConfigTemplate Load (0.5ms) 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` = 'PXEGrub' AND `os_default_templates`.`operatingsystem_id` = 7 ORDER BY config_templates.name LIMIT 1
|
|
TemplateKind Load (0.2ms) SELECT `template_kinds`.* FROM `template_kinds` WHERE `template_kinds`.`id` = 1 LIMIT 1
|
|
TemplateKind Load (0.1ms) SELECT `template_kinds`.* FROM `template_kinds` WHERE `template_kinds`.`id` = 3 LIMIT 1
|
|
CACHE (0.0ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 231 AND `nics`.`type` = 'Nic::BMC' LIMIT 1
|
|
Report Load (0.9ms) SELECT `reports`.* FROM `reports` WHERE `reports`.`host_id` = 231 AND (reported_at > '2013-07-28 09:15:15') ORDER BY reported_at
|
|
CACHE (0.0ms) SELECT `reports`.* FROM `reports` WHERE `reports`.`host_id` = 231 AND (reported_at > '2013-07-28 09:15:15') ORDER BY reported_at
|
|
Rendered hosts/show.html.erb within layouts/application (375.1ms)
|
|
Rendered home/_user_dropdown.html.erb (1.8ms)
|
|
Read fragment views/tabs_and_title_records-12 (0.1ms)
|
|
Rendered home/_topbar.html.erb (3.6ms)
|
|
Completed 200 OK in 430ms (Views: 371.0ms | ActiveRecord: 24.6ms)
|
|
|
|
|
|
Started POST "/fact_values/create" for IP_Net.16.190 at 2013-08-04 12:15:26 +0300
|
|
Processing by FactValuesController#create as */*
|
|
Parameters: {"facts"=>"[FILTERED]"}
|
|
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.4ms) 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.7ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`name` = 'hateya-cinder.qa.fqdn' LIMIT 1
|
|
FactValue Load (1.0ms) SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 214
|
|
FactName Load (0.9ms) SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` IN (36, 5365, 6, 27, 54, 46, 7, 62, 51, 9, 152, 64, 23, 40, 19, 3285, 48, 34, 31, 156, 61, 20, 157, 38, 57, 70, 52, 26, 66, 35, 65, 153, 55, 4, 32, 5608, 37, 56, 16, 3255, 45, 69, 47, 15, 33, 68, 2, 10, 42, 39, 24, 13, 17, 74, 49, 1663, 58, 1658, 3327, 89, 2101, 3328, 91, 3325, 92, 1654, 3324, 88, 1661, 90, 2102, 3, 50, 59, 155, 154, 30, 8, 18, 73, 12, 41, 14) ORDER BY LOWER(fact_names.name)
|
|
SQL (15.7ms) DELETE FROM `fact_values` WHERE `fact_values`.`id` IN (64692544, 64692542, 64692543)
|
|
(222.2ms) 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:15:26', `updated_at` = '2013-08-04 09:15:26' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 214
|
|
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:15:26 UTC +00:00], ["fact_name_id", 1655], ["host_id", 214], ["updated_at", Sun, 04 Aug 2013 09:15:26 UTC +00:00], ["value", "04-08-13 12:15"]]
|
|
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:15:26 UTC +00:00], ["fact_name_id", 29], ["host_id", 214], ["updated_at", Sun, 04 Aug 2013 09:15:26 UTC +00:00], ["value", "1217995"]]
|
|
SQL (1.4ms) INSERT INTO `fact_values` (`created_at`, `fact_name_id`, `host_id`, `updated_at`, `value`) VALUES (?, ?, ?, ?, ?) [["created_at", Sun, 04 Aug 2013 09:15:26 UTC +00:00], ["fact_name_id", 14], ["host_id", 214], ["updated_at", Sun, 04 Aug 2013 09:15:26 UTC +00:00], ["value", 2013-08-04 12:15:26 +0300]]
|
|
(4.9ms) COMMIT
|
|
Model Load (0.5ms) SELECT `models`.* FROM `models` WHERE `models`.`name` = 'RHEV Hypervisor' ORDER BY LOWER(models.name) LIMIT 1
|
|
Domain Load (0.3ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`name` = 'qa.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` = 'RHEV Hypervisor' 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.3ms) 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 486ms (Views: 0.8ms | ActiveRecord: 252.5ms)
|
|
|
|
|
|
Started GET "/node/hateya-cinder.qa.fqdn?format=yml" for IP_Net.16.190 at 2013-08-04 12:15:26 +0300
|
|
Processing by HostsController#externalNodes as YML
|
|
Parameters: {"name"=>"hateya-cinder.qa.fqdn"}
|
|
SmartProxy Load (0.6ms) 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.4ms) SELECT `users`.* FROM `users` WHERE `users`.`login` = 'admin' LIMIT 1
|
|
Setting current user thread-local variable to admin
|
|
Host::Managed Load (0.7ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`certname` = 'hateya-cinder.qa.fqdn' LIMIT 1
|
|
SmartProxy Load (0.3ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
|
|
Domain Load (0.3ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 4 ORDER BY domains.name LIMIT 1
|
|
Hostgroup Load (0.4ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 28 AND (1=1) LIMIT 1
|
|
Organization Load (0.3ms) 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.2ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 10 ORDER BY environments.name LIMIT 1
|
|
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 13 ORDER BY firstname LIMIT 1
|
|
CommonParameter Load (0.3ms) 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` = 4
|
|
Operatingsystem Load (0.3ms) 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.4ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (13, 28) AND (1=1)
|
|
GroupParameter Load (0.5ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('GroupParameter') AND `parameters`.`reference_id` IN (13, 28)
|
|
HostParameter Load (0.3ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 214
|
|
(0.2ms) SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 214
|
|
(0.3ms) SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IN (13, 28)
|
|
LookupKey Load (0.4ms) SELECT `lookup_keys`.* FROM `lookup_keys` WHERE `lookup_keys`.`puppetclass_id` IN (123, 112, 113, 119, 120, 124, 422) ORDER BY lookup_keys.key
|
|
CACHE (0.0ms) SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 214
|
|
CACHE (0.0ms) SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IN (13, 28)
|
|
SQL (1.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`.`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, 124, 422) AND `environment_classes`.`environment_id` = 10 ORDER BY lookup_keys.key
|
|
Puppetclass Load (0.4ms) SELECT `puppetclasses`.* FROM `puppetclasses` WHERE `puppetclasses`.`id` IN (123, 112, 113, 119, 120, 124, 422) ORDER BY puppetclasses.name
|
|
Rendered text template (0.0ms)
|
|
Completed 200 OK in 53ms (Views: 0.7ms | ActiveRecord: 8.5ms)
|
|
|
