cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Siavash Safi (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CLOUDSTACK-7521) DB migration from 4.2.1 to 4.4.0 fails
Date Tue, 09 Sep 2014 16:20:28 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-7521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14127165#comment-14127165
] 

Siavash Safi edited comment on CLOUDSTACK-7521 at 9/9/14 4:19 PM:
------------------------------------------------------------------

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 <wido@widodh.nl>
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}

Direct link to the package: http://cloudstack.apt-get.eu/ubuntu/pool/cloudstack-management_4.2.1_all.deb
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.


was (Author: siavashs):
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 <wido@widodh.nl>
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 1050 (42S01) at line 64: Table 'vm_work_job' already exists
> ERROR 1050 (42S01) at line 75: Table 'async_job_journal' already exists
> ERROR 1050 (42S01) at line 86: Table 'async_job_join_map' already exists
> ERROR 1046 (3D000) at line 483: No database selected
> ERROR 1046 (3D000) at line 498: No database selected
> ERROR 1050 (42S01) at line 583: Table 'firewall_rule_details' already exists
> ERROR 1050 (42S01) at line 615: Table 'ldap_configuration' already exists
> ERROR 1050 (42S01) at line 624: Table 'monitoring_services' already exists
> ERROR 1062 (23000) at line 634: Duplicate entry '1' for key 'PRIMARY'
> ERROR 1062 (23000) at line 635: Duplicate entry '2' for key 'PRIMARY'
> ERROR 1062 (23000) at line 636: Duplicate entry '3' for key 'PRIMARY'
> ERROR 1062 (23000) at line 637: Duplicate entry '4' for key 'PRIMARY'
> ERROR 1050 (42S01) at line 641: Table 'usage_event_details' already exists
> ERROR 1050 (42S01) at line 650: Table 'usage_event_details' already exists
> ERROR 1050 (42S01) at line 659: Table 'user_ip_address_details' already exists
> ERROR 1050 (42S01) at line 669: Table 'remote_access_vpn_details' already exists
> ERROR 1060 (42S21) at line 787: Duplicate column name 'cpu_speed'
> ERROR 1050 (42S01) at line 791: Table 'vpc_details' already exists
> ERROR 1050 (42S01) at line 802: Table 'vpc_gateway_details' already exists
> ERROR 1050 (42S01) at line 812: Table 'network_acl_details' already exists
> ERROR 1050 (42S01) at line 822: Table 'network_acl_item_details' already exists
> ERROR 1050 (42S01) at line 847: Table 's2s_vpn_gateway_details' already exists
> ERROR 1050 (42S01) at line 876: Table 's2s_customer_gateway_details' already exists
> ERROR 1050 (42S01) at line 887: Table 's2s_vpn_connection_details' already exists{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message