cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maurice Lawler <maurice.law...@me.com>
Subject Re: Error when taking host out of maintenance
Date Tue, 01 Oct 2013 19:06:47 GMT
That error is no longer, now getting an error about 
vm_snapshot_chain_size being a duplicate.

The upgrade script has:   ALTER TABLE volumes ADD COLUMN 
vm_snapshot_chain_size bigint(20) unsigned;

Error message is:


2013-10-01 15:03:29,531 DEBUG [db.Transaction.Transaction] 
(Timer-2:null) Rolling back the transaction: Time = 14 Name = 
-CloudStartupServlet$1.run:52-TimerThread.mainLoop:534-TimerThread.run:484; 
called by 
-Transaction.rollback:898-Transaction.removeUpTo:841-Transaction.close:665-DatabaseUpgradeChecker.upgrade:295-DatabaseUpgradeChecker.check:391-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:54-TimerThread.mainLoop:534-TimerThread.run:484
2013-10-01 15:03:29,532 ERROR [utils.component.ComponentContext] 
(Timer-2:null) System integrity check failed. Refuse to startup
com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the 
database
     at 
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:293)
     at 
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)
     at 
com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
     at 
com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
     at java.util.TimerThread.mainLoop(Timer.java:534)
     at java.util.TimerThread.run(Timer.java:484)
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to 
execute upgrade script: 
/usr/share/cloudstack-management/setup/db/schema-410to420.sql
     at 
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:210)
     at 
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
     ... 5 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Duplicate column name 'vm_snapshot_chain_size'
     at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
     at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
     at 
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:201)
     ... 6 more

Mime
View raw message