Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Date: Fri, 15 Dec 2017 12:46:00 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.12896093.1443096043000.468182.1513341960170@Atlassian.JIRA>
In-Reply-To: <JIRA.12896093.1443096043000@Atlassian.JIRA>
References: <JIRA.12896093.1443096043000@Atlassian.JIRA> <JIRA.12896093.1443096043390@jira-lw-us.apache.org>
Subject: [jira] [Commented] (CLOUDSTACK-8908) After copying the template
 charging for that template is stopped
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 15 Dec 2017 12:46:04 -0000


    [ https://issues.apache.org/jira/browse/CLOUDSTACK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16292457#comment-16292457 ] 

ASF GitHub Bot commented on CLOUDSTACK-8908:
--------------------------------------------

blueorangutan commented on issue #2308: CLOUDSTACK-8908 After copying the template charging for that template is stopped
URL: https://github.com/apache/cloudstack/pull/2308#issuecomment-351997232
 
 
   @rhtyd a Jenkins job has been kicked to build packages. I'll keep you posted as I make progress.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> 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.4.14#64029)