[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-4716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

prashant kumar mishra closed CLOUDSTACK-4716.
---------------------------------------------


tested in upgrade setup passed

DB
-----
mysql> select * from version;
+----+----------------------+---------------------+----------+
| id | version              | updated             | step     |
+----+----------------------+---------------------+----------+
|  1 | 3.0.5.20120904142539 | 2013-11-11 19:43:20 | Complete |
|  2 | 3.0.6                | 2013-11-11 15:52:14 | Complete |
|  3 | 3.0.7                | 2013-11-11 15:52:14 | Complete |
|  4 | 4.1.0                | 2013-11-11 15:52:14 | Complete |
|  5 | 4.2.0                | 2013-11-11 15:52:14 | Complete |
|  6 | 4.2.1                | 2013-11-11 17:14:29 | Complete |
+----+----------------------+---------------------+----------+
6 rows in set (0.00 sec)


mysql> select * from resource_count where account_id in (2,3);
+----+------------+-----------+-------------------+-------------+
| id | account_id | domain_id | type              | count       |
+----+------------+-----------+-------------------+-------------+
| 17 |          2 |      NULL | user_vm           |           1 |
| 18 |          2 |      NULL | public_ip         |           1 |
| 19 |          2 |      NULL | volume            |           2 |
| 20 |          2 |      NULL | snapshot          |           0 |
| 21 |          2 |      NULL | template          |           1 |
| 22 |          2 |      NULL | project           |           0 |
| 23 |          2 |      NULL | network           |           1 |
| 24 |          2 |      NULL | vpc               |           0 |
| 25 |          3 |      NULL | user_vm           |           1 |
| 26 |          3 |      NULL | public_ip         |           1 |
| 27 |          3 |      NULL | volume            |           1 |
| 28 |          3 |      NULL | snapshot          |           0 |
| 29 |          3 |      NULL | template          |           1 |
| 30 |          3 |      NULL | project           |           0 |
| 31 |          3 |      NULL | network           |           1 |
| 32 |          3 |      NULL | vpc               |           0 |
| 41 |          2 |      NULL | cpu               |           1 |
| 42 |          2 |      NULL | memory            |        2048 |
| 43 |          2 |      NULL | primary_storage   | 42949672960 |
| 44 |          2 |      NULL | secondary_storage |  2097152000 |
| 45 |          3 |      NULL | cpu               |           1 |
| 46 |          3 |      NULL | memory            |        2048 |
| 47 |          3 |      NULL | primary_storage   | 21474836480 |
| 48 |          3 |      NULL | secondary_storage | 10737418240 |
+----+------------+-----------+-------------------+-------------+
24 rows in set (0.00 sec)



> (Upgrade) resource_count table is not updated after upgrade to 4.2
> ------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-4716
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4716
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the 
> default.) 
>    Affects Versions: 4.2.0
>            Reporter: Wei Zhou
>            Assignee: Wei Zhou
>             Fix For: 4.2.1
>
>
> Some resource type (cpu, memory, primary_storage, secondary_storage) are 
> introduced in 4.2.0.
> They should be calculated and updated to resource_count table in the upgrade



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Reply via email to