[
https://issues.apache.org/jira/browse/CLOUDSTACK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14933654#comment-14933654
]
ASF GitHub Bot commented on CLOUDSTACK-8908:
--------------------------------------------
GitHub user yvsubhash opened a pull request:
https://github.com/apache/cloudstack/pull/896
CLOUDSTACK-8908 After copying the template charging for that template is
getting stopped
This is happening as the zone id is not part of the query. Zone id is
added to the query and unit tests are also added
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/yvsubhash/cloudstack CLOUDSTACK-8908
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/cloudstack/pull/896.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #896
----
commit 3f99d42de9560005d6a2996f307f5dd7f45b8b4d
Author: subhash yedugundla <[email protected]>
Date: 2015-09-28T17:35:43Z
CLOUDSTACK-8908 After copying the template charging for that template is
stopped
----
> After copying the template charging for that template is stopped
> -----------------------------------------------------------------
>
> Key: CLOUDSTACK-8908
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8908
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Template, Usage
> Affects Versions: 4.5.2
> Reporter: subhash yedugundla
>
> [Repro Steps]
> Register a template in Zone 1 .
> Copy the template from Zone 1 to Zone 2 .
> Once copied, deleted the template from Zone 1.
> Check the charging of the template and found that charging of the template
> in Zone 2 stopped
> Sample data related to the issue
> mysql> select id,type,state,description,created from event where description
> like "%4186%" and type like "%template%";
> +---------+-----------------+-----------+-----------------------------------------------------------------------------------------+---------------------+
>
> | id | type | state | description | created |
> +---------+-----------------+-----------+-----------------------------------------------------------------------------------------+---------------------+
>
> | 1964466 | TEMPLATE.CREATE | Completed | Successfully completed creating
> template. Id: 4186 name: PerfTestVM2 | 2015-06-15 09:48:57 |
> | 2411011 | TEMPLATE.COPY | Scheduled | copying template: 4186 from zone: 3
> to zone: 1 | 2015-07-22 03:57:32 |
> | 2411012 | TEMPLATE.COPY | Started | copying template. copying template:
> 4186 from zone: 3 to zone: 1 | 2015-07-22 03:57:32 |
> | 2411458 | TEMPLATE.COPY | Completed | Successfully completed copying
> template. copying template: 4186 from zone: 3 to zone: 1 | 2015-07-22
> 04:47:08 |
> | 2412521 | TEMPLATE.DELETE | Scheduled | Deleting template 4186 | 2015-07-22
> 06:46:18 |
> | 2412522 | TEMPLATE.DELETE | Started | deleting template. Template Id: 4186
> | 2015-07-22 06:46:18 |
> | 2412523 | TEMPLATE.DELETE | Completed | Successfully completed deleting
> template. Template Id: 4186 | 2015-07-22 06:46:18 |
> +---------+-----------------+-----------+-----------------------------------------------------------------------------------------+---------------------+
>
> You can see that the template of zone3 is not removed.
> mysql> select * from template_zone_ref where template_id=4186;;
> +------+---------+-------------+---------------------+---------------------+---------------------+
>
> | id | zone_id | template_id | created | last_updated | removed |
> +------+---------+-------------+---------------------+---------------------+---------------------+
>
> | 3974 | 3 | 4186 | 2015-06-15 09:48:57 | 2015-06-15 09:48:57 | NULL |
> <=====Not removed
> | 4845 | 1 | 4186 | 2015-07-22 04:47:08 | 2015-07-22 04:47:08 | 2015-07-22
> 06:46:18 |
> +------+---------+-------------+---------------------+---------------------+---------------------+
>
> However, not only Zone1 but also the charging of the template of Zone3
> stopped.
> +---------+---------------------+---------------------+---------+----------------------------------------------------------+---------------+--------------------+----------+-------------+
>
> | id | start_date | end_date | zone_id | description | usage_display |
> raw_usage | usage_id | size |
> +---------+---------------------+---------------------+---------+----------------------------------------------------------+---------------+--------------------+----------+-------------+
>
> | 5998486 | 2015-06-14 15:00:00 | 2015-06-15 14:59:59 | 3 | Template Id:4186
> Size:14995087360VirtualSize:16106127360 | 4.808055 Hrs | 4.808055400848389 |
> 4186 | 14995087360 |
> =====================an abbreviation============================
> 4186 | 14995087360 |
> | 7834096 | 2015-07-19 15:00:00 | 2015-07-20 14:59:59 | 3 | Template Id:4186
> Size:14995087360VirtualSize:16106127360 | 24 Hrs | 24 | 4186 | 14995087360 |
> | 7889426 | 2015-07-20 15:00:00 | 2015-07-21 14:59:59 | 3 | Template Id:4186
> Size:14995087360VirtualSize:16106127360 | 24 Hrs | 24 | 4186 | 14995087360 |
> | 7945799 | 2015-07-21 15:00:00 | 2015-07-22 14:59:59 | 3 | Template Id:4186
> Size:14995087360VirtualSize:16106127360 | 15.771667 Hrs | 15.771666526794434
> | 4186 | 14995087360 |
> | 7945801 | 2015-07-21 15:00:00 | 2015-07-22 14:59:59 | 1 | Template Id:4186
> Size:14995087360VirtualSize:16106127360 | 1.986111 Hrs | 1.9861112833023071 |
> 4186 | 14995087360 |
> +---------+---------------------+---------------------+---------+----------------------------------------------------------+---------------+--------------------+----------+-------------+
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
