Advertisement
treydock

Foreman - Failure adding BMC using web interface

Jan 17th, 2014
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.67 KB | None | 0 0
  1. Started PUT "/hosts/kvm1.DOMAIN" for DESKTOP_IP at 2014-01-17 13:54:57 -0600
  2. Processing by HostsController#update as */*
  3. Parameters: {"utf8"=>"✓", "authenticity_token"=>"cosPpMrQdqwv/GKFFmZej/eRyG5pg5tIGiP83ex8bQ0=", "host"=>{"name"=>"kvm1", "hostgroup_id"=>"20", "environment_id"=>"2", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "puppetclass_ids"=>[""], "managed"=>"1", "progress_report_id"=>"[FILTERED]", "mac"=>"00:15:17:93:a7:0c", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"192.168.202.102", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}, "new_1389988470260"=>{"_destroy"=>"false", "type"=>"Nic::BMC", "mac"=>"00:1e:c9:ac:0b:4c", "name"=>"kvm1-bmc", "domain_id"=>"1", "subnet_id"=>"2", "ip"=>"192.168.206.102", "username"=>"IPMI_USER", "password"=>"[FILTERED]", "provider"=>"IPMI"}}, "architecture_id"=>"1", "operatingsystem_id"=>"8", "provision_method"=>"build", "medium_id"=>"7", "ptable_id"=>"12", "disk"=>"", "IPMI_USER_pass"=>"[FILTERED]", "is_owned_by"=>"", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "id"=>"kvm1.DOMAIN"}
  4. User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
  5. Setting current user thread-local variable to treydock
  6. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'authorize_login_delegation' ORDER BY name LIMIT 1
  7. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'idle_timeout' ORDER BY name LIMIT 1
  8. Host::Base Load (0.4ms) SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`name` = 'kvm1.DOMAIN' LIMIT 1
  9. Setting current organization thread-local variable to none
  10. Setting current location thread-local variable to none
  11. (0.1ms) BEGIN
  12. Puppetclass Load (0.3ms) SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 66 ORDER BY puppetclasses.name
  13. Hostgroup Load (0.1ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 20 AND (1=1) LIMIT 1
  14. Environment Load (0.1ms) SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 2 ORDER BY environments.name LIMIT 1
  15. Domain Load (0.1ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  16. SmartProxy Load (0.1ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  17. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  18. Operatingsystem Load (0.1ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 8 ORDER BY operatingsystems.name LIMIT 1
  19. Architecture Load (0.1ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  20. Medium Load (0.1ms) SELECT `media`.* FROM `media` WHERE `media`.`id` = 7 ORDER BY media.name LIMIT 1
  21. Ptable Load (0.1ms) SELECT `ptables`.* FROM `ptables` WHERE `ptables`.`id` = 12 ORDER BY ptables.name LIMIT 1
  22. Subnet Load (0.1ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 ORDER BY vlanid LIMIT 1
  23. LookupValue Load (0.1ms) SELECT `lookup_values`.* FROM `lookup_values` WHERE `lookup_values`.`match` = 'fqdn=kvm1.DOMAIN'
  24. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
  25. Host::Base Exists (0.4ms) SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'kvm1.DOMAIN' AND `hosts`.`id` != 66) LIMIT 1
  26. Nic::Base Exists (0.1ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`mac` = BINARY '00:1e:c9:ac:0b:4c' LIMIT 1
  27. (0.4ms) SELECT mac FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`mac` = '00:1e:c9:ac:0b:4c' LIMIT 1
  28. (0.3ms) SELECT ip FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`ip` = '192.168.206.102' LIMIT 1
  29. (0.2ms) SELECT name FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND `hosts`.`name` = 'kvm1-bmc' LIMIT 1
  30. Nic::Interface Exists (0.1ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bootable') AND `nics`.`ip` = BINARY '192.168.206.102' LIMIT 1
  31. Subnet Load (0.1ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 2 ORDER BY vlanid LIMIT 1
  32. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  33. Nic::Managed Exists (0.1ms) SELECT 1 AS one FROM `nics` WHERE `nics`.`type` IN ('Nic::Managed', 'Nic::BMC', 'Nic::Bootable') AND (`nics`.`name` = BINARY 'kvm1-bmc' AND `nics`.`domain_id` = 1) LIMIT 1
  34. Scheduling new DHCP reservations for kvm1-bmc
  35. Using host queue
  36. CACHE (0.0ms) SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  37. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  38. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_certificate' ORDER BY name LIMIT 1
  39. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_ca_file' ORDER BY name LIMIT 1
  40. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_priv_key' ORDER BY name LIMIT 1
  41. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'query_local_nameservers' ORDER BY name LIMIT 1
  42. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  43. Scheduling new DNS entries
  44. Using host queue
  45. Using host queue
  46. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  47. Host::Managed Exists (0.7ms) SELECT 1 AS one FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND (`hosts`.`ip` = BINARY '192.168.202.102' AND `hosts`.`id` != 66) LIMIT 1
  48. Host::Managed Exists (0.4ms) SELECT 1 AS one FROM `hosts` WHERE `hosts`.`type` IN ('Host::Managed') AND (`hosts`.`mac` = BINARY '00:15:17:93:a7:0c' AND `hosts`.`id` != 66) LIMIT 1
  49. Hostgroup Load (0.1ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  50. CACHE (0.0ms) SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 1 ORDER BY vlanid LIMIT 1
  51. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  52. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  53. CACHE (0.0ms) SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 1 ORDER BY smart_proxies.name LIMIT 1
  54. 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 20 AND `environments`.`id` = 2 ORDER BY config_templates.name LIMIT 1
  55. 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 20 ORDER BY config_templates.name LIMIT 1
  56. 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `environments`.`id` = 2 ORDER BY config_templates.name LIMIT 1
  57. 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 8 ORDER BY config_templates.name LIMIT 1
  58. CACHE (0.0ms) SELECT `media`.* FROM `media` WHERE `media`.`id` = 7 ORDER BY media.name LIMIT 1
  59. CACHE (0.0ms) SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  60. CACHE (0.0ms) SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 8 ORDER BY operatingsystems.name LIMIT 1
  61. Setting Load (0.1ms) SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'manage_puppetca' ORDER BY name LIMIT 1
  62. Ptable Exists (0.1ms) SELECT 1 AS one FROM `ptables` INNER JOIN `operatingsystems_ptables` ON `ptables`.`id` = `operatingsystems_ptables`.`ptable_id` WHERE `operatingsystems_ptables`.`operatingsystem_id` = 8 AND `ptables`.`id` = 12 ORDER BY ptables.name LIMIT 1
  63. 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` = 8 AND `media`.`id` = 7 ORDER BY media.name LIMIT 1
  64. 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` = 8 AND `architectures`.`id` = 1 LIMIT 1
  65. Puppetclass Load (0.4ms) SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 66 ORDER BY puppetclasses.name
  66. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  67. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  68. Create DHCP reservation for kvm1-bmc-00:1e:c9:ac:0b:4c/192.168.206.102
  69. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  70. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  71. Add DNS A record for kvm1-bmc/192.168.206.102
  72. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  73. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  74. Add DNS PTR record for 192.168.206.102/kvm1-bmc
  75. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  76. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  77. Add the TFTP configuration for kvm1.DOMAIN
  78. CACHE (0.0ms) 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 20 AND `environments`.`id` = 2 ORDER BY config_templates.name LIMIT 1
  79. CACHE (0.0ms) 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `hostgroups`.`id` = 20 ORDER BY config_templates.name LIMIT 1
  80. CACHE (0.0ms) 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `environments`.`id` = 2 ORDER BY config_templates.name LIMIT 1
  81. CACHE (0.0ms) 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` = 8 AND `template_kinds`.`name` = 'PXELinux' AND `os_default_templates`.`operatingsystem_id` = 8 ORDER BY config_templates.name LIMIT 1
  82. Nic::Base Load (0.5ms) SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 66
  83. CommonParameter Load (0.1ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter') ORDER BY parameters.name
  84. DomainParameter Load (0.1ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('DomainParameter') AND `parameters`.`reference_id` = 1 ORDER BY parameters.name
  85. OsParameter Load (0.1ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('OsParameter') AND `parameters`.`reference_id` = 8 ORDER BY parameters.name
  86. Hostgroup Load (0.2ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5, 20) AND (1=1)
  87. GroupParameter Load (0.1ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('GroupParameter') AND `parameters`.`reference_id` IN (5, 20) ORDER BY parameters.name
  88. HostParameter Load (1.4ms) SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 66 ORDER BY parameters.name
  89. (0.2ms) SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 66
  90. (0.1ms) SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IN (5, 20)
  91. (0.1ms) SELECT DISTINCT puppetclass_id FROM `environment_classes` WHERE `environment_classes`.`environment_id` = 2 AND `environment_classes`.`puppetclass_id` IN (40, 22, 96, 104, 138, 170, 176, 185, 183, 133, 190, 197, 253, 266, 156, 144, 276, 277, 258, 140, 264)
  92. LookupKey Load (0.1ms) SELECT `lookup_keys`.* FROM `lookup_keys` WHERE `lookup_keys`.`puppetclass_id` IN (22, 40, 96, 104, 133, 138, 140, 144, 156, 170, 176, 183, 185, 190, 197, 253, 258, 264, 266, 276, 277) ORDER BY lookup_keys.key
  93. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  94. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  95. Fetching required TFTP boot files for kvm1.DOMAIN
  96. CACHE (0.0ms) SELECT 1 AS one FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 8 AND `media`.`id` = 7 ORDER BY media.name LIMIT 1
  97. CACHE (0.0ms) SELECT 1 AS one FROM `architectures` INNER JOIN `architectures_operatingsystems` ON `architectures`.`id` = `architectures_operatingsystems`.`architecture_id` WHERE `architectures_operatingsystems`.`operatingsystem_id` = 8 AND `architectures`.`id` = 1 LIMIT 1
  98. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  99. CACHE (0.0ms) SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (5) AND (1=1) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  100. (0.1ms) COMMIT
  101. Redirected to https://foreman.DOMAIN/hosts/kvm1.DOMAIN
  102. Setting current location thread-local variable to none
  103. Setting current organization thread-local variable to none
  104. Completed 302 Found in 1418ms (ActiveRecord: 9.6ms)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement