Started POST "/hosts" for 192.168.88.1 at 2013-06-22 08:10:58 -0700 Processing by HostsController#create as */* Parameters: {"utf8"=>"✓", "authenticity_token"=>"Z8ETmbQWgWSScV0NbOaSdsWcs8extPAsyZ9/DvLgMcA=", "host"=>{"name"=>"test12", "compute_resource_id"=>"1", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "compute_attributes"=>{"cpus"=>"1", "memory_mb"=>"768", "cluster"=>"thuis", "path"=>"/Datacenters/CJIB/vm", "interfaces_attributes"=>{"new_interfaces"=>{"network"=>"VM Network", "_delete"=>""}, "0"=>{"network"=>"VM Network", "_delete"=>""}}, "volumes_attributes"=>{"new_volumes"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}, "0"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"5", "_delete"=>""}}, "start"=>"1"}, "mac"=>"", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"192.168.88.1", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI", "updated_at"=>"2013-06-22 08:10:12 -0700"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "provision_method"=>"build", "build"=>"1", "medium_id"=>"1", "ptable_id"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "capabilities"=>"build"} User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin  (0.3ms) BEGIN Subnet Load (0.6ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 1 ORDER BY vlanid LIMIT 1 Domain Load (0.5ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1 Setting Load (0.4ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1 Host::Base Exists (0.5ms) SELECT 1 AS one FROM "hosts" WHERE "hosts"."name" = 'test12.localdomain' LIMIT 1 SmartProxy Load (0.4ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 ComputeResource Load (0.4ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY compute_resources.name LIMIT 1 Host::Managed Exists (0.6ms) SELECT 1 AS one FROM "hosts" WHERE "hosts"."ip" = '192.168.88.1' LIMIT 1 Scheduling new DHCP reservations for test12.localdomain CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 Scheduling new DNS entries CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 Operatingsystem Load (0.5ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1 ConfigTemplate Load (1.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.8ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "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 CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 Setting Load (0.4ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'manage_puppetca' ORDER BY name LIMIT 1 Ptable Load (0.5ms) SELECT "ptables".* FROM "ptables" WHERE "ptables"."id" = 1 ORDER BY LOWER(ptables.name) LIMIT 1 Ptable Exists (0.4ms) SELECT 1 AS one FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 AND "ptables"."id" = 1 ORDER BY LOWER(ptables.name) LIMIT 1 Medium Load (0.3ms) SELECT "media".* FROM "media" WHERE "media"."id" = 1 ORDER BY media.name LIMIT 1 Medium Exists (0.3ms) 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" = 1 ORDER BY media.name LIMIT 1 Architecture Load (0.4ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1 Architecture Exists (0.3ms) 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" = 1 LIMIT 1 Environment Load (0.3ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1 Puppetclass Load (0.6ms) SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" IS NULL ORDER BY puppetclasses.name Setting Load (0.3ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'token_duration' ORDER BY name LIMIT 1 Adding Compute instance for test12.localdomain ComputeResource Exists (0.5ms) SELECT 1 AS one FROM "compute_resources" WHERE ("compute_resources"."name" = 'vmware' AND "compute_resources"."id" != 1) LIMIT 1 Failed to create a compute vmware (VMWare) instance test12.localdomain: failed to create vm: undefined method `resourcePool' for nil:NilClass /opt/rh/ruby193/root/usr/share/gems/gems/fog-1.11.1/lib/fog/vsphere/requests/compute/create_vm.rb:26:in `rescue in create_vm' /opt/rh/ruby193/root/usr/share/gems/gems/fog-1.11.1/lib/fog/vsphere/requests/compute/create_vm.rb:8:in `create_vm' /opt/rh/ruby193/root/usr/share/gems/gems/fog-1.11.1/lib/fog/vsphere/models/compute/server.rb:207:in `save' /usr/share/foreman/lib/foreman/model/vmware.rb:92:in `create_vm' /usr/share/foreman/app/models/orchestration/compute.rb:59:in `setCompute' /usr/share/foreman/app/models/orchestration.rb:151:in `execute' /usr/share/foreman/app/models/orchestration.rb:91:in `block in process' /usr/share/foreman/app/models/orchestration.rb:83:in `each' /usr/share/foreman/app/models/orchestration.rb:83:in `process' /usr/share/foreman/app/models/orchestration.rb:21:in `on_save' /opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:627:in `_run__324303455218144847__save__3085135076815516901__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_save_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:264:in `create_or_update' /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/persistence.rb:84:in `save' /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/validations.rb:50:in `save' /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/attribute_methods/dirty.rb:22:in `save' /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:241:in `block (2 levels) in save' /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:241:in `block in save' /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:252:in `rollback_active_record_state!' /opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:240:in `save' /usr/share/foreman/lib/foreman/sti.rb:26:in `save_with_type' /usr/share/foreman/app/controllers/hosts_controller.rb:87:in `create' /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:527:in `block (3 levels) in _run__160929817254214717__process_action__656274136512620496__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_4557' /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_917' /opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_4557' /opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:526:in `block (2 levels) in _run__160929817254214717__process_action__656274136512620496__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_4556' /usr/share/foreman/lib/foreman/thread_session.rb:31: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_4556' /opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:415:in `block in _run__160929817254214717__process_action__656274136512620496__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_4555' /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_4555' /opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:414:in `_run__160929817254214717__process_action__656274136512620496__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.18/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__2193194788677854240__call__3085135076815516901__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/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' Rolling back due to a problem: [Settings up compute instance test12.localdomain 1 failed [#, :setCompute]]  (0.4ms) ROLLBACK Organization Load (0.4ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" IS NULL LIMIT 1 Location Load (0.3ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" IS NULL LIMIT 1 Failed to save: Failed to create a compute vmware (VMWare) instance test12.localdomain: failed to create vm: undefined method `resourcePool' for nil:NilClass Rendered hosts/_progress.erb (0.4ms) Setting current organization thread-local variable to none Setting current location thread-local variable to none  (0.6ms) 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' ComputeResource Load (0.4ms) SELECT "compute_resources".* FROM "compute_resources" ORDER BY type, name  (0.4ms) SELECT COUNT(*) FROM "hostgroups" INNER JOIN "user_hostgroups" ON "hostgroups"."id" = "user_hostgroups"."hostgroup_id" WHERE "user_hostgroups"."user_id" = 1 AND (1=1) Hostgroup Load (0.2ms) SELECT "hostgroups".* FROM "hostgroups" WHERE (1=1) Environment Load (0.2ms) SELECT "environments".* FROM "environments" ORDER BY environments.name  (0.4ms) SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet CA' SmartProxy Load (0.3ms) SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet CA' ORDER BY smart_proxies.name CACHE (0.0ms) SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet' SmartProxy Load (0.4ms) SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" = 'Puppet' ORDER BY smart_proxies.name Rendered puppetclasses/_selectedClasses.html.erb (0.0ms) Puppetclass Load (0.7ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 ORDER BY puppetclasses.name Rendered puppetclasses/_classes.html.erb (4.7ms) Rendered puppetclasses/_class_selection.html.erb (9.8ms) CACHE (0.0ms) SELECT 1 AS one FROM "compute_resources" WHERE ("compute_resources"."name" = 'vmware' AND "compute_resources"."id" != 1) LIMIT 1 Rendered compute_resources_vms/form/vmware/_network.html.erb (44.5ms) Rendered compute_resources_vms/form/vmware/_network.html.erb (119.2ms) Rendered compute_resources_vms/form/vmware/_volume.html.erb (39.2ms) Rendered compute_resources_vms/form/vmware/_volume.html.erb (34.3ms) Rendered compute_resources_vms/form/_vmware.html.erb (450.3ms) Rendered hosts/_compute.html.erb (475.6ms) Domain Load (0.4ms) SELECT "domains".* FROM "domains" INNER JOIN "user_domains" ON "domains"."id" = "user_domains"."domain_id" WHERE "user_domains"."user_id" = 1 ORDER BY domains.name Domain Load (0.3ms) SELECT "domains".* FROM "domains" ORDER BY domains.name  (0.9ms) SELECT COUNT(*) FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 CACHE (0.0ms) SELECT COUNT(*) FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 Subnet Load (1.1ms) SELECT "subnets".* FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 ORDER BY vlanid Rendered common/_domain.html.erb (11.7ms) Started GET "/tasks/f84d927d-4889-4e4d-aea4-20c8ed8e4cf2" for 192.168.88.1 at 2013-06-22 08:10:59 -0700 Processing by TasksController#show as */* Parameters: {"id"=>"f84d927d-4889-4e4d-aea4-20c8ed8e4cf2"} User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin Rendered tasks/_list.html.erb (0.8ms) Completed 200 OK in 6ms (Views: 2.2ms | ActiveRecord: 0.3ms) CACHE (0.0ms) SELECT "domains".* FROM "domains" ORDER BY domains.name CACHE (0.0ms) SELECT "domains".* FROM "domains" ORDER BY domains.name CACHE (0.0ms) SELECT "domains".* FROM "domains" ORDER BY domains.name Rendered hosts/_interfaces.html.erb (88.5ms) Architecture Load (0.4ms) SELECT "architectures".* FROM "architectures" Operatingsystem Load (0.6ms) SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN "architectures_operatingsystems" ON "operatingsystems"."id" = "architectures_operatingsystems"."operatingsystem_id" WHERE "architectures_operatingsystems"."architecture_id" = 1 ORDER BY LOWER(operatingsystems.name) Rendered common/os_selection/_architecture.html.erb (5.1ms) Medium Load (0.5ms) SELECT "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 ORDER BY media.name Ptable Load (0.4ms) SELECT "ptables".* FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 ORDER BY LOWER(ptables.name) Rendered common/os_selection/_operatingsystem.html.erb (6.5ms) Rendered hosts/_operating_system.html.erb (25.2ms) Rendered hosts/_unattended.html.erb (698.7ms)  (0.5ms) SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) GROUP BY puppetclass_id  (0.3ms) SELECT COUNT(*) AS count_all, environment_classes.puppetclass_id AS environment_classes_puppetclass_id FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "environment_classes"."puppetclass_id" IN (NULL) GROUP BY environment_classes.puppetclass_id Rendered puppetclasses/_class_parameters.html.erb (0.0ms) Rendered puppetclasses/_classes_parameters.html.erb (7.5ms) CommonParameter Load (0.3ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') DomainParameter Load (0.3ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 1 OsParameter Load (0.3ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 1 Rendered common_parameters/_inherited_parameters.erb (0.8ms) Rendered common_parameters/_puppetclass_parameter.erb (2.8ms) Rendered common_parameters/_puppetclasses_parameters.erb (10.2ms) Rendered common_parameters/_parameter.erb (1.9ms) Rendered common_parameters/_parameters.erb (21.4ms) User Load (0.5ms) SELECT "users".* FROM "users" ORDER BY firstname Usergroup Load (0.4ms) SELECT "usergroups".* FROM "usergroups" ORDER BY LOWER(usergroups.name) Setting current location thread-local variable to none Setting current organization thread-local variable to none Rendered hosts/_form.html.erb (790.6ms) Rendered hosts/new.html.erb within layouts/application (791.7ms) Rendered home/_user_dropdown.html.erb (1.7ms) Read fragment views/tabs_and_title_records-1 (0.1ms) Rendered home/_topbar.html.erb (2.0ms) Completed 200 OK in 1686ms (Views: 783.3ms | ActiveRecord: 40.0ms) Started GET "/tasks/f84d927d-4889-4e4d-aea4-20c8ed8e4cf2" for 192.168.88.1 at 2013-06-22 08:11:01 -0700 Processing by TasksController#show as */* Parameters: {"id"=>"f84d927d-4889-4e4d-aea4-20c8ed8e4cf2"} User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin Rendered tasks/_list.html.erb (0.8ms) Completed 200 OK in 10ms (Views: 2.9ms | ActiveRecord: 0.7ms) Started POST "/hosts" for 192.168.88.1 at 2013-06-22 08:11:05 -0700 Processing by HostsController#create as */* Parameters: {"utf8"=>"✓", "authenticity_token"=>"Z8ETmbQWgWSScV0NbOaSdsWcs8extPAsyZ9/DvLgMcA=", "host"=>{"name"=>"test12", "compute_resource_id"=>"1", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "compute_attributes"=>{"cpus"=>"1", "memory_mb"=>"768", "cluster"=>"thuis", "path"=>"/Datacenters/CJIB/vm", "interfaces_attributes"=>{"new_interfaces"=>{"network"=>"VM Network", "_delete"=>""}, "0"=>{"network"=>"VM Network", "_delete"=>""}}, "volumes_attributes"=>{"new_volumes"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}, "0"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"5", "_delete"=>""}}, "start"=>"1"}, "mac"=>"", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"192.168.88.1", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "provider"=>"IPMI", "updated_at"=>"2013-06-22 08:10:59 -0700"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "provision_method"=>"build", "build"=>"1", "medium_id"=>"1", "ptable_id"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"1-Users", "enabled"=>"1", "comment"=>"", "overwrite"=>"false"}, "capabilities"=>"build"} User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1 [["id", 1]]  (0.1ms) BEGIN Subnet Load (0.3ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 1 ORDER BY vlanid LIMIT 1 Domain Load (0.2ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1 Host::Base Exists (0.2ms) SELECT 1 AS one FROM "hosts" WHERE "hosts"."name" = 'test12.localdomain' LIMIT 1 SmartProxy Load (0.2ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 ComputeResource Load (0.4ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY compute_resources.name LIMIT 1 Host::Managed Exists (0.3ms) SELECT 1 AS one FROM "hosts" WHERE "hosts"."ip" = '192.168.88.1' LIMIT 1 Scheduling new DHCP reservations for test12.localdomain CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 Scheduling new DNS entries CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 Operatingsystem Load (0.4ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1 ConfigTemplate Load (1.3ms) 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.8ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "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 CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1 Ptable Load (0.3ms) SELECT "ptables".* FROM "ptables" WHERE "ptables"."id" = 1 ORDER BY LOWER(ptables.name) LIMIT 1 Ptable Exists (0.3ms) SELECT 1 AS one FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 AND "ptables"."id" = 1 ORDER BY LOWER(ptables.name) LIMIT 1 Medium Load (0.3ms) SELECT "media".* FROM "media" WHERE "media"."id" = 1 ORDER BY media.name LIMIT 1 Medium Exists (0.4ms) 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" = 1 ORDER BY media.name LIMIT 1 Architecture Load (0.2ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1 Architecture Exists (0.8ms) 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" = 1 LIMIT 1 Environment Load (0.3ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1 Puppetclass Load (0.3ms) SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" IS NULL ORDER BY puppetclasses.name Adding Compute instance for test12.localdomain ComputeResource Exists (0.4ms) SELECT 1 AS one FROM "compute_resources" WHERE ("compute_resources"."name" = 'vmware' AND "compute_resources"."id" != 1) LIMIT 1 Started GET "/tasks/f84d927d-4889-4e4d-aea4-20c8ed8e4cf2" for 192.168.88.1 at 2013-06-22 08:11:07 -0700 Processing by TasksController#show as */* Parameters: {"id"=>"f84d927d-4889-4e4d-aea4-20c8ed8e4cf2"} User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin Rendered tasks/_list.html.erb (0.5ms) Completed 200 OK in 5ms (Views: 1.3ms | ActiveRecord: 0.5ms) Host::Managed Load (0.7ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."uuid" = '503d8b2a-8e97-ec29-faf8-fb49135dc230' LIMIT 1 Host::Managed Load (0.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."mac" = '00:50:56:bd:1c:e6' LIMIT 1 Create DHCP reservation for test12.localdomain-00:50:56:bd:1c:e6/192.168.88.1 Add DNS PTR record for 192.168.88.1/test12.localdomain Add the TFTP configuration for test12.localdomain 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" = 1 AND "template_kinds"."name" = 'PXELinux' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1 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" = 1 AND "template_kinds"."name" = 'PXELinux' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1 Setting Load (0.6ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'safemode_render' ORDER BY name LIMIT 1 Setting Load (0.5ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'foreman_url' ORDER BY name LIMIT 1 Fetching required TFTP boot files for test12.localdomain 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" = 1 AND "media"."id" = 1 ORDER BY media.name LIMIT 1 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" = 1 AND "architectures"."id" = 1 LIMIT 1 Powering up Compute instance for test12.localdomain Started GET "/tasks/f84d927d-4889-4e4d-aea4-20c8ed8e4cf2" for 192.168.88.1 at 2013-06-22 08:11:08 -0700 Processing by TasksController#show as */* Parameters: {"id"=>"f84d927d-4889-4e4d-aea4-20c8ed8e4cf2"} User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin Rendered tasks/_list.html.erb (0.5ms) Completed 200 OK in 3ms (Views: 0.8ms | ActiveRecord: 0.3ms) SQL (1.1ms) INSERT INTO "hosts" ("architecture_id", "build", "certname", "comment", "compute_resource_id", "created_at", "disk", "domain_id", "enabled", "environment", "environment_id", "hostgroup_id", "image_file", "image_id", "installed_at", "ip", "last_compile", "last_freshcheck", "last_report", "location_id", "mac", "managed", "medium_id", "model_id", "name", "operatingsystem_id", "organization_id", "owner_id", "owner_type", "ptable_id", "puppet_ca_proxy_id", "puppet_proxy_id", "puppet_status", "root_pass", "serial", "source_file_id", "subnet_id", "type", "updated_at", "use_image", "uuid") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41) RETURNING "id" [["architecture_id", 1], ["build", true], ["certname", nil], ["comment", ""], ["compute_resource_id", 1], ["created_at", Sat, 22 Jun 2013 15:11:10 UTC +00:00], ["disk", ""], ["domain_id", 1], ["enabled", true], ["environment", nil], ["environment_id", 1], ["hostgroup_id", nil], ["image_file", nil], ["image_id", nil], ["installed_at", nil], ["ip", "192.168.88.1"], ["last_compile", nil], ["last_freshcheck", nil], ["last_report", nil], ["location_id", nil], ["mac", "00:50:56:bd:1c:e6"], ["managed", true], ["medium_id", 1], ["model_id", nil], ["name", "test12.localdomain"], ["operatingsystem_id", 1], ["organization_id", nil], ["owner_id", 1], ["owner_type", "User"], ["ptable_id", 1], ["puppet_ca_proxy_id", 1], ["puppet_proxy_id", 1], ["puppet_status", 0], ["root_pass", nil], ["serial", nil], ["source_file_id", nil], ["subnet_id", 1], ["type", "Host::Managed"], ["updated_at", Sat, 22 Jun 2013 15:11:10 UTC +00:00], ["use_image", nil], ["uuid", "503d8b2a-8e97-ec29-faf8-fb49135dc230"]] Host::Managed Load (0.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = 2 LIMIT 1  (0.7ms) SELECT MAX("audits"."version") AS max_id FROM "audits" WHERE "audits"."auditable_id" = 2 AND "audits"."auditable_type" = 'Host' SQL (1.0ms) 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 ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING "id" [["action", "create"], ["associated_id", nil], ["associated_name", nil], ["associated_type", nil], ["auditable_id", 2], ["auditable_name", "test12.localdomain"], ["auditable_type", "Host"], ["audited_changes", "--- \n name: test12.localdomain\n ip: \"192.168.88.1\"\n environment: \n last_freshcheck: \n source_file_id: \n mac: \"00:50:56:bd:1c:e6\"\n root_pass: \n serial: \n domain_id: 1\n architecture_id: 1\n operatingsystem_id: 1\n environment_id: 1\n subnet_id: 1\n ptable_id: 1\n medium_id: 1\n build: true\n comment: \"\"\n disk: \"\"\n installed_at: \n model_id: \n hostgroup_id: \n owner_id: 1\n owner_type: User\n enabled: true\n puppet_ca_proxy_id: 1\n managed: true\n use_image: \n image_file: \n uuid: \"503d8b2a-8e97-ec29-faf8-fb49135dc230\"\n compute_resource_id: 1\n puppet_proxy_id: 1\n certname: \n image_id: \n organization_id: \n location_id: "], ["comment", nil], ["created_at", Sat, 22 Jun 2013 15:11:10 UTC +00:00], ["remote_address", "192.168.88.1"], ["user_id", nil], ["user_type", nil], ["username", "Admin User"], ["version", 1]]  (0.8ms) COMMIT Completed 200 OK in 4453ms (Views: 0.2ms | ActiveRecord: 17.5ms) Started GET "/hosts/test12.localdomain" for 192.168.88.1 at 2013-06-22 08:11:10 -0700 Processing by HostsController#show as HTML Parameters: {"id"=>"test12.localdomain"} User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 1]] Setting current user thread-local variable to admin Host::Base Load (0.5ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'test12.localdomain' LIMIT 1 Report Load (1.0ms) SELECT status FROM "reports" WHERE "reports"."host_id" = 2 AND (reported_at > '2013-06-15 15:11:10.183551') ORDER BY reported_at Operatingsystem Load (0.5ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1 ComputeResource Load (0.6ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY compute_resources.name LIMIT 1 SmartProxy Load (0.5ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1  (0.4ms) SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" = 2 Nic::Base Load (0.6ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 2 AND "nics"."type" = 'Nic::BMC' LIMIT 1 FactValue Load (0.4ms) SELECT "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = 2  (0.9ms) 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.4ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1 Environment Load (0.4ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1 Architecture Load (0.4ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1 User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 ORDER BY firstname LIMIT 1 Rendered hosts/_overview.html.erb (102.6ms) TemplateKind Load (0.4ms) SELECT "template_kinds".* FROM "template_kinds"  ConfigTemplate Load (1.3ms) 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.8ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "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 (1.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.8ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "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 (1.9ms) 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 (1.3ms) 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 (1.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" = 'finish' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1 ConfigTemplate Load (0.7ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'finish' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1 ConfigTemplate Load (1.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.7ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'script' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1 ConfigTemplate Load (1.3ms) 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.7ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXEGrub' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1 TemplateKind Load (0.4ms) SELECT "template_kinds".* FROM "template_kinds" WHERE "template_kinds"."id" = 1 LIMIT 1 TemplateKind Load (0.3ms) SELECT "template_kinds".* FROM "template_kinds" WHERE "template_kinds"."id" = 3 LIMIT 1 Rendered compute_resources_vms/show/_vmware.html.erb (17.7ms) 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-06-15 15:11:10.464427') ORDER BY reported_at Report Load (0.5ms) SELECT "reports".* FROM "reports" WHERE "reports"."host_id" = 2 AND (reported_at > '2013-06-15 15:11:10.467655') ORDER BY reported_at Rendered hosts/show.html.erb within layouts/application (280.0ms) Rendered home/_user_dropdown.html.erb (1.3ms) Read fragment views/tabs_and_title_records-1 (0.1ms) Rendered home/_topbar.html.erb (1.3ms) Completed 200 OK in 298ms (Views: 265.2ms | ActiveRecord: 24.1ms)