Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 236D811A20 for ; Tue, 9 Sep 2014 16:15:29 +0000 (UTC) Received: (qmail 98906 invoked by uid 500); 9 Sep 2014 16:15:28 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 98874 invoked by uid 500); 9 Sep 2014 16:15:28 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 98862 invoked by uid 500); 9 Sep 2014 16:15:28 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 98857 invoked by uid 99); 9 Sep 2014 16:15:28 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Sep 2014 16:15:28 +0000 Date: Tue, 9 Sep 2014 16:15:28 +0000 (UTC) From: "Siavash Safi (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-7521) DB migration from 4.2.1 to 4.4.0 fails MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-7521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14127165#comment-14127165 ] Siavash Safi commented on CLOUDSTACK-7521: ------------------------------------------ I'm using the 4.2.1 package from the same repository: {noformat} ~# apt-cache show cloudstack-management Package: cloudstack-management Priority: extra Section: libs Installed-Size: 148538 Maintainer: Wido den Hollander Architecture: all Source: cloudstack Version: 4.2.1 Depends: cloudstack-common (= 4.2.1), tomcat6, sysvinit-utils, sudo, jsvc, python-mysqldb, python-paramiko, augeas-tools Conflicts: cloud-client, cloud-client-ui, cloud-server Filename: dists/precise/4.2/pool/cloudstack-management_4.2.1_all.deb Size: 138050662 MD5sum: 86a004b47c04553746d7c17c1fdf4001 SHA1: ea05a1420e2fa116cfbfac955ca7649933508274 SHA256: 62052bb12bfa1dc9eea9b06ff58eff6061bfbb4f6863b4be5c040600a1532286 SHA512: b651ed6147760db1ae1dad8a29586bb28d37b6190ef593536806e3782e429f9e65285e4ab23d26d609a7d9eee591da27810c0b9a3d06c8fdb61640e241c9a442 Description: CloudStack server library The CloudStack management server Homepage: http://www.cloudstack.org/ {noformat} I tried dropping that table but then it complained about another table. Note: I pasted a wrong output when I logged the issue. It's updated now. > DB migration from 4.2.1 to 4.4.0 fails > -------------------------------------- > > Key: CLOUDSTACK-7521 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7521 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: Management Server > Affects Versions: 4.4.0 > Reporter: Siavash Safi > Priority: Blocker > Attachments: management-server.log > > > I tried to upgrade the management server on ubuntu from 4.2.1 to 4.4.0 but it fails to start. > After checking syslog I noticed an exception related to DB migration. > Here is the mysql error output when trying to run migration schema manually: > {noformat} > root@server:/etc/cloudstack/management# mysql -f -u cloud -p cloud < /usr/share/cloudstack-management/setup/db/schema-421to430.sql > Enter password: > ERROR 1060 (42S21) at line 25: Duplicate column name 'related' > ERROR 1091 (42000) at line 26: Can't DROP 'session_key'; check that column/key exists > ERROR 1091 (42000) at line 27: Can't DROP 'job_cmd_originator'; check that column/key exists > ERROR 1091 (42000) at line 28: Can't DROP 'callback_type'; check that column/key exists > ERROR 1091 (42000) at line 29: Can't DROP 'callback_address'; check that column/key exists > ERROR 1060 (42S21) at line 31: Duplicate column name 'job_type' > ERROR 1060 (42S21) at line 32: Duplicate column name 'job_dispatcher' > ERROR 1060 (42S21) at line 33: Duplicate column name 'job_executing_msid' > ERROR 1060 (42S21) at line 34: Duplicate column name 'job_pending_signals' > ERROR 1060 (42S21) at line 36: Duplicate column name 'keep_alive_enabled' > ERROR 1060 (42S21) at line 38: Duplicate column name 'power_state' > ERROR 1060 (42S21) at line 39: Duplicate column name 'power_state_update_time' > ERROR 1060 (42S21) at line 40: Duplicate column name 'power_state_update_count' > ERROR 1060 (42S21) at line 41: Duplicate column name 'power_host' > ERROR 1005 (HY000) at line 42: Can't create table 'cloud.#sql-12ce_27f86f3' (errno: 121) > ERROR 1060 (42S21) at line 44: Duplicate column name 'lb_protocol' > ERROR 1060 (42S21) at line 117: Duplicate column name 'default_value' > ERROR 1060 (42S21) at line 118: Duplicate column name 'updated' > ERROR 1060 (42S21) at line 119: Duplicate column name 'scope' > ERROR 1060 (42S21) at line 120: Duplicate column name 'is_dynamic' > ERROR 1060 (42S21) at line 125: Duplicate column name 'state' > ERROR 1060 (42S21) at line 126: Duplicate column name 'hv_ss_reserve' > ERROR 1060 (42S21) at line 128: Duplicate column name 'hv_ss_reserve' > ERROR 1060 (42S21) at line 139: Duplicate column name 'vpc_id' > ERROR 1060 (42S21) at line 141: Duplicate column name 'passive' > ERROR 1060 (42S21) at line 508: Duplicate column name 'cpu_sockets' > ERROR 1060 (42S21) at line 509: Duplicate column name 'hyperv_network_label' > ERROR 1060 (42S21) at line 594: Duplicate column name 'display' > ERROR 1054 (42S22) at line 595: Unknown column 'display_detail' in 'network_details' > ERROR 1060 (42S21) at line 596: Duplicate column name 'display' > ERROR 1054 (42S22) at line 597: Unknown column 'display_detail' in 'volume_details' > ERROR 1054 (42S22) at line 598: Unknown column 'display_detail' in 'nic_details' > ERROR 1054 (42S22) at line 599: Unknown column 'display_detail' in 'user_vm_details' > ERROR 1060 (42S21) at line 600: Duplicate column name 'display' > ERROR 1060 (42S21) at line 601: Duplicate column name 'display' > ERROR 1064 (42000) at line 634: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--insert into cloud.monitoring_services(id, uuid, service, process_name, service' at line 1 > ERROR 1064 (42000) at line 635: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--insert into cloud.monitoring_services(id, uuid, service, process_name, service' at line 1 > ERROR 1064 (42000) at line 636: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--insert into cloud.monitoring_services(id, uuid, service, process_name, service' at line 1 > ERROR 1064 (42000) at line 637: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--insert into cloud.monitoring_services(id, uuid, service, process_name, servic' at line 1 > ERROR 1064 (42000) at line 787: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--ALTER TABLE `cloud_usage`.`usage_vm_instance` ADD COLUMN `cpu_speed` INT(10) U' at line 1 > ERROR 1060 (42S21) at line 833: Duplicate column name 'name' > ERROR 1060 (42S21) at line 838: Duplicate column name 'is_exclusive_gslb_provider' > ERROR 1091 (42000) at line 897: Can't DROP 'cpu'; check that column/key exists > ERROR 1091 (42000) at line 898: Can't DROP 'ram'; check that column/key exists > ERROR 1091 (42000) at line 899: Can't DROP 'speed'; check that column/key exists > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)