cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yong Chen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CLOUDSTACK-6408) Upgrade from 4.2.1 to 4.3.0 failed due to database upgrade script
Date Wed, 23 Apr 2014 04:55:19 GMT

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

Yong Chen updated CLOUDSTACK-6408:
----------------------------------

    Priority: Blocker  (was: Major)

> Upgrade from 4.2.1 to 4.3.0 failed due to database upgrade script
> -----------------------------------------------------------------
>
>                 Key: CLOUDSTACK-6408
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6408
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Upgrade
>    Affects Versions: 4.3.1
>         Environment: CentOS 6.4, MySQL
>            Reporter: Yong Chen
>            Priority: Blocker
>
> Upgrade failed due to SQL upgrade script for 421-to-430 tries to add many columns and
tables that are exist already in 4.2.1. 
> Tried to modify DB manually (see below SQL commands) to satisfy the upgrade script. However
it seems there are a lot more than a few. This upgrade script needs to be reviewed to be able
to detect existence of columns and tables or remove them if needed rather than fail.
> ALTER TABLE async_job CHANGE related session_key INT;
> ALTER TABLE async_job ADD job_cmd_originator INT;
> ALTER TABLE async_job ADD callback_type INT;
> ALTER TABLE async_job ADD callback_address INT;
> ALTER TABLE async_job DROP job_type;
> ALTER TABLE async_job DROP job_dispatcher;
> ALTER TABLE async_job DROP job_executing_msid;
> ALTER TABLE async_job DROP job_pending_signals;
> ALTER TABLE network_offerings DROP keep_alive_enabled;
> ALTER TABLE vm_instance DROP power_state;
> ALTER TABLE vm_instance DROP power_state_update_time;
> ALTER TABLE vm_instance DROP power_state_update_count;
> ALTER TABLE vm_instance DROP FOREIGN KEY fk_vm_instance__power_host;
> ALTER TABLE vm_instance DROP power_host;
> ALTER TABLE load_balancing_rules DROP lb_protocol;
> DROP TABLE vm_work_job;
> DROP TABLE async_job_journal;
> DROP TABLE async_job_join_map;
> ALTER TABLE configuration DROP default_value;



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message