You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Prasanna Santhanam (JIRA)" <ji...@apache.org> on 2013/07/23 09:24:55 UTC
[jira] [Created] (CLOUDSTACK-3727) Resource Count calculation
happens for deleted accounts on restart of managment server
Prasanna Santhanam created CLOUDSTACK-3727:
----------------------------------------------
Summary: Resource Count calculation happens for deleted accounts on restart of managment server
Key: CLOUDSTACK-3727
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3727
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Reporter: Prasanna Santhanam
On reboot of management server we see the resource_count calculation happening
for accounts that have been deleted from cloudstack. This can be optimized to
happen only for active accounts
2013-07-23 12:50:03,388 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) resource_count table has records missing for some accounts...going to insert them
2013-07-23 12:50:03,405 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type user_vm for account id=3
2013-07-23 12:50:03,408 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type public_ip for account id=3
2013-07-23 12:50:03,410 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type volume for account id=3
2013-07-23 12:50:03,411 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type snapshot for account id=3
2013-07-23 12:50:03,412 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type template for account id=3
2013-07-23 12:50:03,413 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type project for account id=3
2013-07-23 12:50:03,414 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type network for account id=3
2013-07-23 12:50:03,415 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type vpc for account id=3
2013-07-23 12:50:03,417 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type cpu for account id=3
2013-07-23 12:50:03,418 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type memory for account id=3
2013-07-23 12:50:03,419 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type primary_storage for account id=3
2013-07-23 12:50:03,420 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type secondary_storage for account id=3
2013-07-23 12:50:03,426 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type user_vm for account id=4
2013-07-23 12:50:03,427 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type public_ip for account id=4
2013-07-23 12:50:03,428 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type volume for account id=4
2013-07-23 12:50:03,429 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type snapshot for account id=4
2013-07-23 12:50:03,431 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type template for account id=4
2013-07-23 12:50:03,432 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type project for account id=4
2013-07-23 12:50:03,433 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type network for account id=4
2013-07-23 12:50:03,435 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type vpc for account id=4
2013-07-23 12:50:03,436 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type cpu for account id=4
2013-07-23 12:50:03,437 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type memory for account id=4
2013-07-23 12:50:03,439 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type primary_storage for account id=4
2013-07-23 12:50:03,440 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type secondary_storage for account id=4
2013-07-23 12:50:03,444 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type user_vm for account id=5
2013-07-23 12:50:03,445 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type public_ip for account id=5
2013-07-23 12:50:03,446 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type volume for account id=5
2013-07-23 12:50:03,447 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type snapshot for account id=5
2013-07-23 12:50:03,449 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type template for account id=5
2013-07-23 12:50:03,450 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type project for account id=5
2013-07-23 12:50:03,451 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type network for account id=5
2013-07-23 12:50:03,452 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type vpc for account id=5
2013-07-23 12:50:03,453 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type cpu for account id=5
2013-07-23 12:50:03,453 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type memory for account id=5
2013-07-23 12:50:03,455 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type primary_storage for account id=5
2013-07-23 12:50:03,456 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type secondary_storage for account id=5
2013-07-23 12:50:03,459 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type user_vm for account id=6
2013-07-23 12:50:03,461 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type public_ip for account id=6
2013-07-23 12:50:03,462 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type volume for account id=6
2013-07-23 12:50:03,463 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type snapshot for account id=6
2013-07-23 12:50:03,464 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type template for account id=6
2013-07-23 12:50:03,465 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type project for account id=6
2013-07-23 12:50:03,466 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type network for account id=6
2013-07-23 12:50:03,467 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type vpc for account id=6
2013-07-23 12:50:03,469 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type cpu for account id=6
2013-07-23 12:50:03,470 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type memory for account id=6
2013-07-23 12:50:03,472 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type primary_storage for account id=6
2013-07-23 12:50:03,473 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type secondary_storage for account id=6
2013-07-23 12:50:03,477 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type user_vm for account id=7
2013-07-23 12:50:03,478 DEBUG [cloud.server.ConfigurationServerImpl] (Timer-2:null) Inserting resource count of type public_ip for account id=7
mysql> select id, account_name, uuid, type, state, removed from account where id in (4,5,6,7);
+----+--------------------------------------------------------------------------------+--------------------------------------+------+---------+---------------------+
| id | account_name | uuid | type | state | removed |
+----+--------------------------------------------------------------------------------+--------------------------------------+------+---------+---------------------+
| 4 | admin-XABU1-TestSharedNetworks-test_createSharedNetwork_All-EFXGOV | 27b58c4b-91f7-43c8-b42c-3884726edbd4 | 0 | enabled | 2013-07-23 07:16:58 |
| 5 | admin-XABU1-TestSharedNetworks-test_createSharedNetwork_accountSpecific-R40D3U | 51db8dfc-c0c4-442f-aeaa-55b7c4f9aa76 | 2 | enabled | 2013-07-23 06:21:29 |
| 6 | admin-XABU1-TestSharedNetworks-test_createSharedNetwork_accountSpecific-EOTNPX | ae603f09-5d02-4443-b7d4-b5b3d3449733 | 0 | enabled | 2013-07-23 06:21:34 |
| 7 | admin-XABU1-TestSharedNetworks-test_createSharedNetwork_domainSpecific-N8PR5B | eb7a3a69-09bf-472c-9b4b-5f688d8656aa | 2 | enabled | 2013-07-23 06:23:10 |
+----+--------------------------------------------------------------------------------+--------------------------------------+------+---------+---------------------+
4 rows in set (0.00 sec)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira