You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Nitin Kumar Maharana (JIRA)" <ji...@apache.org> on 2015/10/18 08:57:05 UTC
[jira] [Updated] (CLOUDSTACK-8962) Dedicated cluster is used for
virtual routers that belong to non-dedicated account
[ 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)