[
https://issues.apache.org/jira/browse/CLOUDSTACK-5742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13867501#comment-13867501
]
prashant kumar mishra commented on CLOUDSTACK-5742:
---------------------------------------------------
Now #cpu,cpu speed and ram is getting updated under usage_type1 and 2.i talked
to kishan ,it is expected behavior so closing it
usage DB
========
mysql> select * from usage_vm_instance where vm_instance_id=7;
+------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+---------------------+-----------+-----------+--------+
| usage_type | zone_id | account_id | vm_instance_id | vm_name |
service_offering_id | template_id | hypervisor_type | start_date |
end_date | cpu_speed | cpu_cores | memory |
+------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+---------------------+-----------+-----------+--------+
| 1 | 1 | 3 | 7 | pkm |
12 | 5 | XenServer | 2014-01-09 16:04:57 | 2014-01-09
16:18:27 | 100 | 1 | 256 |
| 1 | 1 | 3 | 7 | pkm |
12 | 5 | XenServer | 2014-01-09 16:42:18 | 2014-01-09
16:48:30 | 100 | 1 | 256 |
| 1 | 1 | 3 | 7 | pkm |
12 | 5 | XenServer | 2014-01-09 17:31:44 | NULL
| 100 | 1 | 256 |
| 2 | 1 | 3 | 7 | pkm |
12 | 5 | XenServer | 2014-01-09 16:03:06 | NULL
| 100 | 1 | 256 |
+------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+---------------------+-----------+-----------+--------+
4 rows in set (0.01 sec)
> #cpu,cpu speed, and ram is getting updated under wrong usage_type(2) for
> dynamic compute offering in usage_vm_instance table
> ----------------------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-5742
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5742
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.3.0
> Reporter: prashant kumar mishra
> Assignee: Bharat Kumar
> Priority: Critical
> Fix For: 4.3.0
>
> Attachments: LOG_DB.rar
>
>
> STEPS TO REPO
> ==============
> 1-prepare a CS setup 4.3
> 2-deploy a vm with small CO
> 3-Change the vm CO to dynamic CO.
> 4-check the usage_vm_instance table after cloud_usage db synch
> EXPECTED
> =========
> cpu and ram should get updated under usage type 1
> ACTUAL
> =======
> cpu and ram is getting updated under usage type2
> DB
> ===
> | 2 | 1 | 2 | 8 | test |
> 12 | 202 | XenServer | 2014-01-03 10:10:15 | NULL
> | 100 | 1 | 256 |
> | 1 | 1 | 2 | 8 | test |
> 12 | 202 | XenServer | 2014-01-03 10:11:21 | NULL
> | NULL | NULL | NULL |
> +------------+---------+------------+----------------+---------+---------------------+-------------+-----------------+---------------------+---------------------+-----------+-----------+--------+
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
