Thanks all, i just start to deploy with fresh installation and its work On Fri, Nov 11, 2016 at 5:13 PM, Dag Sonstebo <dag.sonst...@shapeblue.com> wrote:
> +1 for Sergey’s comment - schema-40to410.sql should not run in your > scenario. > > A couple of other things in addition to Sergey’s request: > > - Can you send the output of “select * from cloud.version” from your DB. > - Did you *restart the upgrade after it failed once*? In general if your > upgrade fails on one of the SQL scripts you have to 1) restore the original > database, 2) fix the DB issue / upgrade script issue and 3) restart the > upgrade. In other words you can’t just restart the upgrade again. I have > seen the “duplicate column” and similar duplication problems before – and > they can be a result of the same SQL script running and trying the same > upgrade steps again. > > Regards, > Dag Sonstebo > > On 11/11/2016, 04:57, "Abdul Qayyum Halid" <haiy.ha...@gmail.com> wrote: > > i am upgrading from 4.6 to 4.9 > > On Fri, Nov 11, 2016 at 10:41 AM, Sergey Levitskiy < > sergey.levits...@autodesk.com> wrote: > > > What version are you upgrading from ? > > > > > > On 11/10/16, 6:26 PM, "Abdul Qayyum Halid" <haiy.ha...@gmail.com> > wrote: > > > > Hi, I am having problem to start CS management. The error show > unable > > to > > upgrade databases. MySQL version 5.7, CS 4.9. Any solution? > Below are > > the > > error.Thank you > > > > ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error > executing: > > alter > > table vm_template add size bigint unsigned > > 2016-11-11 10:18:53,229 ERROR [c.c.u.d.ScriptRunner] (main:null) > > (logid:) > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Duplicate > > column > > name 'size' > > 2016-11-11 10:18:53,229 ERROR [c.c.u.DatabaseUpgradeChecker] > > (main:null) > > (logid:) Unable to execute upgrade script: > > /usr/share/cloudstack-management/setup/db/schema-40to410.sql > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Duplicate > > column > > name 'size'.... > > 2016-11-11 10:18:53,233 WARN [o.a.c.s.m.c. > ResourceApplicationContext] > > (main:null) (logid:) Exception encountered during context > > initialization - > > cancelling refresh attempt: > > org.springframework.context.ApplicationContextException: Failed > to > > start > > bean 'cloudStackLifeCycle'; nested exception is > > com.cloud.utils.exception.CloudRuntimeException: Unable to > upgrade the > > database > > > > > > > > > > dag.sonst...@shapeblue.com > www.shapeblue.com > 53 Chandos Place, Covent Garden, London WC2N 4HSUK > @shapeblue > > > >