[jira] [Updated] (CLOUDSTACK-6409) Upgrade from 4.2.1 to 4.3.0 failed due to database upgrade script

["Yong Chen (JIRA)" <ji...@apache.org>]

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

Yong Chen updated CLOUDSTACK-6409:
----------------------------------

    Affects Version/s:     (was: 4.2.1)
                       4.3.0

> Upgrade from 4.2.1 to 4.3.0 failed due to database upgrade script
> -----------------------------------------------------------------
>
>                 Key: CLOUDSTACK-6409
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6409
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Upgrade
>    Affects Versions: 4.3.0
>         Environment: CentOS 6.4, MySQL
>            Reporter: Yong Chen
>              Labels: patch
>
> 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)