[ https://issues.apache.org/jira/browse/CLOUDSTACK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15736189#comment-15736189 ]
ASF subversion and git services commented on CLOUDSTACK-8908: ------------------------------------------------------------- Commit a13ee852af55be346ab836cdf3fc9fb630eb75fc in cloudstack's branch refs/heads/4.9 from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=a13ee85 ] Merge pull request #896 from yvsubhash/CLOUDSTACK-8908 CLOUDSTACK-8908 After copying the template charging for that template is getting stoppedThis 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 * pr/896: CLOUDSTACK-8908 After copying the template charging for that template is stopped Signed-off-by: Rohit Yadav <rohit.ya...@shapeblue.com> > 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)