Bug #11127

Host Build and Reboot shows template error when reboot fails

Added by Trey Dockendorf over 2 years ago. Updated 12 months ago.

Status:Closed
Priority:Normal
Assigned To:Timo Goebel
Category:Host creation
Target version:-
Difficulty:easy Bugzilla link:
Found in release:1.8.2 Pull request:https://github.com/theforeman/foreman/pull/4049
Story points-
Velocity based estimate-
Release1.14.0Release relationshipAuto

Description

I just discovered that when I tell a host to "Build" and check "Reboot now" I receive an exception [1]. If I click "Build" and do NOT check "Reboot now" I receive no error [2].

Based on the code for HostsController#setBuild I don't see why the "build" => "1" vs "build" => "0" would make a difference in terms of Rails wanting to load a view instead of redirecting.

This is Foreman 1.8.2 on CentOS 6.6

[1]:

Started PUT "/hosts/HOST.tamu.edu/setBuild?auth_object=HOST.tamu.edu&permission=build_hosts" for x.x.x.x at 2015-07-15 14:41:35 -0500
2015-07-15 14:41:35 [I] Processing by HostsController#setBuild as HTML
2015-07-15 14:41:36 [I]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"+1dr1xeuoe18bWOX5Q1jdkWRPO7MRE3NFKMO4+nZIlA=", "host"=>{"build"=>"1"}, "commit"=>"Reboot and build", "auth_object"=>"HOST.tamu.edu", "permission"=>"build_hosts", "id"=>"HOST.tamu.edu"}
2015-07-15 14:41:36 [D]   User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
2015-07-15 14:41:36 [D] Setting current user thread-local variable to treydock
2015-07-15 14:41:36 [D]    (3.8ms)  SELECT COUNT(*) FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization')
2015-07-15 14:41:36 [D] Setting current organization thread-local variable to none
2015-07-15 14:41:36 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location')
2015-07-15 14:41:36 [D] Setting current location thread-local variable to none
2015-07-15 14:41:36 [D]   AuthSource Load (0.1ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 2 LIMIT 1
2015-07-15 14:41:36 [D]    (0.1ms)  SELECT id FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') LIMIT 1
2015-07-15 14:41:36 [D]    (2.4ms)  SELECT id FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') LIMIT 1
2015-07-15 14:41:36 [D]   Host::Managed Load (0.1ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`name` = 'HOST.tamu.edu' LIMIT 1
2015-07-15 14:41:36 [D]    (1.7ms)  BEGIN
2015-07-15 14:41:36 [D]   Nic::Base Load (0.4ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 26 ORDER BY identifier
2015-07-15 14:41:36 [D]   Hostgroup Load (3.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 2 ORDER BY hostgroups.title LIMIT 1
2015-07-15 14:41:36 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (domain_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Hostgroup Load (3.4ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (compute_profile_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (operatingsystem_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (realm_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (medium_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (ptable_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (subnet_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:41:36 [D]   Subnet Load (3.0ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 12 ORDER BY vlanid LIMIT 1
2015-07-15 14:41:36 [D]   Operatingsystem Load (0.1ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]   Host::Base Exists (0.4ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'HOST.tamu.edu' AND `hosts`.`id` != 26) LIMIT 1
2015-07-15 14:41:36 [D]   HostParameter Load (3.6ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 26 ORDER BY parameters.name
2015-07-15 14:41:36 [D]   Domain Load (3.1ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
2015-07-15 14:41:36 [D]   SmartProxy Load (0.1ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
2015-07-15 14:41:36 [D] Queueing Realm
2015-07-15 14:41:36 [D]   Medium Load (3.0ms)  SELECT `media`.* FROM `media` WHERE `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:41:36 [D]   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` = 1 AND `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:41:36 [D]   Architecture Load (0.1ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:41:36 [D]   Architecture Exists (0.1ms)  SELECT 1 AS one FROM `architectures` INNER JOIN `architectures_operatingsystems` ON `architectures`.`id` = `architectures_operatingsystems`.`architecture_id` WHERE `architectures_operatingsystems`.`operatingsystem_id` = 1 AND `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:41:36 [D]   Environment Load (0.1ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
2015-07-15 14:41:36 [D]   Puppetclass Load (0.1ms)  SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 26 ORDER BY puppetclasses.name
2015-07-15 14:41:36 [D]   User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 3 ORDER BY firstname LIMIT 1
2015-07-15 14:41:36 [D]   Nic::Base Exists (0.2ms)  SELECT 1 AS one FROM `nics` WHERE (`nics`.`mac` = BINARY '00:25:90:70:e0:ec' AND `nics`.`id` != 48 AND `nics`.`virtual` = 0) LIMIT 1
2015-07-15 14:41:36 [D]   CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
2015-07-15 14:41:36 [D]   Location Load (0.1ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` = 1 ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]    (0.1ms)  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` = 'Subnet' AND (taxonomies.type='Location')
2015-07-15 14:41:36 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 1 AND (taxonomies.type='Location') ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]   Organization Load (0.1ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` = 4 ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]    (0.1ms)  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` = 'Subnet' AND (taxonomies.type='Organization')
2015-07-15 14:41:36 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 4 AND (taxonomies.type='Organization') ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]   Nic::Interface Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND (`nics`.`ip` = BINARY 'x.x.x.x' AND `nics`.`id` != 48) LIMIT 1
2015-07-15 14:41:36 [D]   Nic::Interface Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND (`nics`.`name` = BINARY 'HOST.tamu.edu' AND `nics`.`id` != 48 AND `nics`.`domain_id` = 1) LIMIT 1
2015-07-15 14:41:36 [D]   CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
2015-07-15 14:41:36 [D]   CACHE (0.0ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 12 ORDER BY vlanid LIMIT 1
2015-07-15 14:41:36 [D]   Nic::Base Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE (`nics`.`mac` = BINARY '00:25:90:70:e0:ed' AND `nics`.`id` != 81 AND `nics`.`virtual` = 0) LIMIT 1
2015-07-15 14:41:36 [D]   Subnet Load (0.1ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 7 ORDER BY vlanid LIMIT 1
2015-07-15 14:41:36 [D]   Setting Load (0.3ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'token_duration' ORDER BY name LIMIT 1
2015-07-15 14:41:36 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND (taxonomies.type='Location')
2015-07-15 14:41:36 [D]   Taxonomy Exists (0.2ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 1 AND (taxonomies.type='Location') ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND (taxonomies.type='Organization')
2015-07-15 14:41:36 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 4 AND (taxonomies.type='Organization') ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D]   Nic::Interface Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND (`nics`.`ip` = BINARY '10.0.30.44' AND `nics`.`id` != 81) LIMIT 1
2015-07-15 14:41:36 [D]   SmartProxy Load (0.1ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 3 ORDER BY smart_proxies.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   CACHE (0.0ms)  SELECT `media`.* FROM `media` WHERE `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:41:36 [D]   CACHE (0.0ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:41:36 [D]   CACHE (0.0ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY title LIMIT 1
2015-07-15 14:41:36 [D] Using host queue
2015-07-15 14:41:36 [D] Using host queue
2015-07-15 14:41:36 [D]   Token Load (0.4ms)  SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`host_id` = 26 LIMIT 1
2015-07-15 14:41:36 [D]   SQL (0.2ms)  DELETE FROM `fact_values` WHERE (host_id = 26)
2015-07-15 14:41:36 [D]   SQL (0.1ms)  DELETE FROM `reports` WHERE (host_id = 26)
2015-07-15 14:41:36 [I] Add the TFTP configuration for HOST.tamu.edu
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [D]   ConfigTemplate Load (0.1ms)  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` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:41:36 [I] Fetching required TFTP boot files for HOST.tamu.edu
2015-07-15 14:41:36 [D]   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` = 1 AND `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:41:36 [D]   Architecture Exists (0.1ms)  SELECT 1 AS one FROM `architectures` INNER JOIN `architectures_operatingsystems` ON `architectures`.`id` = `architectures_operatingsystems`.`architecture_id` WHERE `architectures_operatingsystems`.`operatingsystem_id` = 1 AND `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:41:37 [D]   Host::Managed Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 26 LIMIT 1
2015-07-15 14:41:37 [D]    (0.5ms)  SELECT MAX(`audits`.`version`) AS max_id FROM `audits` WHERE `audits`.`auditable_id` = 26 AND `audits`.`auditable_type` = 'Host'
2015-07-15 14:41:37 [D]   SQL (0.3ms)  INSERT INTO `audits` (`action`, `associated_id`, `associated_name`, `associated_type`, `auditable_id`, `auditable_name`, `auditable_type`, `audited_changes`, `comment`, `created_at`, `remote_address`, `user_id`, `user_type`, `username`, `version`) VALUES ('update', NULL, NULL, NULL, 26, 'HOST.tamu.edu', 'Host', '---\nbuild:\n- false\n- true\n', NULL, '2015-07-15 19:41:37', 'x.x.x.x', 2, NULL, 'Trey Dockendorf', 26)
2015-07-15 14:41:37 [D]    (0.3ms)  UPDATE `hosts` SET `build` = 1, `updated_at` = '2015-07-15 19:41:37' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 26
2015-07-15 14:41:37 [D]   SQL (0.1ms)  INSERT INTO `tokens` (`expires`, `host_id`, `value`) VALUES ('2015-07-16 07:41:36', 26, 'fc3a5536-8cec-489e-a4e9-dcfabf2d99dc')
2015-07-15 14:41:37 [D]    (143.8ms)  COMMIT
2015-07-15 14:41:37 [D] custom hook after_build on HOST.tamu.edu will be executed if defined.
2015-07-15 14:41:37 [D]   Nic::Base Load (0.1ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 26 AND `nics`.`type` = 'Nic::BMC' ORDER BY identifier LIMIT 1
2015-07-15 14:41:37 [D]   CACHE (0.0ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 26 AND `nics`.`type` = 'Nic::BMC' ORDER BY identifier LIMIT 1
2015-07-15 14:41:37 [D]   Subnet Load (0.1ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 9 ORDER BY vlanid LIMIT 1
2015-07-15 14:41:37 [D]   SmartProxy Load (0.1ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 3 ORDER BY smart_proxies.name LIMIT 1
2015-07-15 14:41:37 [D]   CACHE (0.0ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 3 ORDER BY smart_proxies.name LIMIT 1
2015-07-15 14:41:37 [D]   Feature Load (0.3ms)  SELECT `features`.* FROM `features` INNER JOIN `features_smart_proxies` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features_smart_proxies`.`smart_proxy_id` = 3
2015-07-15 14:41:37 [D]   CACHE (0.0ms)  SELECT `features`.* FROM `features` INNER JOIN `features_smart_proxies` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features_smart_proxies`.`smart_proxy_id` = 3
2015-07-15 14:41:37 [I] Completed 500 Internal Server Error in 1903ms
2015-07-15 14:41:37 [F]
ActionView::MissingTemplate (Missing template hosts/setBuild, application/setBuild with {:locale=>[:en], :formats=>[:html], :handlers=>[:erb, :builder, :rabl]}. Searched in:
  * "/usr/share/foreman/app/views" 
  * "/opt/rh/ruby193/root/usr/share/gems/gems/apipie-rails-0.2.6/app/views" 
):
  app/controllers/concerns/application_shared.rb:13:in `set_timezone'
  app/models/concerns/foreman/thread_session.rb:32:in `clear_thread'
  lib/middleware/catch_json_parse_errors.rb:9:in `call'

[2]:

Started PUT "/hosts/HOST.tamu.edu/setBuild?auth_object=HOST.tamu.edu&permission=build_hosts" for x.x.x.x at 2015-07-15 14:42:35 -0500
2015-07-15 14:42:35 [I] Processing by HostsController#setBuild as HTML
2015-07-15 14:42:35 [I]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"+1dr1xeuoe18bWOX5Q1jdkWRPO7MRE3NFKMO4+nZIlA=", "host"=>{"build"=>"0"}, "commit"=>"Build", "auth_object"=>"HOST.tamu.edu", "permission"=>"build_hosts", "id"=>"HOST.tamu.edu"}
2015-07-15 14:42:35 [D]   User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
2015-07-15 14:42:35 [D] Setting current user thread-local variable to treydock
2015-07-15 14:42:35 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization')
2015-07-15 14:42:35 [D] Setting current organization thread-local variable to none
2015-07-15 14:42:35 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location')
2015-07-15 14:42:35 [D] Setting current location thread-local variable to none
2015-07-15 14:42:35 [D]   AuthSource Load (0.1ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 2 LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  SELECT id FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  SELECT id FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') LIMIT 1
2015-07-15 14:42:35 [D]   Host::Managed Load (0.1ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`name` = 'HOST.tamu.edu' LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  BEGIN
2015-07-15 14:42:35 [D]   Nic::Base Load (0.1ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 26 ORDER BY identifier
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 2 ORDER BY hostgroups.title LIMIT 1
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (domain_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (compute_profile_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (operatingsystem_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (realm_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (medium_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (ptable_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Hostgroup Load (0.1ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (1) AND (subnet_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
2015-07-15 14:42:35 [D]   Subnet Load (0.1ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 12 ORDER BY vlanid LIMIT 1
2015-07-15 14:42:35 [D]   Operatingsystem Load (0.1ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]   Host::Base Exists (0.4ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'HOST.tamu.edu' AND `hosts`.`id` != 26) LIMIT 1
2015-07-15 14:42:35 [D]   HostParameter Load (0.1ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 26 ORDER BY parameters.name
2015-07-15 14:42:35 [D]   Domain Load (0.1ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
2015-07-15 14:42:35 [D]   SmartProxy Load (0.1ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
2015-07-15 14:42:35 [D] Queueing Realm
2015-07-15 14:42:35 [D]   Medium Load (0.2ms)  SELECT `media`.* FROM `media` WHERE `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:42:35 [D]   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` = 1 AND `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:42:35 [D]   Architecture Load (0.1ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:42:35 [D]   Architecture Exists (0.1ms)  SELECT 1 AS one FROM `architectures` INNER JOIN `architectures_operatingsystems` ON `architectures`.`id` = `architectures_operatingsystems`.`architecture_id` WHERE `architectures_operatingsystems`.`operatingsystem_id` = 1 AND `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:42:35 [D]   Environment Load (0.1ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
2015-07-15 14:42:35 [D]   Puppetclass Load (0.1ms)  SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 26 ORDER BY puppetclasses.name
2015-07-15 14:42:35 [D]   User Load (0.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 3 ORDER BY firstname LIMIT 1
2015-07-15 14:42:35 [D]   Nic::Base Exists (0.2ms)  SELECT 1 AS one FROM `nics` WHERE (`nics`.`mac` = BINARY '00:25:90:70:e0:ec' AND `nics`.`id` != 48 AND `nics`.`virtual` = 0) LIMIT 1
2015-07-15 14:42:35 [D]   CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
2015-07-15 14:42:35 [D]   Location Load (0.1ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` = 1 ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  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` = 'Subnet' AND (taxonomies.type='Location')
2015-07-15 14:42:35 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 1 AND (taxonomies.type='Location') ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]   Organization Load (0.1ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` = 4 ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  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` = 'Subnet' AND (taxonomies.type='Organization')
2015-07-15 14:42:35 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 12 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 4 AND (taxonomies.type='Organization') ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]   Nic::Interface Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND (`nics`.`ip` = BINARY 'x.x.x.x' AND `nics`.`id` != 48) LIMIT 1
2015-07-15 14:42:35 [D]   Nic::Interface Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND (`nics`.`name` = BINARY 'HOST.tamu.edu' AND `nics`.`id` != 48 AND `nics`.`domain_id` = 1) LIMIT 1
2015-07-15 14:42:35 [D]   CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
2015-07-15 14:42:35 [D]   CACHE (0.0ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 12 ORDER BY vlanid LIMIT 1
2015-07-15 14:42:35 [D]   Nic::Base Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE (`nics`.`mac` = BINARY '00:25:90:70:e0:ed' AND `nics`.`id` != 81 AND `nics`.`virtual` = 0) LIMIT 1
2015-07-15 14:42:35 [D]   Subnet Load (0.1ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 7 ORDER BY vlanid LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND (taxonomies.type='Location')
2015-07-15 14:42:35 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 1 AND (taxonomies.type='Location') ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]    (0.1ms)  SELECT COUNT(*) FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND (taxonomies.type='Organization')
2015-07-15 14:42:35 [D]   Taxonomy Exists (0.1ms)  SELECT 1 AS one FROM `taxonomies` INNER JOIN `taxable_taxonomies` ON `taxonomies`.`id` = `taxable_taxonomies`.`taxonomy_id` WHERE `taxable_taxonomies`.`taxable_id` = 7 AND `taxable_taxonomies`.`taxable_type` = 'Subnet' AND `taxonomies`.`id` = 4 AND (taxonomies.type='Organization') ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D]   Nic::Interface Exists (0.1ms)  SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND (`nics`.`ip` = BINARY '10.0.30.44' AND `nics`.`id` != 81) LIMIT 1
2015-07-15 14:42:35 [D]   SmartProxy Load (0.1ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 3 ORDER BY smart_proxies.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   CACHE (0.0ms)  SELECT `media`.* FROM `media` WHERE `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:42:35 [D]   CACHE (0.0ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:42:35 [D]   CACHE (0.0ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY title LIMIT 1
2015-07-15 14:42:35 [D] Using host queue
2015-07-15 14:42:35 [D] Using host queue
2015-07-15 14:42:35 [D]   Token Load (0.4ms)  SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`host_id` = 26 LIMIT 1
2015-07-15 14:42:35 [D]   SQL (0.1ms)  DELETE FROM `fact_values` WHERE (host_id = 26)
2015-07-15 14:42:35 [D]   SQL (0.1ms)  DELETE FROM `reports` WHERE (host_id = 26)
2015-07-15 14:42:35 [I] Add the TFTP configuration for HOST.tamu.edu
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.2ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 2 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [D]   ConfigTemplate Load (0.1ms)  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` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
2015-07-15 14:42:35 [I] Fetching required TFTP boot files for HOST.tamu.edu
2015-07-15 14:42:35 [D]   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` = 1 AND `media`.`id` = 6 ORDER BY media.name LIMIT 1
2015-07-15 14:42:35 [D]   Architecture Exists (0.1ms)  SELECT 1 AS one FROM `architectures` INNER JOIN `architectures_operatingsystems` ON `architectures`.`id` = `architectures_operatingsystems`.`architecture_id` WHERE `architectures_operatingsystems`.`operatingsystem_id` = 1 AND `architectures`.`id` = 2 LIMIT 1
2015-07-15 14:42:36 [D]   Host::Managed Load (0.4ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 26 LIMIT 1
2015-07-15 14:42:36 [D]    (0.5ms)  SELECT MAX(`audits`.`version`) AS max_id FROM `audits` WHERE `audits`.`auditable_id` = 26 AND `audits`.`auditable_type` = 'Host'
2015-07-15 14:42:36 [D]   SQL (37.2ms)  INSERT INTO `audits` (`action`, `associated_id`, `associated_name`, `associated_type`, `auditable_id`, `auditable_name`, `auditable_type`, `audited_changes`, `comment`, `created_at`, `remote_address`, `user_id`, `user_type`, `username`, `version`) VALUES ('update', NULL, NULL, NULL, 26, 'HOST.tamu.edu', 'Host', '---\nbuild:\n- false\n- true\n', NULL, '2015-07-15 19:42:36', 'x.x.x.x', 2, NULL, 'Trey Dockendorf', 28)
2015-07-15 14:42:36 [D]    (0.4ms)  UPDATE `hosts` SET `build` = 1, `updated_at` = '2015-07-15 19:42:36' WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 26
2015-07-15 14:42:36 [D]   SQL (0.2ms)  INSERT INTO `tokens` (`expires`, `host_id`, `value`) VALUES ('2015-07-16 07:42:35', 26, '0bd9230d-a3dc-4898-a506-0f4ed31e7528')
2015-07-15 14:42:36 [D]    (6.0ms)  COMMIT
2015-07-15 14:42:36 [D] custom hook after_build on HOST.tamu.edu will be executed if defined.
2015-07-15 14:42:36 [I] Redirected to https://dc-foreman-web.tamu.edu/hosts/HOST.tamu.edu
2015-07-15 14:42:36 [I] Completed 302 Found in 717ms (ActiveRecord: 52.7ms)

Related issues

Related to Foreman - Feature #746: Generate all the Host template when click on Build to avo... Closed 03/15/2011
Related to Foreman - Bug #17476: bmc power actions should return true when result is ok Closed 11/24/2016

Associated revisions

Revision 6695a556
Added by Timo Goebel 12 months ago

fixes #11127 - show error when rebuild reboot fails

Revision 79833adf
Added by Timo Goebel 12 months ago

fixes #11127 - show error when rebuild reboot fails

(cherry picked from commit 6695a5563dc244522c7eb2135b8ab827f1d80411)

History

#1 Updated by Dominic Cleal over 2 years ago

  • Related to Feature #746: Generate all the Host template when click on Build to avoid errors during installation added

#2 Updated by Dominic Cleal over 2 years ago

Looks like a logic error in setBuild when the reboot (power manager reset) returns false rather than throwing an exception:

https://github.com/theforeman/foreman/blob/1.8.2/app/controllers/hosts_controller.rb#L205

No process_success/error method will get called and Rails will do its default thing of trying to render a page called setBuild, and there isn't one. There should be an else for when the power reset returns false.

Quite what false means or what you can do about it will depend a lot on the type of host and power management employed - VMs will differ based on the compute resource for instance.

#3 Updated by Dominic Cleal over 2 years ago

  • Difficulty set to easy

#4 Updated by Dominic Cleal over 2 years ago

  • Subject changed from Host Build and Reboot fails but Build works to Host Build and Reboot shows template error when reboot fails
  • Category changed from Web Interface to Host creation

#5 Updated by Alex Fisher about 1 year ago

I've just hit this with an HP server with BMC configured. BMC otherwise seems to work (status returns correctly, I can turn the server on/off etc), so I'm not sure why power reset is returning false.

#6 Updated by Alex Fisher about 1 year ago

Not sure if it's relevant, but on these HP servers, if I'm also hitting http://projects.theforeman.org/issues/3073

Is there a reason foreman tries a graceful reboot instead of a reset when building hosts?

#7 Updated by The Foreman Bot 12 months ago

  • Status changed from New to Ready For Testing
  • Assigned To set to Timo Goebel
  • Pull request https://github.com/theforeman/foreman/pull/4049 added

#8 Updated by Timo Goebel 12 months ago

  • Related to Bug #17476: bmc power actions should return true when result is ok added

#9 Updated by Timo Goebel 12 months ago

Alex Fisher wrote:

Is there a reason foreman tries a graceful reboot instead of a reset when building hosts?

Foreman actually does a "power cycle", which is defined as "pulling the plug", waiting, "connection to power" again.

#10 Updated by Timo Goebel 12 months ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#11 Updated by Dominic Cleal 12 months ago

  • Release set to 1.14.0

Also available in: Atom PDF