Bharat Kumar created CLOUDSTACK-970:
---------------------------------------

             Summary: when a template is deleted and then copied over again , 
it is still marked as "Removed" in template_zone_ref table.
                 Key: CLOUDSTACK-970
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-970
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Template
    Affects Versions: 4.0.0
            Reporter: Bharat Kumar
            Assignee: Bharat Kumar
             Fix For: 4.1.0


Steps to reproduce the problem: 

Have a set up with 2 zones. 
Create a template1 for zone1. 

Initiate copytemplate for this template to zone2. 

Delete this template from zone2. 

Initiate copytemplate for this template(from zone1) to zone2 copy. 

Copy gets initiated successfully and it gets copied as well. 

But this template is marked as "Removed" in template_zone_ref and is not seen 
in "My Templates" list view. 


After creation of zone2 template: 

mysql> select * from template_zone_ref where template_id = 219; 
+----+---------+-------------+---------------------+---------------------+---------+
 
| id | zone_id | template_id | created | last_updated | removed | 
+----+---------+-------------+---------------------+---------------------+---------+
 
| 43 | 1 | 219 | 2012-04-27 15:08:07 | 2012-04-27 15:08:07 | NULL | 
| 47 | 2 | 219 | 2012-04-27 16:58:46 | 2012-04-27 16:58:46 | NULL | 
+----+---------+-------------+---------------------+---------------------+---------+
 
2 rows in set (0.00 sec) 

After deletion of zone2 template: 

mysql> select * from template_zone_ref where template_id = 219; 
+----+---------+-------------+---------------------+---------------------+---------------------+
 
| id | zone_id | template_id | created | last_updated | removed | 
+----+---------+-------------+---------------------+---------------------+---------------------+
 
| 43 | 1 | 219 | 2012-04-27 15:08:07 | 2012-04-27 15:08:07 | NULL | 
| 47 | 2 | 219 | 2012-04-27 16:58:46 | 2012-04-27 16:58:46 | 2012-04-27 
18:49:54 | 
+----+---------+-------------+---------------------+---------------------+---------------------+
 
2 rows in set (0.00 sec) 


After re copying of zone2 template: 

mysql> select * from template_zone_ref where template_id = 219; 
+----+---------+-------------+---------------------+---------------------+---------------------+
 
| id | zone_id | template_id | created | last_updated | removed | 
+----+---------+-------------+---------------------+---------------------+---------------------+
 
| 43 | 1 | 219 | 2012-04-27 15:08:07 | 2012-04-27 15:08:07 | NULL | 
| 47 | 2 | 219 | 2012-04-27 16:58:46 | 2012-04-27 18:50:51 | 2012-04-27 
18:50:51 | 
+----+---------+-------------+---------------------+---------------------+---------------------+
 


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to