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 6140B10746 for ; Thu, 1 Aug 2013 16:19:56 +0000 (UTC) Received: (qmail 93790 invoked by uid 500); 1 Aug 2013 16:19:50 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 93692 invoked by uid 500); 1 Aug 2013 16:19:49 -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 93665 invoked by uid 500); 1 Aug 2013 16:19:49 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 93661 invoked by uid 99); 1 Aug 2013 16:19:49 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Aug 2013 16:19:49 +0000 Date: Thu, 1 Aug 2013 16:19:49 +0000 (UTC) From: "Abhinav Roy (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CLOUDSTACK-4015) [Upgrade][2.2.16 to 4.2] Invalid DB entry after upgrade MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Abhinav Roy created CLOUDSTACK-4015: --------------------------------------- Summary: [Upgrade][2.2.16 to 4.2] Invalid DB entry after upgrade Key: CLOUDSTACK-4015 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4015 Project: CloudStack Issue Type: Bug Security Level: Public (Anyone can view this level - this is the default.) Components: Upgrade Affects Versions: 4.2.0 Reporter: Abhinav Roy Priority: Critical Fix For: 4.2.0 After upgrade from 2.2.16 to 4.2 there is a invalid entry in the DB. mysql> select * from vm_template where id=205; +-----+--------------------------------------------+---------------------------------------+--------+----------+---------+-----+------+------------------------------------------------------------------------------------------+-------------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+--------------------------------------+---------------+----------+-------------+-----------+--------------+---------+----------------------+ | id | unique_name | name | public | featured | type | hvm | bits | url | format | created | removed | account_id | checksum | display_text | enable_password | guest_os_id | bootable | prepopulate | cross_zones | extractable | hypervisor_type | source_template_id | template_tag | uuid | enable_sshkey | sort_key | size | state | update_count | updated | dynamically_scalable | +-----+--------------------------------------------+---------------------------------------+--------+----------+---------+-----+------+------------------------------------------------------------------------------------------+-------------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+--------------------------------------+---------------+----------+-------------+-----------+--------------+---------+----------------------+ | 205 | systemvm-vmware-3.0.5 | systemvm-vmware-3.0.5 | 1 | 1 | SYSTEM | 0 | 64 | fake url | fake format | 2013-07-31 16:11:01 | NULL | 1 | NULL | fake text | 0 | 99 | 1 | 0 | 1 | 0 | VMware | NULL | NULL | 205 | 0 | 0 | NULL | Allocated | 0 | NULL | 0 | -------------------------------------------------------------------+-------------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+--------------------------------------+---------------+----------+-------------+-----------+--------------+---------+----------------------+ mysql> SELECT * FROM cloud.template_store_ref; +----+----------+-------------+---------------------+---------------------+--------------------------------------+--------------+-------------+------------+---------------+----------------+----------------------------------------------------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------+------------------------------------------------------------------------------------------+--------------+----------------------+-------+-----------+---------+--------------+---------+---------------------+ | id | store_id | template_id | created | last_updated | job_id | download_pct | size | store_role | physical_size | download_state | error_str | local_path | install_path | url | download_url | download_url_created | state | destroyed | is_copy | update_count | ref_cnt | updated | +----+----------+-------------+---------------------+---------------------+--------------------------------------+--------------+-------------+------------+---------------+----------------+----------------------------------------------------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------+------------------------------------------------------------------------------------------+--------------+----------------------+-------+-----------+---------+--------------+---------+---------------------+ | NULL | NULL | Ready | 0 | 0 | 2 | 0 | 2013-08-01 09:08:01 | | 27 | 3 | 205 | 2013-08-01 10:44:25 | 2013-08-01 10:44:25 | NULL | 100 | 0 | Image | 0 | DOWNLOADED | NULL | NULL | template/tmpl/1/205/ | fake url | NULL | NULL | Ready | 0 | 0 | 0 | 0 | NULL | Here we see that the template_id =205 was added by itself, not added manually before/after upgrade. Now this leads to an issue when we try to add a vmware host (in a zone or cluster) , because it tries to pick from this template but never finds it. -- 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