Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C337A10CDA for ; Tue, 23 Jul 2013 17:44:50 +0000 (UTC) Received: (qmail 32897 invoked by uid 500); 23 Jul 2013 17:44:50 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 32716 invoked by uid 500); 23 Jul 2013 17:44:50 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 32682 invoked by uid 500); 23 Jul 2013 17:44:49 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 32678 invoked by uid 99); 23 Jul 2013 17:44:49 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Jul 2013 17:44:49 +0000 Date: Tue, 23 Jul 2013 17:44:49 +0000 (UTC) From: "Srikanteswararao Talluri (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CLOUDSTACK-3740) Default CentOS5.6 template is disappearing MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-3740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Srikanteswararao Talluri updated CLOUDSTACK-3740: ------------------------------------------------- Attachment: cloudstack-bugtool_2013.07.24-04.33.52.X9I_29.zip > 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 > Priority: Blocker > Labels: automation > Fix For: 4.2.0 > > Attachments: cloudstack-bugtool_2013.07.24-04.33.52.X9I_29.zip > > > 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