Actions
Bug #20354
openn+1 count when listing vmware vm's
Status:
New
Priority:
Normal
Assignee:
-
Category:
Compute resources - VMware
Target version:
-
Description
from the logs:
[app] [I] Started GET "/compute_resources/29-/vms" for ::1 at 2017-07-20 09:58:25 +0300 [app] [I] Processing by ComputeResourcesVmsController#index as HTML [app] [I] Parameters: {"compute_resource_id"=>"29-"} [sql] [D] ActiveRecord::SessionStore::Session Load (0.3ms) SELECT "sessions".* FROM "sessions" WHERE "sessions"."session_id" = ? ORDER BY "sessions"."id" ASC LIMIT ? [["session_id", "01daaa37d34e6c9cd5273e70deb1b42b"], ["LIMIT", 1]] [sql] [D] User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ? [["id", 1], ["LIMIT", 1]] [app] [I] Current user: admin (administrator) [app] [D] Setting current user thread-local variable to admin [sql] [D] (0.3ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') [app] [D] Setting current organization thread-local variable to none [sql] [D] (0.2ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') [app] [D] Setting current location thread-local variable to none [sql] [D] AuthSource Load (0.3ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = ? LIMIT ? [["id", 9], ["LIMIT", 1]] [sql] [D] (0.2ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT ? [["LIMIT", 1]] [sql] [D] (0.3ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT ? [["LIMIT", 1]] [sql] [D] ComputeResource Load (0.5ms) SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = ? ORDER BY compute_resources.name LIMIT ? [["id", 29], ["LIMIT", 1]] [app] [I] Rendering compute_resources_vms/index.html.erb within layouts/application [sql] [D] (0.3ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502eeead-da13-8497-e824-68ea664a7a13' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e5b19-e349-9a78-bc8d-990f06724787' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e246d-5670-8948-57f9-5988ea6fa612' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e020d-9e0c-2421-fa6c-098902616bec' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e33dd-281d-db72-1fdd-72565d667910' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e3834-81b9-dd17-1ec1-986363a547e9' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e6003-eb43-b429-5126-6e1451c8cebe' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502efb57-9bbc-781f-6ea0-db5ec3e075d5' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e816a-f229-7051-7001-dad9d2239b5a' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e9c57-8716-2d97-49a2-b9e6a3a5cbb6' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e00b3-21d0-c896-6655-b8e9bbc1157e' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e0d13-7c21-0685-9cbe-7863be8bc02f' [["compute_resource_id", 29]] [sql] [D] (0.3ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e2bda-8c72-6273-f495-a85b38d41acc' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ed7dc-fec1-73ae-41e3-a5c1dcae4086' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e9c97-4320-8c18-11c1-e12780aedef2' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e7477-7340-e187-1a1e-87850c17809c' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '50312c5e-851b-8e99-ed29-4524eaf71955' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ee01c-f42d-7bd0-dab9-dbffb028a492' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ec2a7-27b1-12b3-e454-988621f5b275' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e5e88-2cd8-5273-4191-47b92abd9349' [["compute_resource_id", 29]] [sql] [D] (0.3ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502edc4f-729b-a099-5431-a95933783c6c' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e3fbb-70d0-593a-b07b-702d5af45909' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e750b-c806-c091-9aeb-c9684416a0fc' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ea5e7-d041-2c48-9ae4-904901f550e1' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '523ea6b0-9c58-3198-64da-2db8d5c27f5b' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ebdfe-a5f1-153f-1f09-f55544a1c703' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ef107-2042-5ac7-4690-e98a2b423558' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e7fac-f5d5-ab41-c749-0b7a601b5876' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e0d25-8e83-8006-ae19-d7536f11ceff' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e2193-611b-a879-c85e-6c893fb2f766' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e0533-c08c-4b41-7b38-dab314ac9d07' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e5008-16c5-e6f1-05fe-d73887478a54' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501eebe4-8a0b-b926-599f-e2f78982782a' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e3758-c2d4-48fb-8297-b4fe238cbb1e' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e8163-bfc6-2dae-8d38-688e9fe8f1bf' [["compute_resource_id", 29]] [sql] [D] (0.3ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e75d0-aa98-7642-fb1e-c24cea4d91a1' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ee056-2345-c0f9-9d8b-4cbff31a0a8c' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ef9ff-22f3-4507-c347-23b6f6b95d1c' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e0a0e-e886-21ab-f0f6-6b86745e354f' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e397f-f193-a349-8a75-993f1b75ccee' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501ed804-491a-1e2b-a0e5-9cd47a7ce1bd' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '50312ef9-c2ab-ab33-9377-dae2e3c862ac' [["compute_resource_id", 29]] [sql] [D] (0.3ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501e60a2-27ca-dc38-34ce-64ced3bb783e' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ed4f6-f641-01a3-eefd-9d63ad025e02' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '501edc40-cdfb-e406-a239-9b85dff761e8' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e8c0a-3359-52f3-7236-5f044fe026f4' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502ee41e-c028-7143-bf16-c92fc342e75e' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e8db3-4bb8-b776-20aa-ed2d43fab649' [["compute_resource_id", 29]] [sql] [D] (0.2ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e08bb-0c92-bfaa-fcc1-09a569f5c463' [["compute_resource_id", 29]] [sql] [D] (0.1ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."compute_resource_id" = ? AND "hosts"."uuid" = '502e0e31-ff68-3bd6-8bdf-adae3278c599' [["compute_resource_id", 29]] [app] [I] Rendered compute_resources_vms/index/_vmware.html.erb (227.7ms) [app] [I] Rendered compute_resources_vms/index.html.erb within layouts/application (232.9ms) [app] [I] Rendered layouts/_application_content.html.erb (0.9ms) [app] [I] Rendering layouts/base.html.erb [app] [I] Rendered home/_user_dropdown.html.erb (2.1ms) [sql] [D] CACHE (0.0ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') [sql] [D] Organization Load (0.1ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') ORDER BY "taxonomies"."title" ASC [app] [I] Rendered home/_organization_dropdown.html.erb (3.4ms) [sql] [D] CACHE (0.0ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') [sql] [D] Location Load (0.1ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') ORDER BY "taxonomies"."title" ASC [app] [I] Rendered home/_location_dropdown.html.erb (3.9ms) [app] [I] Rendered home/_org_switcher.html.erb (9.0ms) [app] [I] Rendered home/_submenu.html.erb (4.4ms) [app] [I] Rendered home/_submenu.html.erb (3.1ms) [app] [I] Rendered home/_submenu.html.erb (1.6ms) [app] [I] Rendered home/_submenu.html.erb (1.1ms) [app] [I] Rendered home/_submenu.html.erb (1.6ms) [app] [I] Rendered home/_topbar.html.erb (30.2ms) [app] [I] Rendered layouts/base.html.erb (301.4ms) [app] [I] Completed 200 OK in 48608ms (Views: 533.7ms | ActiveRecord: 10.8ms)
No data to display
Actions