[ 
https://issues.apache.org/jira/browse/CLOUDSTACK-3740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Animesh Chaturvedi updated CLOUDSTACK-3740:
-------------------------------------------


These blockers and critical issues are resolved but not verified. Reporters of 
these issues please verify the fixes and help close these issues
                
> Default CentOS5.6 template is disappearing
> ------------------------------------------
>
>                 Key: CLOUDSTACK-3740
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3740
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the 
> default.) 
>          Components: Management Server
>    Affects Versions: 4.2.0
>         Environment: xenserver,
>            Reporter: Srikanteswararao Talluri
>            Assignee: Nitin Mehta
>            Priority: Blocker
>              Labels: automation
>             Fix For: 4.2.0
>
>         Attachments: cloud.sql, 
> cloudstack-bugtool_2013.07.24-04.33.52.X9I_29.zip, management-server.log
>
>
> Steps to reproduce:
> ==============
> I couldn't find exact steps to reproduce this issue, however, when two zones 
> are setup and did some operations on SSVM like reboot, stop , default CentOS 
> 5.6 template of the first is disappearing. This is happening after BVT has 
> progressed for  a while.
> mysql> select * from template_zone_ref;
> +----+---------+-------------+---------------------+---------------------+---------------------+
> | id | zone_id | template_id | created             | last_updated        | 
> removed             |
> +----+---------+-------------+---------------------+---------------------+---------------------+
> |  1 |       1 |           1 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  2 |       1 |           2 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  3 |       1 |           3 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  4 |       1 |           4 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  5 |       1 |           5 | 2013-07-23 21:18:41 | 2013-07-23 21:42:02 | 
> NULL                |
> |  6 |       1 |           7 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  7 |       1 |           8 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  8 |       1 |           9 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  9 |       1 |          10 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> | 10 |       2 |           1 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 11 |       2 |           2 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 12 |       2 |           3 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 13 |       2 |           4 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 14 |       2 |           5 | 2013-07-23 21:19:40 | 2013-07-23 21:25:33 | 
> NULL                |
> | 15 |       2 |           7 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 16 |       2 |           8 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 17 |       2 |           9 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 18 |       2 |          10 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 19 |       1 |         202 | 2013-07-23 21:43:26 | 2013-07-23 21:43:26 | 
> 2013-07-23 21:44:28 |
> | 20 |       1 |         203 | 2013-07-23 21:44:33 | 2013-07-23 21:44:33 | 
> 2013-07-23 21:46:35 |
> | 21 |       1 |         204 | 2013-07-23 21:45:34 | 2013-07-23 21:45:34 | 
> NULL                |
> | 22 |       2 |         204 | 2013-07-23 21:47:59 | 2013-07-23 21:47:59 | 
> 2013-07-23 21:49:02 |
> +----+---------+-------------+---------------------+---------------------+---------------------+
> 22 rows in set (0.00 sec)
> Then i tried to copy the default CentOS5.6 template from second zone to first 
> zone , then template with id=5 is marked as removed in db.
> mysql> select * from template_zone_ref;
> +----+---------+-------------+---------------------+---------------------+---------------------+
> | id | zone_id | template_id | created             | last_updated        | 
> removed             |
> +----+---------+-------------+---------------------+---------------------+---------------------+
> |  1 |       1 |           1 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  2 |       1 |           2 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  3 |       1 |           3 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  4 |       1 |           4 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  5 |       1 |           5 | 2013-07-23 21:18:41 | 2013-07-23 22:50:47 | 
> 2013-07-23 22:47:50 |
> |  6 |       1 |           7 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  7 |       1 |           8 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  8 |       1 |           9 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> |  9 |       1 |          10 | 2013-07-23 21:18:41 | 2013-07-23 21:18:41 | 
> NULL                |
> | 10 |       2 |           1 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 11 |       2 |           2 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 12 |       2 |           3 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 13 |       2 |           4 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 14 |       2 |           5 | 2013-07-23 21:19:40 | 2013-07-23 21:25:33 | 
> NULL                |
> | 15 |       2 |           7 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 16 |       2 |           8 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 17 |       2 |           9 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 18 |       2 |          10 | 2013-07-23 21:19:40 | 2013-07-23 21:19:40 | 
> NULL                |
> | 19 |       1 |         202 | 2013-07-23 21:43:26 | 2013-07-23 21:43:26 | 
> 2013-07-23 21:44:28 |
> | 20 |       1 |         203 | 2013-07-23 21:44:33 | 2013-07-23 21:44:33 | 
> 2013-07-23 21:46:35 |
> | 21 |       1 |         204 | 2013-07-23 21:45:34 | 2013-07-23 21:45:34 | 
> NULL                |
> | 22 |       2 |         204 | 2013-07-23 21:47:59 | 2013-07-23 21:47:59 | 
> 2013-07-23 21:49:02 |
> +----+---------+-------------+---------------------+---------------------+---------------------+

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