Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Date: Fri, 9 Dec 2016 10:03:58 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.12896093.1443096043000.481959.1481277838408@Atlassian.JIRA>
In-Reply-To: <JIRA.12896093.1443096043000@Atlassian.JIRA>
References: <JIRA.12896093.1443096043000@Atlassian.JIRA> <JIRA.12896093.1443096043390@arcas>
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, 09 Dec 2016 10:04:00 -0000


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

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

Github user yvsubhash commented on the issue:

    https://github.com/apache/cloudstack/pull/896
  
    @rhtyd Can you plz merge this?


> 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)