Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 81C7A18B83 for ; Sun, 18 Oct 2015 06:57:05 +0000 (UTC) Received: (qmail 54488 invoked by uid 500); 18 Oct 2015 06:57:05 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 54448 invoked by uid 500); 18 Oct 2015 06:57:05 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 54438 invoked by uid 500); 18 Oct 2015 06:57:05 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 54432 invoked by uid 99); 18 Oct 2015 06:57:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 18 Oct 2015 06:57:05 +0000 Date: Sun, 18 Oct 2015 06:57:05 +0000 (UTC) From: "Nitin Kumar Maharana (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CLOUDSTACK-8962) Dedicated cluster is used for virtual routers that belong to non-dedicated account MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-8962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nitin Kumar Maharana updated CLOUDSTACK-8962: --------------------------------------------- Description: ISSUE ================== A dedicated cluster has been populated with Virtual Routers from domains to which the cluster is not dedicated. The VR belongs to a non-dedicated account should not go to a dedicated cluster. TROUBLESHOOTING ================== >From custoemr system: mysql> select * from dedicated_resources; ----------------------------------------------------------------------------------------------------------------- id uuid data_center_id pod_id cluster_id host_id domain_id account_id affinity_group_id ----------------------------------------------------------------------------------------------------------------- 10 dccf2f43-b9b0-443b-a614-6170cc8c70db NULL NULL 19 NULL 40 NULL 66 12 efdb169f-f74e-493e-b2be-28f6d44fd0b4 9 NULL NULL NULL 7 NULL 144 13 1419d64c-a387-4c6f-8a84-b2f110e291ec 10 NULL NULL NULL 7 NULL 144 16 28d92221-1c8d-45db-8696-dff9795da069 12 NULL NULL NULL 7 NULL 144 ----------------------------------------------------------------------------------------------------------------- mysql> select id from host where cluster_id = 19; ----- id ----- 61 62 101 ----- mysql> select id,name,account_id from vm_instance where host_id in (61,62,101) and removed is null; ---------------------------------------------------- id name account_id ---------------------------------------------------- 6230 8f307c0a-15f5-4262-ad24-54fb9e899700 39 6252 a6cd3afb-4219-45b9-82a9-28b027f3c237 39 6994 r-6994-VM 74 7115 r-7115-VM 128 7119 r-7119-VM 371 7120 r-7120-VM 1 7254 r-7254-VM 128 7257 r-7257-VM 272 7262 r-7262-VM 11 7292 r-7292-VM 402 7304 r-7304-VM 44 7365 r-7365-VM 1 7389 r-7389-VM 1 7559 71532dab-fddb-421a-9565-34e250a3dcdc 39 6111 r-6111-VM 292 6123 r-6123-VM 292 6149 r-6149-VM 301 6151 r-6151-VM 303 6160 r-6160-VM 280 6256 e01fb237-3b18-4978-b91e-f74487187d69 39 6293 r-6293-VM 313 6415 r-6415-VM 272 6529 r-6529-VM 272 6539 r-6539-VM 1 6567 r-6567-VM 1 6600 r-6600-VM 1 6627 r-6627-VM 1 6661 r-6661-VM 1 6670 r-6670-VM 1 6701 r-6701-VM 1 6704 r-6704-VM 227 6746 r-6746-VM 328 6828 r-6828-VM 236 6886 r-6886-VM 348 6895 r-6895-VM 330 6921 r-6921-VM 327 6949 r-6949-VM 272 6989 r-6989-VM 272 7005 r-7005-VM 1 7061 r-7061-VM 227 7077 r-7077-VM 80 7557 0b2beeb1-ae4c-48e1-8299-a0e820a6a146 39 7619 r-7619-VM 359 7620 r-7620-VM 1 6235 6f356186-d53f-4ebe-89e5-796b9d8bf8d7 39 7558 9fb9309c-0a1d-4354-81a1-0ea4abc554c4 39 7674 r-7674-VM 436 7816 r-7816-VM 441 ---------------------------------------------------- mysql> select id as Account,domain_id from account where id in (select account_id from vm_instance where host_id in (61,62,101) and removed is null); ------------------+ Account domain_id ------------------+ 1 1 11 12 39 40 44 45 74 76 80 82 128 116 227 217 236 226 272 253 280 261 292 274 301 286 303 288 313 297 327 310 328 311 330 313 348 331 359 343 371 355 402 393 436 428 441 433 ------------------+ REPRO STEPS ================== was: ISSUE ================== A dedicated cluster has been populated with Virtual Routers from domains to which the cluster is not dedicated. The VR belongs to a non-dedicated account should not go to a dedicated cluster. > Dedicated cluster is used for virtual routers that belong to non-dedicated account > ---------------------------------------------------------------------------------- > > Key: CLOUDSTACK-8962 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8962 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: Management Server > Affects Versions: 4.5.2 > Reporter: Nitin Kumar Maharana > Priority: Blocker > > ISSUE > ================== > A dedicated cluster has been populated with Virtual Routers from domains to which the cluster is not dedicated. > The VR belongs to a non-dedicated account should not go to a dedicated cluster. > TROUBLESHOOTING > ================== > From custoemr system: > mysql> select * from dedicated_resources; > ----------------------------------------------------------------------------------------------------------------- > id uuid data_center_id pod_id cluster_id host_id domain_id account_id affinity_group_id > ----------------------------------------------------------------------------------------------------------------- > 10 dccf2f43-b9b0-443b-a614-6170cc8c70db NULL NULL 19 NULL 40 NULL 66 > 12 efdb169f-f74e-493e-b2be-28f6d44fd0b4 9 NULL NULL NULL 7 NULL 144 > 13 1419d64c-a387-4c6f-8a84-b2f110e291ec 10 NULL NULL NULL 7 NULL 144 > 16 28d92221-1c8d-45db-8696-dff9795da069 12 NULL NULL NULL 7 NULL 144 > ----------------------------------------------------------------------------------------------------------------- > mysql> select id from host where cluster_id = 19; > ----- > id > ----- > 61 > 62 > 101 > ----- > mysql> select id,name,account_id from vm_instance where host_id in (61,62,101) and removed is null; > ---------------------------------------------------- > id name account_id > ---------------------------------------------------- > 6230 8f307c0a-15f5-4262-ad24-54fb9e899700 39 > 6252 a6cd3afb-4219-45b9-82a9-28b027f3c237 39 > 6994 r-6994-VM 74 > 7115 r-7115-VM 128 > 7119 r-7119-VM 371 > 7120 r-7120-VM 1 > 7254 r-7254-VM 128 > 7257 r-7257-VM 272 > 7262 r-7262-VM 11 > 7292 r-7292-VM 402 > 7304 r-7304-VM 44 > 7365 r-7365-VM 1 > 7389 r-7389-VM 1 > 7559 71532dab-fddb-421a-9565-34e250a3dcdc 39 > 6111 r-6111-VM 292 > 6123 r-6123-VM 292 > 6149 r-6149-VM 301 > 6151 r-6151-VM 303 > 6160 r-6160-VM 280 > 6256 e01fb237-3b18-4978-b91e-f74487187d69 39 > 6293 r-6293-VM 313 > 6415 r-6415-VM 272 > 6529 r-6529-VM 272 > 6539 r-6539-VM 1 > 6567 r-6567-VM 1 > 6600 r-6600-VM 1 > 6627 r-6627-VM 1 > 6661 r-6661-VM 1 > 6670 r-6670-VM 1 > 6701 r-6701-VM 1 > 6704 r-6704-VM 227 > 6746 r-6746-VM 328 > 6828 r-6828-VM 236 > 6886 r-6886-VM 348 > 6895 r-6895-VM 330 > 6921 r-6921-VM 327 > 6949 r-6949-VM 272 > 6989 r-6989-VM 272 > 7005 r-7005-VM 1 > 7061 r-7061-VM 227 > 7077 r-7077-VM 80 > 7557 0b2beeb1-ae4c-48e1-8299-a0e820a6a146 39 > 7619 r-7619-VM 359 > 7620 r-7620-VM 1 > 6235 6f356186-d53f-4ebe-89e5-796b9d8bf8d7 39 > 7558 9fb9309c-0a1d-4354-81a1-0ea4abc554c4 39 > 7674 r-7674-VM 436 > 7816 r-7816-VM 441 > ---------------------------------------------------- > mysql> select id as Account,domain_id from account where id in (select account_id from vm_instance where host_id in (61,62,101) and removed is null); > ------------------+ > Account domain_id > ------------------+ > 1 1 > 11 12 > 39 40 > 44 45 > 74 76 > 80 82 > 128 116 > 227 217 > 236 226 > 272 253 > 280 261 > 292 274 > 301 286 > 303 288 > 313 297 > 327 310 > 328 311 > 330 313 > 348 331 > 359 343 > 371 355 > 402 393 > 436 428 > 441 433 > ------------------+ > REPRO STEPS > ================== -- This message was sent by Atlassian JIRA (v6.3.4#6332)