[
https://issues.apache.org/jira/browse/CLOUDSTACK-6408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14042433#comment-14042433
]
Animesh Chaturvedi commented on CLOUDSTACK-6408:
------------------------------------------------
Kelven can you check on this?
> 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.2#6252)
