Started GET "/hosts" for 10.100.20.9 at 2013-11-05 09:47:19 -0500
Processing by HostsController#index as HTML
  User Load (0.2ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Setting current user thread-local variable to ocruilles
  Host::Managed Load (0.3ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') LIMIT 1
   (0.2ms)  SELECT COUNT(*) FROM `user_facts` WHERE `user_facts`.`user_id` = 2
  Host::Managed Load (0.2ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') ORDER BY `hosts`.`name` ASC LIMIT 20 OFFSET 0
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (3, 1) AND (1=1)
  Operatingsystem Load (0.2ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` IN (1) ORDER BY operatingsystems.name
  Environment Load (0.2ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` IN (1) ORDER BY environments.name
  Model Load (0.2ms)  SELECT `models`.* FROM `models` WHERE `models`.`id` IN (3) ORDER BY models.name
   (0.1ms)  SELECT MAX(`reports`.`id`) AS maximum_id, host_id AS host_id FROM `reports` WHERE `reports`.`host_id` IN (1, 3, 4, 2) GROUP BY host_id
  Rendered hosts/_list.html.erb (36.1ms)
  Rendered hosts/index.html.erb within layouts/application (41.5ms)
  Rendered home/_user_dropdown.html.erb (1.6ms)
Read fragment views/tabs_and_title_records-2 (0.2ms)
  Rendered home/_topbar.html.erb (2.4ms)
  Bookmark Load (0.2ms)  SELECT `bookmarks`.* FROM `bookmarks` WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id = 2 AND bookmarks.owner_type = 'User'))) AND (controller = 'hosts') ORDER BY name
  Rendered common/_searchbar.html.erb (6.4ms)
Completed 200 OK in 187ms (Views: 56.3ms | ActiveRecord: 1.9ms)


Started GET "/hosts/test-machine." for 10.100.20.9 at 2013-11-05 09:47:21 -0500
Processing by HostsController#show as HTML
  Parameters: {"id"=>"test-machine."}
  User Load (0.2ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Setting current user thread-local variable to ocruilles
  Host::Base Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`name` = 'test-machine.' LIMIT 1
  Report Load (0.5ms)  SELECT status FROM `reports` WHERE `reports`.`host_id` = 2 AND (reported_at > '2013-10-29 14:47:21') ORDER BY reported_at
  Operatingsystem Load (0.2ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY operatingsystems.name LIMIT 1
  SmartProxy Load (0.2ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
   (0.1ms)  SELECT COUNT(*) FROM `reports` WHERE `reports`.`host_id` = 2
  Nic::Base Load (0.2ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 2 AND `nics`.`type` = 'Nic::BMC' LIMIT 1
  FactValue Load (0.2ms)  SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 2
   (0.2ms)  SELECT COUNT(*) FROM `smart_proxies` INNER JOIN `features_smart_proxies` ON `features_smart_proxies`.`smart_proxy_id` = `smart_proxies`.`id` INNER JOIN `features` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features`.`name` = 'Puppet'
  Domain Load (0.1ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  Environment Load (0.2ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
  Architecture Load (0.2ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 1 AND (1=1) LIMIT 1
  User Load (0.2ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 ORDER BY firstname LIMIT 1
  Rendered hosts/_overview.html.erb (18.9ms)
  TemplateKind Load (0.2ms)  SELECT `template_kinds`.* FROM `template_kinds` 
  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` 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` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 1 AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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 `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
  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` 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` = 1 AND `template_kinds`.`name` = 'gPXE' AND `hostgroups`.`id` = 1 AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'gPXE' AND `hostgroups`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'gPXE' AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'gPXE' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  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` 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` = 1 AND `template_kinds`.`name` = 'provision' AND `hostgroups`.`id` = 1 AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'provision' AND `hostgroups`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'provision' AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'provision' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  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` 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` = 1 AND `template_kinds`.`name` = 'finish' AND `hostgroups`.`id` = 1 AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'finish' AND `hostgroups`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'finish' AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'finish' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  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` 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` = 1 AND `template_kinds`.`name` = 'script' AND `hostgroups`.`id` = 1 AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'script' AND `hostgroups`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'script' AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'script' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  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` 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` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `hostgroups`.`id` = 1 AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `hostgroups` ON `hostgroups`.`id` = `template_combinations`.`hostgroup_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `hostgroups`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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` INNER JOIN `environments` ON `environments`.`id` = `template_combinations`.`environment_id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `environments`.`id` = 1 ORDER BY config_templates.name LIMIT 1
  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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  TemplateKind Load (0.1ms)  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` = 2 AND `nics`.`type` = 'Nic::BMC' LIMIT 1
  Report Load (0.5ms)  SELECT `reports`.* FROM `reports` WHERE `reports`.`host_id` = 2 AND (reported_at > '2013-10-29 14:47:21') ORDER BY reported_at
  CACHE (0.0ms)  SELECT `reports`.* FROM `reports` WHERE `reports`.`host_id` = 2 AND (reported_at > '2013-10-29 14:47:21') ORDER BY reported_at
  Rendered hosts/show.html.erb within layouts/application (93.1ms)
  Rendered home/_user_dropdown.html.erb (1.8ms)
Read fragment views/tabs_and_title_records-2 (0.2ms)
  Rendered home/_topbar.html.erb (2.5ms)
Completed 200 OK in 111ms (Views: 94.7ms | ActiveRecord: 8.4ms)


Started DELETE "/hosts/test-machine." for 10.100.20.9 at 2013-11-05 09:47:27 -0500
Processing by HostsController#destroy as HTML
  Parameters: {"authenticity_token"=>"tpBIvqsWgcn2Kr6GW1DQtUFBcWASKD/daEtYnBb2dsY=", "id"=>"test-machine."}
  User Load (0.2ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
Setting current user thread-local variable to ocruilles
  Host::Base Load (0.2ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`name` = 'test-machine.' LIMIT 1
   (0.1ms)  BEGIN
  FactValue Load (0.2ms)  SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 2
  HostClass Load (0.1ms)  SELECT `host_classes`.* FROM `host_classes` WHERE `host_classes`.`host_id` = 2
  Report Load (0.2ms)  SELECT `reports`.* FROM `reports` WHERE `reports`.`host_id` = 2
  HostParameter Load (0.1ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 2 ORDER BY parameters.name
  CACHE (0.0ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 2 ORDER BY parameters.name
  Nic::Base Load (0.2ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 2
  Token Load (0.4ms)  SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`host_id` = 2 AND (expires >= '2013-11-05 14:47:27') LIMIT 1
  Domain Load (0.2ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  LookupValue Load (0.2ms)  SELECT `lookup_values`.* FROM `lookup_values` WHERE `lookup_values`.`match` = 'fqdn=test-machine.'
  Host::Managed Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 2 LIMIT 1
   (0.5ms)  SELECT MAX(`audits`.`version`) AS max_id FROM `audits` WHERE `audits`.`auditable_id` = 2 AND `audits`.`auditable_type` = 'Host'
  SQL (0.5ms)  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 ('destroy', NULL, NULL, NULL, 2, 'test-machine.', 'Host', '---\nname: test-machine.\nip: 10.20.30.145\nlast_freshcheck: \nsource_file_id: \nmac: \'01:02:03:04:05:06\'\nroot_pass: \nserial: \ndomain_id: 1\narchitecture_id: 1\noperatingsystem_id: 1\nenvironment_id: 1\nsubnet_id: 1\nptable_id: 9\nmedium_id: 6\nbuild: false\ncomment: \'\'\ndisk: \'\'\ninstalled_at: \nmodel_id: 3\nhostgroup_id: 1\nowner_id: 2\nowner_type: User\nenabled: true\npuppet_ca_proxy_id: 1\nmanaged: true\nuse_image: \nimage_file: \nuuid: \ncompute_resource_id: \npuppet_proxy_id: 1\ncertname: 7f93d42a-ab40-405e-9f7b-da8c58c1e362\nimage_id: \norganization_id: \nlocation_id: \n', NULL, '2013-11-05 14:47:27', '10.100.20.9', NULL, NULL, 'Olivier Cruilles', 20)
  Subnet Load (0.2ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 ORDER BY vlanid LIMIT 1
  SmartProxy Load (0.2ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  Operatingsystem Load (0.2ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY operatingsystems.name LIMIT 1
  CACHE (0.0ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  SQL (0.8ms)  DELETE FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`id` = 2
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 1 AND (1=1) LIMIT 1
Delete the TFTP configuration for test-machine.
Remove puppet certificate for test-machine.
Delete the autosign entry for test-machine.
Deactivating host test-machine. in Puppetdb
   (0.9ms)  ROLLBACK
Operation FAILED: Could not deactivate host: getaddrinfo: Name or service not known
/opt/rh/ruby193/root/usr/share/gems/gems/puppetdb_foreman-0.0.4/app/models/puppetdb_foreman/host_extensions.rb:31:in `rescue in deactivate_host'
/opt/rh/ruby193/root/usr/share/gems/gems/puppetdb_foreman-0.0.4/app/models/puppetdb_foreman/host_extensions.rb:10:in `deactivate_host'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:585:in `_run__3471322605920207561__destroy__2851787343718155717__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_destroy_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/callbacks.rb:254:in `destroy'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:236:in `block in destroy'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:295:in `block in with_transaction_returning_status'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in `transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:293:in `with_transaction_returning_status'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:236:in `destroy'
/usr/share/foreman/app/controllers/hosts_controller.rb:120:in `destroy'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/base.rb:167:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rendering.rb:10:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/callbacks.rb:18:in `block in process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:538:in `block (3 levels) in _run__1680718466691803921__process_action__3218522209745158754__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_4561'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:326:in `around'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:310:in `_callback_around_1167'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4561'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:526:in `block (2 levels) in _run__1680718466691803921__process_action__3218522209745158754__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_4560'
/usr/share/foreman/app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4560'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:415:in `block in _run__1680718466691803921__process_action__3218522209745158754__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_4559'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:326:in `around'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:310:in `_callback_around_13'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4559'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:414:in `_run__1680718466691803921__process_action__3218522209745158754__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/callbacks.rb:17:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rescue.rb:29:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `block in instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/base.rb:121:in `process'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/rendering.rb:45:in `process'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal.rb:203:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal.rb:246:in `block in action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:73:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:36:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:600:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/apipie-rails-0.0.23/lib/apipie/static_dispatcher.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/etag.rb:23:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/conditionalget.rb:35:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/head.rb:14:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/flash.rb:242:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/session/abstract/id.rb:205:in `context'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/session/abstract/id.rb:200:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/cookies.rb:339:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/query_cache.rb:64:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `_run__1701852009972681618__call__2851787343718155717__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/rack/logger.rb:26:in `call_app'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/rack/logger.rb:16:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/quiet_assets-1.0.2/lib/quiet_assets.rb:18:in `call_with_quiet_assets'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/request_id.rb:22:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/methodoverride.rb:21:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/runtime.rb:17:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/lock.rb:15:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/static.rb:62:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:143:in `pass'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:155:in `invalidate'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:71:in `call!'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/engine.rb:479:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/application.rb:223:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/railtie/configurable.rb:30:in `method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/builder.rb:134:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:64:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:49:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:49:in `call'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/rack/thread_handler_extension.rb:77:in `process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/request_handler/thread_handler.rb:140:in `accept_and_process_next_request'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/request_handler/thread_handler.rb:108:in `main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.5/lib/phusion_passenger/request_handler.rb:441:in `block (3 levels) in start_threads'
  Rendered common/500.html.erb within layouts/application (2.5ms)
Completed 500 Internal Server Error in 1399ms (Views: 4.2ms | ActiveRecord: 6.0ms)