API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
260
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 76.27 KB | None | 0 0
raw download clone embed print report
  1. 2015-03-27 21:04:59 [I] Started POST "/hosts" for 93.76.22.75 at 2015-03-27 21:04:59 +0200
  2. 2015-03-27 21:04:59 [I] Processing by HostsController#create as */*
  3. 2015-03-27 21:04:59 [I] Parameters: {"utf8"=>"✓", "authenticity_token"=>"xbel3GUTI1+BNV6ymSkNnY6UFoC085TOXqTUKLGqfJk=", "host"=>{"name"=>"centos", "location_id"=>"1", "hostgroup_id"=>"16", "compute_resource_id"=>"3", "compute_profile_id"=>"7", "environment_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "config_group_ids"=>[""], "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "compute_attributes"=>{"cpus"=>"1", "corespersocket"=>"1", "memory_mb"=>"1024", "cluster"=>"Development", "path"=>"/Datacenters/UA/vm/Discovered virtual machine", "guest_id"=>"centos64Guest", "hardware_version"=>"Default", "start"=>"1", "volumes_attributes"=>{"new_volumes"=>{"_delete"=>"", "datastore"=>"ls1.sr1.dc1", "name"=>"Hard disk", "size_gb"=>"10", "thin"=>"true", "eager_zero"=>"false"}, "0"=>{"_delete"=>"", "datastore"=>"ua.vl6.iscsi.eql.lun1", "name"=>"disk1", "size_gb"=>"20", "thin"=>"true", "eager_zero"=>"false"}}}, "interfaces_attributes"=>{"0"=>{"_destroy"=>"0", "type"=>"Nic::Managed", "mac"=>"", "identifier"=>"", "name"=>"centos", "domain_id"=>"6", "subnet_id"=>"3", "ip"=>"172.16.160.80", "managed"=>"1", "primary"=>"1", "provision"=>"1", "virtual"=>"0", "tag"=>"", "attached_to"=>"", "compute_attributes"=>{"type"=>"VirtualVmxnet3", "network"=>"vlan60-Internal"}}, "new_interfaces"=>{"_destroy"=>"1", "type"=>"Nic::Managed", "mac"=>"", "identifier"=>"", "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "managed"=>"1", "primary"=>"0", "provision"=>"0", "virtual"=>"0", "tag"=>"", "attached_to"=>"", "compute_attributes"=>{"type"=>"VirtualE1000", "network"=>"DVUplinks-Adamant"}}}, "architecture_id"=>"1", "operatingsystem_id"=>"11", "provision_method"=>"build", "build"=>"1", "medium_id"=>"1", "ptable_id"=>"7", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "comment"=>"", "overwrite"=>"false"}, "capabilities"=>"build image", "provider"=>"Vmware"}
  4. 2015-03-27 21:04:59 [D] User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
  5. 2015-03-27 21:04:59 [D] Setting current user thread-local variable to altvnk
  6. 2015-03-27 21:04:59 [D] (0.6ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
  7. 2015-03-27 21:04:59 [D] Setting current location thread-local variable to none
  8. 2015-03-27 21:04:59 [D] AuthSource Load (0.6ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
  9. 2015-03-27 21:04:59 [D] SQL (0.4ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
  10. 2015-03-27 21:04:59 [D] User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1 [["id", 4]]
  11. 2015-03-27 21:04:59 [D] (0.2ms) BEGIN
  12. 2015-03-27 21:04:59 [D] Hostgroup Load (0.8ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 16 ORDER BY hostgroups.title LIMIT 1
  13. 2015-03-27 21:04:59 [D] Subnet Load (0.6ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 3 ORDER BY vlanid LIMIT 1
  14. 2015-03-27 21:04:59 [D] Operatingsystem Load (0.7ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 11 ORDER BY title LIMIT 1
  15. 2015-03-27 21:04:59 [D] Domain Load (0.6ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 6 ORDER BY domains.name LIMIT 1
  16. 2015-03-27 21:04:59 [D] CACHE (0.0ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 6 ORDER BY domains.name LIMIT 1
  17. 2015-03-27 21:04:59 [D] ComputeResource Load (0.6ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 3 ORDER BY compute_resources.name LIMIT 1
  18. 2015-03-27 21:04:59 [D] Nic::Interface Exists (0.7ms) SELECT 1 AS one FROM "nics" WHERE "nics"."type" IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND "nics"."ip" = '172.16.160.80' LIMIT 1
  19. 2015-03-27 21:04:59 [D] Nic::Interface Exists (0.5ms) SELECT 1 AS one FROM "nics" WHERE "nics"."type" IN ('Nic::Interface', 'Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND ("nics"."name" = 'centos.ua.int' AND "nics"."domain_id" = 6) LIMIT 1
  20. 2015-03-27 21:04:59 [D] SmartProxy Load (0.6ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 12 ORDER BY smart_proxies.name LIMIT 1
  21. 2015-03-27 21:04:59 [D] Scheduling new DHCP reservations for centos.ua.int
  22. 2015-03-27 21:04:59 [D] Using host queue
  23. 2015-03-27 21:04:59 [D] SmartProxy Load (0.5ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 9 ORDER BY smart_proxies.name LIMIT 1
  24. 2015-03-27 21:04:59 [D] CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 9 ORDER BY smart_proxies.name LIMIT 1
  25. 2015-03-27 21:04:59 [D] Scheduling new DNS entries
  26. 2015-03-27 21:04:59 [D] Using host queue
  27. 2015-03-27 21:04:59 [D] Using host queue
  28. 2015-03-27 21:04:59 [D] CACHE (0.0ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 12 ORDER BY smart_proxies.name LIMIT 1
  29. 2015-03-27 21:04:59 [D] ConfigTemplate Load (1.6ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 11 AND "template_kinds"."name" = 'PXELinux' AND "template_combinations"."hostgroup_id" = 16 AND "template_combinations"."environment_id" = 1 ORDER BY config_templates.name LIMIT 1
  30. 2015-03-27 21:04:59 [D] ConfigTemplate Load (1.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 "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 11 AND "template_kinds"."name" = 'PXELinux' AND "template_combinations"."hostgroup_id" = 16 AND "template_combinations"."environment_id" IS NULL ORDER BY config_templates.name LIMIT 1
  31. 2015-03-27 21:04:59 [D] ConfigTemplate Load (1.5ms) SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 11 AND "template_kinds"."name" = 'PXELinux' AND "template_combinations"."hostgroup_id" IS NULL AND "template_combinations"."environment_id" = 1 ORDER BY config_templates.name LIMIT 1
  32. 2015-03-27 21:04:59 [D] ConfigTemplate Load (1.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" = 11 AND "template_kinds"."name" = 'PXELinux' AND "os_default_templates"."operatingsystem_id" = 11 ORDER BY config_templates.name LIMIT 1
  33. 2015-03-27 21:04:59 [D] Using host queue
  34. 2015-03-27 21:04:59 [D] Using host queue
  35. 2015-03-27 21:04:59 [D] Host::Base Exists (0.6ms) SELECT 1 AS one FROM "hosts" WHERE "hosts"."name" = 'centos.ua.int' LIMIT 1
  36. 2015-03-27 21:04:59 [D] SmartProxy Load (0.5ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
  37. 2015-03-27 21:04:59 [D] Queueing Realm
  38. 2015-03-27 21:04:59 [D] Ptable Load (0.5ms) SELECT "ptables".* FROM "ptables" WHERE "ptables"."id" = 7 ORDER BY ptables.name LIMIT 1
  39. 2015-03-27 21:04:59 [D] Ptable Exists (0.7ms) SELECT 1 AS one FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 11 AND "ptables"."id" = 7 ORDER BY ptables.name LIMIT 1
  40. 2015-03-27 21:04:59 [D] Medium Load (0.6ms) SELECT "media".* FROM "media" WHERE "media"."id" = 1 ORDER BY media.name LIMIT 1
  41. 2015-03-27 21:04:59 [D] Medium Exists (0.6ms) SELECT 1 AS one FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 11 AND "media"."id" = 1 ORDER BY media.name LIMIT 1
  42. 2015-03-27 21:04:59 [D] Architecture Load (0.4ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
  43. 2015-03-27 21:04:59 [D] Architecture Exists (0.6ms) SELECT 1 AS one FROM "architectures" INNER JOIN "architectures_operatingsystems" ON "architectures"."id" = "architectures_operatingsystems"."architecture_id" WHERE "architectures_operatingsystems"."operatingsystem_id" = 11 AND "architectures"."id" = 1 LIMIT 1
  44. 2015-03-27 21:04:59 [D] Environment Load (0.5ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
  45. 2015-03-27 21:04:59 [D] Puppetclass Load (0.7ms) 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
  46. 2015-03-27 21:04:59 [I] Adding Compute instance for centos.ua.int
  47. 2015-03-27 21:04:59 [D] ComputeResource Exists (0.6ms) SELECT 1 AS one FROM "compute_resources" WHERE ("compute_resources"."name" = 'vmware-ua' AND "compute_resources"."id" != 3) LIMIT 1
  48. 2015-03-27 21:04:59 [I] Successfully decrypted field for Foreman::Model::Vmware vmware-ua
  49. 2015-03-27 21:04:59 [I] Successfully decrypted field for Foreman::Model::Vmware vmware-ua
  50. 2015-03-27 21:05:01 [I] Started GET "/tasks/0690bbfe-5d46-45b4-9a53-de70e095ea39" for 93.76.22.75 at 2015-03-27 21:05:01 +0200
  51. 2015-03-27 21:05:01 [I] Processing by TasksController#show as */*
  52. 2015-03-27 21:05:01 [I] Parameters: {"id"=>"0690bbfe-5d46-45b4-9a53-de70e095ea39"}
  53. 2015-03-27 21:05:01 [D] User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
  54. 2015-03-27 21:05:01 [D] Setting current user thread-local variable to altvnk
  55. 2015-03-27 21:05:01 [D] AuthSource Load (0.7ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
  56. 2015-03-27 21:05:01 [D] SQL (0.4ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
  57. 2015-03-27 21:05:01 [I] Rendered tasks/_list.html.erb (1.3ms)
  58. 2015-03-27 21:05:01 [I] Completed 200 OK in 12.2ms (Views: 2.1ms | ActiveRecord: 1.6ms)
  59. 2015-03-27 21:05:02 [I] Started GET "/tasks/0690bbfe-5d46-45b4-9a53-de70e095ea39" for 93.76.22.75 at 2015-03-27 21:05:02 +0200
  60. 2015-03-27 21:05:02 [I] Processing by TasksController#show as */*
  61. 2015-03-27 21:05:02 [I] Parameters: {"id"=>"0690bbfe-5d46-45b4-9a53-de70e095ea39"}
  62. 2015-03-27 21:05:02 [D] User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
  63. 2015-03-27 21:05:02 [D] Setting current user thread-local variable to altvnk
  64. 2015-03-27 21:05:02 [D] AuthSource Load (0.6ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
  65. 2015-03-27 21:05:02 [D] SQL (0.4ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
  66. 2015-03-27 21:05:02 [I] Rendered tasks/_list.html.erb (1.3ms)
  67. 2015-03-27 21:05:02 [I] Completed 200 OK in 11.7ms (Views: 2.1ms | ActiveRecord: 1.6ms)
  68. 2015-03-27 21:05:03 [D] Host::Managed Load (0.9ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."uuid" = '502d4973-d69e-c7a1-db60-64008741aa78' LIMIT 1
  69. 2015-03-27 21:05:03 [D] Orchestration::Compute: Trying to match network interfaces from fog <Fog::Compute::Vsphere::Interfaces
  70. server_id="502d4973-d69e-c7a1-db60-64008741aa78"
  71. [
  72. <Fog::Compute::Vsphere::Interface
  73. mac="00:50:56:ad:84:ae",
  74. network="dvportgroup-236",
  75. name="Network adapter 1",
  76. status="untried",
  77. summary="DVSwitch: f4 1e 2d 50 ac 49 e8 45-59 22 ba 45 20 23 46 66",
  78. type=VirtualVmxnet3,
  79. key=4000,
  80. virtualswitch=nil,
  81. server_id="502d4973-d69e-c7a1-db60-64008741aa78"
  82. >
  83. ]
  84. >
  85. 2015-03-27 21:05:03 [D] Orchestration::Compute: Could not match network interface #<Nic::Managed id: nil, mac: nil, ip: "172.16.160.80", type: "Nic::Managed", name: "centos.ua.int", host_id: nil, subnet_id: 3, domain_id: 6, attrs: {}, created_at: nil, updated_at: nil, provider: nil, username: nil, password: nil, virtual: false, link: true, identifier: "", tag: "", attached_to: "", managed: true, mode: "balance-rr", attached_devices: "", bond_options: "", primary: true, provision: true, compute_attributes: {"type"=>"VirtualVmxnet3", "network"=>"vlan60-Internal"}>
  86. 2015-03-27 21:05:03 [I] Add DNS A record for centos.ua.int/172.16.160.80
  87. 2015-03-27 21:05:03 [I] Add DNS PTR record for 172.16.160.80/centos.ua.int
  88. 2015-03-27 21:05:03 [W] Create DHCP Settings for centos.ua.int task failed with the following error: Invalid MAC /usr/share/foreman/lib/net/validations.rb:40:in `validate_mac'
  89. /usr/share/foreman/lib/net/dhcp/record.rb:7:in `initialize'
  90. /usr/share/foreman/app/models/nic/managed.rb:40:in `new'
  91. /usr/share/foreman/app/models/nic/managed.rb:40:in `dhcp_record'
  92. /usr/share/foreman/app/models/concerns/orchestration/dhcp.rb:24:in `set_dhcp'
  93. /usr/share/foreman/app/models/concerns/orchestration.rb:141:in `execute'
  94. /usr/share/foreman/app/models/concerns/orchestration.rb:86:in `block in process'
  95. /usr/share/foreman/app/models/concerns/orchestration.rb:78:in `each'
  96. /usr/share/foreman/app/models/concerns/orchestration.rb:78:in `process'
  97. /usr/share/foreman/app/models/concerns/orchestration.rb:19:in `on_save'
  98. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:649:in `_run__1528247190101554106__save__155756226250755217__callbacks'
  99. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:405:in `__run_callback'
  100. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:385:in `_run_save_callbacks'
  101. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:81:in `run_callbacks'
  102. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/callbacks.rb:264:in `create_or_update'
  103. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/persistence.rb:84:in `save'
  104. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/validations.rb:50:in `save'
  105. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/attribute_methods/dirty.rb:22:in `save'
  106. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:259:in `block (2 levels) in save'
  107. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:313:in `block in with_transaction_returning_status'
  108. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
  109. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:208:in `transaction'
  110. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:311:in `with_transaction_returning_status'
  111. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:259:in `block in save'
  112. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:270:in `rollback_active_record_state!'
  113. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/transactions.rb:258:in `save'
  114. /usr/share/foreman/app/models/concerns/foreman/sti.rb:29:in `save_with_type'
  115. /usr/share/foreman/app/controllers/hosts_controller.rb:83:in `create'
  116. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
  117. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/abstract_controller/base.rb:167:in `process_action'
  118. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/rendering.rb:10:in `process_action'
  119. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/abstract_controller/callbacks.rb:18:in `block in process_action'
  120. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:627:in `block (4 levels) in _run__4411987558827080720__process_action__34311660323268999__callbacks'
  121. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_7762'
  122. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:326:in `around'
  123. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:310:in `_callback_around_2205'
  124. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_7762'
  125. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:626:in `block (3 levels) in _run__4411987558827080720__process_action__34311660323268999__callbacks'
  126. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_7761'
  127. /usr/share/foreman/app/controllers/concerns/application_shared.rb:13:in `set_timezone'
  128. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_7761'
  129. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:625:in `block (2 levels) in _run__4411987558827080720__process_action__34311660323268999__callbacks'
  130. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_7760'
  131. /usr/share/foreman/app/models/concerns/foreman/thread_session.rb:32:in `clear_thread'
  132. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_7760'
  133. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:448:in `block in _run__4411987558827080720__process_action__34311660323268999__callbacks'
  134. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_7759'
  135. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:326:in `around'
  136. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:310:in `_callback_around_13'
  137. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_7759'
  138. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:414:in `_run__4411987558827080720__process_action__34311660323268999__callbacks'
  139. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:405:in `__run_callback'
  140. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
  141. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:81:in `run_callbacks'
  142. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/abstract_controller/callbacks.rb:17:in `process_action'
  143. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/rescue.rb:29:in `process_action'
  144. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
  145. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/notifications.rb:123:in `block in instrument'
  146. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  147. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/notifications.rb:123:in `instrument'
  148. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
  149. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
  150. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
  151. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/abstract_controller/base.rb:121:in `process'
  152. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/abstract_controller/rendering.rb:45:in `process'
  153. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal.rb:203:in `dispatch'
  154. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
  155. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_controller/metal.rb:246:in `block in action'
  156. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/routing/route_set.rb:73:in `call'
  157. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
  158. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/routing/route_set.rb:36:in `call'
  159. /usr/share/foreman/vendor/ruby/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call'
  160. /usr/share/foreman/vendor/ruby/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:56:in `each'
  161. /usr/share/foreman/vendor/ruby/1.9.1/gems/journey-1.0.4/lib/journey/router.rb:56:in `call'
  162. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/routing/route_set.rb:608:in `call'
  163. /usr/share/foreman/vendor/ruby/1.9.1/gems/apipie-rails-0.2.6/lib/apipie/extractor/recorder.rb:97:in `call'
  164. /usr/share/foreman/vendor/ruby/1.9.1/gems/apipie-rails-0.2.6/lib/apipie/middleware/checksum_in_headers.rb:27:in `call'
  165. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
  166. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/etag.rb:23:in `call'
  167. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/conditionalget.rb:35:in `call'
  168. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/head.rb:14:in `call'
  169. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
  170. /usr/share/foreman/lib/middleware/catch_json_parse_errors.rb:9:in `call'
  171. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/flash.rb:242:in `call'
  172. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/session/abstract/id.rb:210:in `context'
  173. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/session/abstract/id.rb:205:in `call'
  174. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/cookies.rb:341:in `call'
  175. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/query_cache.rb:64:in `call'
  176. /usr/share/foreman/vendor/ruby/1.9.1/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call'
  177. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
  178. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:405:in `_run__1409129249515992813__call__155756226250755217__callbacks'
  179. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:405:in `__run_callback'
  180. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
  181. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/callbacks.rb:81:in `run_callbacks'
  182. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
  183. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
  184. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
  185. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
  186. /usr/share/foreman/vendor/ruby/1.9.1/gems/railties-3.2.21/lib/rails/rack/logger.rb:32:in `call_app'
  187. /usr/share/foreman/vendor/ruby/1.9.1/gems/railties-3.2.21/lib/rails/rack/logger.rb:16:in `block in call'
  188. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/tagged_logging.rb:22:in `tagged'
  189. /usr/share/foreman/vendor/ruby/1.9.1/gems/railties-3.2.21/lib/rails/rack/logger.rb:16:in `call'
  190. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/request_id.rb:22:in `call'
  191. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/methodoverride.rb:21:in `call'
  192. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/runtime.rb:17:in `call'
  193. /usr/share/foreman/vendor/ruby/1.9.1/gems/activesupport-3.2.21/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
  194. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/lock.rb:15:in `call'
  195. /usr/share/foreman/vendor/ruby/1.9.1/gems/actionpack-3.2.21/lib/action_dispatch/middleware/static.rb:83:in `call'
  196. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward'
  197. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:143:in `pass'
  198. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:155:in `invalidate'
  199. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:71:in `call!'
  200. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call'
  201. /usr/share/foreman/vendor/ruby/1.9.1/gems/railties-3.2.21/lib/rails/engine.rb:484:in `call'
  202. /usr/share/foreman/vendor/ruby/1.9.1/gems/railties-3.2.21/lib/rails/application.rb:231:in `call'
  203. /usr/share/foreman/vendor/ruby/1.9.1/gems/railties-3.2.21/lib/rails/railtie/configurable.rb:30:in `method_missing'
  204. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/builder.rb:134:in `call'
  205. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/urlmap.rb:64:in `block in call'
  206. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/urlmap.rb:49:in `each'
  207. /usr/share/foreman/vendor/ruby/1.9.1/gems/rack-1.4.5/lib/rack/urlmap.rb:49:in `call'
  208. /usr/lib/ruby/vendor_ruby/phusion_passenger/rack/request_handler.rb:96:in `process_request'
  209. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_request_handler.rb:516:in `accept_and_process_next_request'
  210. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
  211. /usr/lib/ruby/vendor_ruby/phusion_passenger/rack/application_spawner.rb:206:in `start_request_handler'
  212. /usr/lib/ruby/vendor_ruby/phusion_passenger/rack/application_spawner.rb:171:in `block in handle_spawn_application'
  213. /usr/lib/ruby/vendor_ruby/phusion_passenger/utils.rb:479:in `safe_fork'
  214. /usr/lib/ruby/vendor_ruby/phusion_passenger/rack/application_spawner.rb:166:in `handle_spawn_application'
  215. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
  216. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
  217. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server.rb:180:in `start'
  218. /usr/lib/ruby/vendor_ruby/phusion_passenger/rack/application_spawner.rb:129:in `start'
  219. /usr/lib/ruby/vendor_ruby/phusion_passenger/spawn_manager.rb:253:in `block (2 levels) in spawn_rack_application'
  220. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
  221. /usr/lib/ruby/vendor_ruby/phusion_passenger/spawn_manager.rb:246:in `block in spawn_rack_application'
  222. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server_collection.rb:82:in `block in synchronize'
  223. <internal:prelude>:10:in `synchronize'
  224. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  225. /usr/lib/ruby/vendor_ruby/phusion_passenger/spawn_manager.rb:244:in `spawn_rack_application'
  226. /usr/lib/ruby/vendor_ruby/phusion_passenger/spawn_manager.rb:137:in `spawn_application'
  227. /usr/lib/ruby/vendor_ruby/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
  228. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
  229. /usr/lib/ruby/vendor_ruby/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
  230. /usr/share/phusion-passenger/helper-scripts/passenger-spawn-server:99:in `<main>'
  231. 2015-03-27 21:05:03 [W] Rolling back due to a problem: [Create DHCP Settings for centos.ua.int 10 failed [#<Nic::Managed id: nil, mac: nil, ip: "172.16.160.80", type: "Nic::Managed", name: "centos.ua.int", host_id: nil, subnet_id: 3, domain_id: 6, attrs: {}, created_at: nil, updated_at: nil, provider: nil, username: nil, password: nil, virtual: false, link: true, identifier: "", tag: "", attached_to: "", managed: true, mode: "balance-rr", attached_devices: "", bond_options: "", primary: true, provision: true, compute_attributes: {"type"=>"VirtualVmxnet3", "network"=>"vlan60-Internal"}>, :set_dhcp]]
  232. 2015-03-27 21:05:03 [I] Delete the DNS PTR record for 172.16.160.80/centos.ua.int
  233. 2015-03-27 21:05:03 [I] Delete the DNS A record for centos.ua.int/172.16.160.80
  234. 2015-03-27 21:05:03 [I] Removing Compute instance for centos.ua.int
  235. 2015-03-27 21:05:04 [I] Started GET "/tasks/0690bbfe-5d46-45b4-9a53-de70e095ea39" for 93.76.22.75 at 2015-03-27 21:05:04 +0200
  236. 2015-03-27 21:05:04 [I] Processing by TasksController#show as */*
  237. 2015-03-27 21:05:04 [I] Parameters: {"id"=>"0690bbfe-5d46-45b4-9a53-de70e095ea39"}
  238. 2015-03-27 21:05:04 [D] User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
  239. 2015-03-27 21:05:04 [D] Setting current user thread-local variable to altvnk
  240. 2015-03-27 21:05:04 [D] AuthSource Load (0.6ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
  241. 2015-03-27 21:05:04 [D] SQL (0.5ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
  242. 2015-03-27 21:05:04 [I] Rendered tasks/_list.html.erb (1.3ms)
  243. 2015-03-27 21:05:04 [I] Completed 200 OK in 11.6ms (Views: 2.0ms | ActiveRecord: 1.6ms)
  244. 2015-03-27 21:05:04 [D] (0.4ms) ROLLBACK
  245. 2015-03-27 21:05:04 [D] Organization Load (1.0ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" IS NULL ORDER BY title LIMIT 1
  246. 2015-03-27 21:05:04 [D] Location Load (0.7ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" = 1 ORDER BY title LIMIT 1
  247. 2015-03-27 21:05:04 [I] Failed to save: Create DHCP Settings for centos.ua.int task failed with the following error: Invalid MAC
  248. 2015-03-27 21:05:05 [I] Rendered hosts/_progress.html.erb (0.5ms)
  249. 2015-03-27 21:05:05 [D] Setting current organization thread-local variable to none
  250. 2015-03-27 21:05:05 [D] Setting current location thread-local variable to UA
  251. 2015-03-27 21:05:05 [D] Taxonomy Load (0.9ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  252. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  253. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  254. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  255. 2015-03-27 21:05:05 [D] (1.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 "smart_proxies"."id" IN (1, 9, 12) AND "features"."name" IN ('Puppet')
  256. 2015-03-27 21:05:05 [D] Location Load (0.7ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') ORDER BY title
  257. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  258. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  259. 2015-03-27 21:05:05 [D] Hostgroup Load (0.9ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND (1=1)
  260. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'ComputeResource' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  261. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'ComputeResource' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  262. 2015-03-27 21:05:05 [D] ComputeResource Load (0.6ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" IN (1, 3) AND (1=1) ORDER BY name
  263. 2015-03-27 21:05:05 [D] (0.8ms) SELECT COUNT(DISTINCT "compute_profiles"."id") FROM "compute_profiles" LEFT OUTER JOIN "compute_attributes" ON "compute_attributes"."compute_profile_id" = "compute_profiles"."id" WHERE (compute_attributes.id > 0)
  264. 2015-03-27 21:05:05 [D] SQL (1.1ms) SELECT "compute_profiles"."id" AS t0_r0, "compute_profiles"."name" AS t0_r1, "compute_profiles"."created_at" AS t0_r2, "compute_profiles"."updated_at" AS t0_r3, "compute_attributes"."id" AS t1_r0, "compute_attributes"."compute_profile_id" AS t1_r1, "compute_attributes"."compute_resource_id" AS t1_r2, "compute_attributes"."name" AS t1_r3, "compute_attributes"."vm_attrs" AS t1_r4, "compute_attributes"."created_at" AS t1_r5, "compute_attributes"."updated_at" AS t1_r6 FROM "compute_profiles" LEFT OUTER JOIN "compute_attributes" ON "compute_attributes"."compute_profile_id" = "compute_profiles"."id" WHERE (compute_attributes.id > 0) ORDER BY compute_profiles.name
  265. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  266. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  267. 2015-03-27 21:05:05 [D] Environment Load (0.5ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" IN (1) AND (1=1) ORDER BY name
  268. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  269. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  270. 2015-03-27 21:05:05 [D] (0.8ms) 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" IN ('Puppet CA') AND "smart_proxies"."id" IN (1, 9, 12) AND (1=1)
  271. 2015-03-27 21:05:05 [D] SmartProxy Load (0.9ms) 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" IN ('Puppet CA') AND "smart_proxies"."id" IN (1, 9, 12) AND (1=1)
  272. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  273. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  274. 2015-03-27 21:05:05 [D] (0.8ms) 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" IN ('Puppet') AND "smart_proxies"."id" IN (1, 9, 12) AND (1=1)
  275. 2015-03-27 21:05:05 [D] SmartProxy Load (0.9ms) 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" IN ('Puppet') AND "smart_proxies"."id" IN (1, 9, 12) AND (1=1)
  276. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  277. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Realm' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  278. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  279. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Realm' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  280. 2015-03-27 21:05:05 [D] (0.4ms) SELECT COUNT(*) FROM "realms" WHERE 1=0
  281. 2015-03-27 21:05:05 [D] (0.4ms) SELECT COUNT(*) FROM "config_groups"
  282. 2015-03-27 21:05:05 [D] ConfigGroup Load (0.6ms) SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  283. 2015-03-27 21:05:05 [D] ConfigGroup Load (0.4ms) SELECT "config_groups".* FROM "config_groups" ORDER BY config_groups.name
  284. 2015-03-27 21:05:05 [D] SQL (0.9ms) SELECT "puppetclasses".id FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 5 ORDER BY puppetclasses.name
  285. 2015-03-27 21:05:05 [D] SQL (0.9ms) SELECT "puppetclasses".id FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 5 ORDER BY puppetclasses.name
  286. 2015-03-27 21:05:05 [D] Puppetclass Load (0.9ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 5 ORDER BY puppetclasses.name
  287. 2015-03-27 21:05:05 [D] Puppetclass Load (13.5ms) 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
  288. 2015-03-27 21:05:05 [I] Rendered config_groups/_config_group.html.erb (64.3ms)
  289. 2015-03-27 21:05:05 [D] SQL (1.0ms) SELECT "puppetclasses".id FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 4 ORDER BY puppetclasses.name
  290. 2015-03-27 21:05:05 [D] SQL (0.8ms) SELECT "puppetclasses".id FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 4 ORDER BY puppetclasses.name
  291. 2015-03-27 21:05:05 [D] Puppetclass Load (1.0ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 4 ORDER BY puppetclasses.name
  292. 2015-03-27 21:05:05 [I] Rendered config_groups/_config_group.html.erb (12.0ms)
  293. 2015-03-27 21:05:05 [I] Rendered config_groups/_config_groups_selection.html.erb (83.7ms)
  294. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  295. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  296. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  297. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  298. 2015-03-27 21:05:05 [D] Hostgroup Load (0.8ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  299. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  300. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  301. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  302. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  303. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  304. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  305. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  306. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  307. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  308. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  309. 2015-03-27 21:05:05 [D] 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 AND 1=0 ORDER BY puppetclasses.name
  310. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  311. 2015-03-27 21:05:05 [I] Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)
  312. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  313. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  314. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  315. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  316. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  317. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  318. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  319. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  320. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  321. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  322. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  323. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  324. 2015-03-27 21:05:05 [D] SQL (0.7ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  325. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  326. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  327. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  328. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  329. 2015-03-27 21:05:05 [I] Rendered puppetclasses/_classes_in_groups.html.erb (0.0ms)
  330. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  331. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  332. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  333. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  334. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  335. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  336. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  337. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  338. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  339. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  340. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  341. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  342. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  343. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  344. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  345. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  346. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  347. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  348. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  349. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  350. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  351. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  352. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  353. 2015-03-27 21:05:05 [D] SQL (0.7ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  354. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  355. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  356. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  357. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  358. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  359. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  360. 2015-03-27 21:05:05 [D] SQL (0.5ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  361. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  362. 2015-03-27 21:05:05 [D] SQL (0.6ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  363. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  364. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  365. 2015-03-27 21:05:05 [D] SQL (0.4ms) SELECT "host_classes"."puppetclass_id" FROM "host_classes" WHERE "host_classes"."host_id" IS NULL
  366. 2015-03-27 21:05:05 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  367. 2015-03-27 21:05:05 [I] Started GET "/tasks/0690bbfe-5d46-45b4-9a53-de70e095ea39" for 93.76.22.75 at 2015-03-27 21:05:05 +0200
  368. 2015-03-27 21:05:05 [I] Processing by TasksController#show as */*
  369. 2015-03-27 21:05:05 [I] Parameters: {"id"=>"0690bbfe-5d46-45b4-9a53-de70e095ea39"}
  370. 2015-03-27 21:05:05 [D] User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
  371. 2015-03-27 21:05:05 [D] Setting current user thread-local variable to altvnk
  372. 2015-03-27 21:05:05 [D] AuthSource Load (0.3ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
  373. 2015-03-27 21:05:05 [D] SQL (0.2ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
  374. 2015-03-27 21:05:05 [I] Rendered tasks/_list.html.erb (0.6ms)
  375. 2015-03-27 21:05:05 [I] Completed 200 OK in 5.5ms (Views: 1.0ms | ActiveRecord: 0.7ms)
  376. 2015-03-27 21:05:06 [I] Rendered puppetclasses/_classes.html.erb (866.4ms)
  377. 2015-03-27 21:05:06 [I] Rendered puppetclasses/_class_selection.html.erb (1117.6ms)
  378. 2015-03-27 21:05:06 [I] Rendered hosts/_compute.html.erb (5.2ms)
  379. 2015-03-27 21:05:06 [D] SQL (0.4ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  380. 2015-03-27 21:05:06 [D] SQL (0.3ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  381. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  382. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  383. 2015-03-27 21:05:06 [D] (0.2ms) SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (2, 1, 4, 6, 8) AND (1=1)
  384. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  385. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  386. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (2, 1, 4, 6, 8) AND (1=1)
  387. 2015-03-27 21:05:06 [D] Domain Load (0.3ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" IN (2, 1, 4, 6, 8) AND (1=1) ORDER BY name
  388. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  389. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  390. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  391. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  392. 2015-03-27 21:05:06 [D] (0.2ms) SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (1, 3, 6) AND (1=1)
  393. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  394. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  395. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (1, 3, 6) AND (1=1)
  396. 2015-03-27 21:05:06 [D] Subnet Load (0.3ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" IN (1, 3, 6) AND (1=1) ORDER BY name
  397. 2015-03-27 21:05:06 [I] Rendered nic/_base_form.html.erb (23.2ms)
  398. 2015-03-27 21:05:06 [I] Rendered nic/_virtual_form.html.erb (1.1ms)
  399. 2015-03-27 21:05:06 [I] Rendered compute_resources_vms/form/vmware/_network.html.erb (244.7ms)
  400. 2015-03-27 21:05:06 [I] Rendered nic/_provider_specific_form.html.erb (245.7ms)
  401. 2015-03-27 21:05:06 [I] Rendered nic/manageds/_managed.html.erb (272.1ms)
  402. 2015-03-27 21:05:06 [D] SQL (0.4ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  403. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  404. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  405. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  406. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (2, 1, 4, 6, 8) AND (1=1)
  407. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  408. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  409. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (2, 1, 4, 6, 8) AND (1=1)
  410. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" IN (2, 1, 4, 6, 8) AND (1=1) ORDER BY name
  411. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  412. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  413. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  414. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  415. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (1, 3, 6) AND (1=1)
  416. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  417. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  418. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (1, 3, 6) AND (1=1)
  419. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" IN (1, 3, 6) AND (1=1) ORDER BY name
  420. 2015-03-27 21:05:06 [I] Rendered nic/_base_form.html.erb (21.9ms)
  421. 2015-03-27 21:05:06 [I] Rendered nic/_virtual_form.html.erb (1.1ms)
  422. 2015-03-27 21:05:06 [I] Rendered compute_resources_vms/form/vmware/_network.html.erb (237.1ms)
  423. 2015-03-27 21:05:06 [I] Rendered nic/_provider_specific_form.html.erb (238.0ms)
  424. 2015-03-27 21:05:06 [I] Rendered nic/manageds/_managed.html.erb (263.1ms)
  425. 2015-03-27 21:05:06 [I] Rendered hosts/_interfaces.html.erb (537.6ms)
  426. 2015-03-27 21:05:06 [D] Architecture Load (0.4ms) SELECT "architectures".* FROM "architectures"
  427. 2015-03-27 21:05:06 [D] Operatingsystem Load (0.4ms) SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN "architectures_operatingsystems" ON "operatingsystems"."id" = "architectures_operatingsystems"."operatingsystem_id" WHERE "architectures_operatingsystems"."architecture_id" = 1 ORDER BY title
  428. 2015-03-27 21:05:06 [I] Rendered common/os_selection/_architecture.html.erb (3.7ms)
  429. 2015-03-27 21:05:06 [D] SQL (0.3ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  430. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  431. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  432. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  433. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  434. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  435. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  436. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  437. 2015-03-27 21:05:06 [D] (0.3ms) SELECT COUNT(*) FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 11 AND "media"."id" IN (2, 1) AND (1=1)
  438. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  439. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  440. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  441. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  442. 2015-03-27 21:05:06 [D] Medium Load (0.3ms) SELECT "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 11 AND "media"."id" IN (2, 1) AND (1=1) ORDER BY media.name
  443. 2015-03-27 21:05:06 [D] Ptable Load (0.3ms) SELECT "ptables".* FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 11 ORDER BY ptables.name
  444. 2015-03-27 21:05:06 [I] Rendered common/os_selection/_operatingsystem.html.erb (18.1ms)
  445. 2015-03-27 21:05:06 [I] Rendered hosts/_operating_system.html.erb (27.6ms)
  446. 2015-03-27 21:05:06 [I] Rendered hosts/_unattended.html.erb (571.5ms)
  447. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  448. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  449. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  450. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  451. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1, 4, 7, 8, 9, 10, 13, 14, 15, 16, 17, 19, 20, 21, 22, 23, 24) AND "hostgroups"."id" IN (16) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  452. 2015-03-27 21:05:06 [D] SQL (0.3ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 16 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
  453. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "config_group_classes"."puppetclass_id" FROM "config_group_classes" WHERE 1=0
  454. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (16)
  455. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "host_classes"."puppetclass_id" FROM "host_classes" WHERE "host_classes"."host_id" IS NULL
  456. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 1 AND 1=0 ORDER BY puppetclasses.name
  457. 2015-03-27 21:05:06 [D] (0.2ms) SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE 1=0 GROUP BY puppetclass_id
  458. 2015-03-27 21:05:06 [D] (0.2ms) 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 1=0 GROUP BY environment_classes.puppetclass_id
  459. 2015-03-27 21:05:06 [I] Rendered puppetclasses/_class_parameters.html.erb (0.0ms)
  460. 2015-03-27 21:05:06 [I] Rendered puppetclasses/_classes_parameters.html.erb (12.4ms)
  461. 2015-03-27 21:05:06 [D] CommonParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') ORDER BY parameters.name
  462. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" = 1 ORDER BY title LIMIT 1
  463. 2015-03-27 21:05:06 [D] LocationParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('LocationParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
  464. 2015-03-27 21:05:06 [D] DomainParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 6 ORDER BY parameters.name
  465. 2015-03-27 21:05:06 [D] OsParameter Load (0.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 11 ORDER BY parameters.name
  466. 2015-03-27 21:05:06 [D] GroupParameter Load (0.3ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 16 ORDER BY parameters.name
  467. 2015-03-27 21:05:06 [I] Rendered common_parameters/_inherited_parameters.html.erb (1.6ms)
  468. 2015-03-27 21:05:06 [I] Rendered common_parameters/_puppetclass_parameter.html.erb (2.8ms)
  469. 2015-03-27 21:05:06 [I] Rendered common_parameters/_puppetclasses_parameters.html.erb (3.9ms)
  470. 2015-03-27 21:05:06 [I] Rendered common_parameters/_parameter.html.erb (1.6ms)
  471. 2015-03-27 21:05:06 [I] Rendered common_parameters/_parameters.html.erb (3.3ms)
  472. 2015-03-27 21:05:06 [D] AuthSourceHidden Load (0.2ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."type" IN ('AuthSourceHidden')
  473. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  474. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'User' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  475. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "users"."id" FROM "users" WHERE "users"."admin" = 't'
  476. 2015-03-27 21:05:06 [D] CACHE (0.0ms) SELECT id FROM "taxonomies" WHERE ((("taxonomies"."id" = 1 OR "taxonomies"."ancestry" ILIKE '1/%') OR "taxonomies"."ancestry" = '1')) ORDER BY title
  477. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "taxable_taxonomies"."taxable_id" FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'User' AND "taxable_taxonomies"."taxonomy_id" IN (1)
  478. 2015-03-27 21:05:06 [D] SQL (0.2ms) SELECT "users"."id" FROM "users" WHERE "users"."admin" = 't'
  479. 2015-03-27 21:05:06 [D] User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IN (6, 1, 2, 3, 6, 4, 5) AND (users.auth_source_id <> 2) ORDER BY firstname
  480. 2015-03-27 21:05:06 [D] Usergroup Load (0.2ms) SELECT "usergroups".* FROM "usergroups" ORDER BY usergroups.name
  481. 2015-03-27 21:05:06 [D] Setting current location thread-local variable to none
  482. 2015-03-27 21:05:06 [D] Setting current organization thread-local variable to none
  483. 2015-03-27 21:05:06 [I] Rendered hosts/_form.html.erb (1848.3ms)
  484. 2015-03-27 21:05:06 [I] Rendered hosts/new.html.erb within layouts/application (1850.1ms)
  485. 2015-03-27 21:05:06 [I] Rendered home/_user_dropdown.html.erb (1.5ms)
  486. 2015-03-27 21:05:06 [I] Read fragment views/tabs_and_title_records-4 0.1ms
  487. 2015-03-27 21:05:06 [I] Rendered home/_topbar.html.erb (2.6ms)
  488. 2015-03-27 21:05:06 [I] Rendered layouts/base.html.erb (4.6ms)
  489. 2015-03-27 21:05:06 [I] Completed 200 OK in 7504.2ms (Views: 1908.1ms | ActiveRecord: 97.0ms)
  490. 2015-03-27 21:05:07 [I] Started GET "/tasks/0690bbfe-5d46-45b4-9a53-de70e095ea39" for 93.76.22.75 at 2015-03-27 21:05:07 +0200
  491. 2015-03-27 21:05:07 [I] Processing by TasksController#show as */*
  492. 2015-03-27 21:05:07 [I] Parameters: {"id"=>"0690bbfe-5d46-45b4-9a53-de70e095ea39"}
  493. 2015-03-27 21:05:07 [D] User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
  494. 2015-03-27 21:05:07 [D] Setting current user thread-local variable to altvnk
  495. 2015-03-27 21:05:07 [D] AuthSource Load (0.7ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
  496. 2015-03-27 21:05:07 [D] SQL (0.6ms) SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
  497. 2015-03-27 21:05:07 [I] Rendered tasks/_list.html.erb (1.4ms)
  498. 2015-03-27 21:05:07 [I] Completed 200 OK in 16.0ms (Views: 2.8ms | ActiveRecord: 2.0ms)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!