+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" <[email protected]> wrote: i am upgrading from 4.6 to 4.9 On Fri, Nov 11, 2016 at 10:41 AM, Sergey Levitskiy < [email protected]> wrote: > What version are you upgrading from ? > > > On 11/10/16, 6:26 PM, "Abdul Qayyum Halid" <[email protected]> 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 > > > [email protected] www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
