cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhinav Roy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-4015) [Upgrade][2.2.16 to 4.2] Invalid DB entry after upgrade
Date Thu, 01 Aug 2013 16:19:49 GMT
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

Mime
View raw message