cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nux (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CLOUDSTACK-6061) Unable to execute upgrade script: schema-421to430.sql, Duplicate column name 'related'
Date Fri, 07 Feb 2014 19:25:19 GMT

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

Nux edited comment on CLOUDSTACK-6061 at 2/7/14 7:24 PM:
---------------------------------------------------------

Alena,

Ok, this is what I did:

- revert to 4.2.1 with working DB and everything 

- installed new sysVM:
/usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt -m /mnt/secondary
-u http://jenkins.buildacloud.org/view/4.3/job/cloudstack-4.3-systemvm
/lastSuccessfulBuild/artifact/tools/appliance/dist/systemvmtemplate-2014-02-07-master-kvm.qcow2.bz2
 -h kvm -F

- service cloudstack-management stop

- yum upgrade (to 4.3.0)

- service cloudstack-management start

- this is what I get:
2014-02-07 19:09:38,751 DEBUG [c.c.u.d.Upgrade421to430] (main:null) Updating VMware System
Vms
2014-02-07 19:09:38,751 WARN  [c.c.u.d.Upgrade421to430] (main:null) 4.3.0 VMware SystemVm
template not found. VMware hypervisor is not used, so not failing upgrade
2014-02-07 19:09:38,752 DEBUG [c.c.u.d.Upgrade421to430] (main:null) Updating KVM System Vms
2014-02-07 19:09:38,759 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to upgrade
the database
com.cloud.utils.exception.CloudRuntimeException: 4.3.0 KVM SystemVm template not found. Cannot
upgrade system Vms

Also:
grep -i "Database upgrade must be performed from" /var/log/cloudstack/management/management-server.log
2014-02-07 19:09:35,975 INFO  [c.c.u.DatabaseUpgradeChecker] (main:null) Database upgrade
must be performed from 4.2.1 to 4.3.0

So the question is, at what point during the upgrade procedure must the new System VM template
be installed?




was (Author: nuxro):
Alena,

Ok, this is what I did:

- revert to 4.2.1 with working DB and everything 

- installed new sysVM:
/usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt -m /mnt/secondary
-u http://jenkins.buildacloud.org/view/4.3/job/cloudstack-4.3-systemvm
/lastSuccessfulBuild/artifact/tools/appliance/dist/systemvmtemplate-2014-02-07-master-kvm.qcow2.bz2
 -h kvm -F

- service cloudstack-management stop

- yum upgrade (to 4.3.0)

- service cloudstack-management start

- this is what I get:
2014-02-07 19:09:38,751 DEBUG [c.c.u.d.Upgrade421to430] (main:null) Updating VMware System
Vms
2014-02-07 19:09:38,751 WARN  [c.c.u.d.Upgrade421to430] (main:null) 4.3.0 VMware SystemVm
template not found. VMware hypervisor is not used, so not failing upgrade
2014-02-07 19:09:38,752 DEBUG [c.c.u.d.Upgrade421to430] (main:null) Updating KVM System Vms
2014-02-07 19:09:38,759 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to upgrade
the database
com.cloud.utils.exception.CloudRuntimeException: 4.3.0 KVM SystemVm template not found. Cannot
upgrade system Vms

Also:
grep -i "Database upgrade must be performed from" /var/log/cloudstack/management/management-server.log
2014-02-07 19:09:35,975 INFO  [c.c.u.DatabaseUpgradeChecker] (main:null) Database upgrade
must be performed from 4.2.1 to 4.3.0



> Unable to execute upgrade script: schema-421to430.sql, Duplicate column name 'related'
> --------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-6061
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6061
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server
>    Affects Versions: 4.2.1, 4.3.0
>         Environment: CentOS 6.5 x86_64 management server
> Using http://tmp.nux.ro/cloudsnap430_4308/ built from revision 4308
>            Reporter: Nux
>            Assignee: Alena Prokharchyk
>            Priority: Critical
>              Labels: db, upgrade
>
> Running an advanced zone with SG on 4.2.1, NFS primary and secondary storage, one instance
and one extra volume. One management server, 2 HVs.
> Upgraded to 4.3.0 as follows:
> 1. service cloudstack-management stop
> 2. yum -y update (to update cloudstack-* rpms)
> 3. Add new SystemVM tmplate
> /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt -m /mnt/secondary
-u http://jenkins.buildacloud.org/view/4.3/job/cloudstack-4.3-systemvm/lastSuccessfulBuild/artifact/tools/appliance/dist/systemvmtemplate-2014-02-06-master-kvm.qcow2.bz2
 -h kvm -F
> 4. service cloudstack-management start
> The following shows up in the management log:
> http://fpaste.org/75337/
> This is how my cloud DB looked like BEFORE the upgrade; this is the working 4.2.1 DB:
> http://tmp.nux.ro/ifu82kcloud.sql
> One Note:
> If I install 4.2.1 and run cloudstack-setup-databases and right after this upgrade to
4.3.0 then there is no problem.
> If I start using 4.2.1, add zones, HVs etc to it and THEN try to upgrade to 4.3.0 then
the problem appears.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message