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

["Rohit Yadav (JIRA)" <ji...@apache.org>]

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

Rohit Yadav closed CLOUDSTACK-6408.
-----------------------------------
    Resolution: Cannot Reproduce

Tried with a clean setup of 4.2.1, deployed a basic zone and upgraded to 4.3.0 and it works for me. Closing as cannot reproduce issue, please reopen if it still is an issue for you.

Were you using ACS 4.2.1 the official release or its build, or using CCP?

> 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
>            Assignee: Kelven Yang
>            Priority: Blocker
>
> This issue is affecting upgrades to 4.3.0. Please have this checked with 4.3.1 release. 
> 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.3.4#6332)