cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tamas Monos <>
Subject RE: Upgrade 3.0.2->4.0.0
Date Fri, 09 Nov 2012 12:12:40 GMT

Thank you!
That workaround worked just fine!
Awesome :)

The last thing I'd need some help with is the usage after the upgrade:

2012-11-09 11:44:51,924 INFO  [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Parsing usage
records between Wed Nov 07 15:00:00 GMT 2012 and Fri Nov 09 10:59:59 GMT 2012
2012-11-09 11:44:51,955 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) deleting network
offering: 7 from Vm: 36
2012-11-09 11:44:51,957 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Creating networking
offering: 7 for Vm: 34 for account: 3
2012-11-09 11:44:51,957 ERROR [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Exception
in usage manager DB Exception on: org.apache.commons.dbcp.DelegatingPreparedStatement@8a030d6
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(
        at java.util.concurrent.Executors$
        at java.util.concurrent.FutureTask$Sync.innerRun(
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(
        at java.util.concurrent.ScheduledThreadPoolExecutor$
        at java.util.concurrent.ThreadPoolExecutor.runWorker(
        at java.util.concurrent.ThreadPoolExecutor$
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'account.default_zone_id'
in 'field list'
        at sun.reflect.GeneratedConstructorAccessor30.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
        at java.lang.reflect.Constructor.newInstance(
        at com.mysql.jdbc.Util.handleNewInstance(
        at com.mysql.jdbc.Util.getInstance(
        at com.mysql.jdbc.SQLError.createSQLException(
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(
        at com.mysql.jdbc.MysqlIO.sendCommand(
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
        at com.mysql.jdbc.ConnectionImpl.execSQL(
        at com.mysql.jdbc.PreparedStatement.executeInternal(
        at com.mysql.jdbc.PreparedStatement.executeQuery(
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
        ... 18 more

Is there a usage DB upgrade script that did not run somewhere?


Tamas Monos                                               DDI         +44(0)2034687012
Chief Technical                                             Office    +44(0)2034687000
Veber: The Hosting Specialists               Fax         +44(0)871 522 7057

Follow us on Twitter:
Follow us on Facebook:

-----Original Message-----
From: Kishan Kavala [] 
Sent: 08 November 2012 18:24
Subject: RE: Upgrade 3.0.2->4.0.0

  Looks like vmware systemVm template upgrade is missing in 4.0 upgrade. 

You can try the below work around:

1.  Add new vmware template to CS with name systemvm-vmware-4.0 2.  Wait till the template
is downloaded and installed successfully 3.  Look up id of this template in DB (Name should
match the input provided in step # 1)
   mysql> select id from `cloud`.`vm_template` where name = 'systemvm-vmware-4.0' and removed
is null; 4. Update template type to SYSTEM
   mysql> update `cloud`.`vm_template` set type='SYSTEM' where id = <id-from-step3>;
5. Update template Id for all system Vms
   mysql> update `cloud`.`vm_instance` set vm_template_id = <id-from-step3> where
type <> 'User' and hypervisor_type = 'VMware'; 6. Restart all system Vms

From: Tamas Monos []
Sent: Thursday, November 08, 2012 7:39 PM
Subject: Upgrade 3.0.2->4.0.0


Sorry putting this on dev-list but got no luck on the user one.

I have upgraded from 3.0.2 to 4.0.0 and the management server started and updated the database
just fine, however the rest of the upgrade procedure just does not work.
I'm running the script: "nohup cloud-sysvmadm -d -u cloud -p password -c -r >
sysvm.log 2>&1 &" accordingly to my environment and see in its log it is trying
to stop/start a router.
It stops it, then recreates the same secondary datastore (vmware) and then starts the same
router rather than deploying the new imported systemVM template and creating a new one.
It neither touches the sec-storage VM nor the console-proxy VM so new management system, old

No errors during running the script no errors in the log:
Stopping and starting 1 running routing vm(s)...
Done restarting router(s).

Is there a way to bypass this and convince CS 4.0 manually to use the new imported systemvm-vmware-3.0.5
template for systemvms?
This way I could just destroy the systemvms and CS would re-create them with the new template.

Thanks in advance.


Tamas Monos                                               DDI         +44(0)2034687012
Chief Technical                                             Office    +44(0)2034687000
Veber: The Hosting Specialists               Fax         +44(0)871 522 7057<>

Follow us on Twitter:<>
Follow us on Facebook:<>

View raw message