cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From France <mailingli...@isg.si>
Subject Re: CS 4.0 upgrade on CentOS
Date Thu, 08 Nov 2012 08:37:50 GMT
Seems to me that there is DB problem:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'account.default_zone_id'
in 'field list'

So maybe the DB schema for usage was not upgraded? I remember reading 
something about it in the upgrade manual. Did you upgrade database 
(schema) for usage service?

Regards,
F.

On 7/11/12 6:01 PM, Tamas Monos wrote:
> Hi,
>
> Already did that and was able to update the packages, thank you.
>
> I'm still in the middle of the upgrade as it does not really want to do anything with
the systemVMs.
> I'm running the script: "nohup cloud-sysvmadm -d 192.168.1.5 -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 systemVMs.
>
> No errors during running the script no errors in the log:
> Stopping and starting 1 running routing vm(s)...
> Done restarting router(s).
>
> Also after the DB upgrade I start cloud usage and get:
> 2012-11-07 16:18:51,921 DEBUG [cloud.usage.UsageManagerImpl] (Usage-HB-1:null) Scheduling
Usage job...
> 2012-11-07 16:18:51,921 INFO  [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) starting
usage job...
> 2012-11-07 16:18:51,929 INFO  [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Parsing
usage records between Wed Nov 07 15:00:00 GMT 2012 and Wed Nov 07 15:59:59 GMT 2012
> 2012-11-07 16:18:52,131 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) deleting
network offering: 7 from Vm: 36
> 2012-11-07 16:18:52,147 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Creating
networking offering: 7 for Vm: 34 for account: 3
> 2012-11-07 16:18:52,157 ERROR [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Exception
in usage manager
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: org.apache.commons.dbcp.DelegatingPreparedStatement@2d35da43
> 	at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:955)
> 	at com.cloud.user.dao.AccountDaoImpl$$EnhancerByCGLIB$$792a6be2.CGLIB$findById$33(<generated>)
> 	at com.cloud.user.dao.AccountDaoImpl$$EnhancerByCGLIB$$792a6be2$$FastClassByCGLIB$$310d9132.invoke(<generated>)
> 	at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> 	at com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34)
> 	at com.cloud.user.dao.AccountDaoImpl$$EnhancerByCGLIB$$792a6be2.findById(<generated>)
> 	at com.cloud.utils.db.GenericDaoBase.findByIdIncludingRemoved(GenericDaoBase.java:915)
> 	at com.cloud.usage.UsageManagerImpl.createNetworkOfferingEvent(UsageManagerImpl.java:1315)
> 	at com.cloud.usage.UsageManagerImpl.createHelperRecord(UsageManagerImpl.java:785)
> 	at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:518)
> 	at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:332)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> 	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
> 	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
> 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:165)
> 	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:266)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> 	at java.lang.Thread.run(Thread.java:679)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'account.default_zone_id' in 'field list'
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:386)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> 	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:97)
> 	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:97)
> 	at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:952)
> 	... 18 more
> 2012-11-07 16:18:52,177 DEBUG [db.Transaction.Transaction] (Usage-Job-1:null) Rolling
back the transaction: Time = 109 Name =  -UsageEventDaoImpl.getRecentEvents:91-DatabaseCallback.intercept:34-UsageManagerImpl.parse:497-UsageManagerImpl.run:332-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRun:334-FutureTask.run:166-ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101:165-ScheduledThreadPoolExecutor$ScheduledFutureTask.run:266-ThreadPoolExecutor.runWorker:1110-ThreadPoolExecutor$Worker.run:603-Thread.run:679;
called by -Transaction.rollback:887-UsageManagerImpl.parse:665-UsageManagerImpl.run:332-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRun:334-FutureTask.run:166-ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101:165-ScheduledThreadPoolExecutor$ScheduledFutureTask.run:266-ThreadPoolExecutor.runWorker:1110-ThreadPoolExecutor$Worker.run:603-Thread.run:679
> 2012-11-07 16:18:52,210 WARN  [db.Transaction.Transaction] (Usage-Job-1:null) txn: Commit
called when it is not a transaction: -UsageManagerImpl.parse:674-UsageManagerImpl.run:332-Executors$RunnableAdapter.call:471-FutureTask$Sync.innerRun:334-FutureTask.run:166-ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101:165-ScheduledThreadPoolExecutor$ScheduledFutureTask.run:266-ThreadPoolExecutor.runWorker:1110-ThreadPoolExecutor$Worker.run:603-Thread.run:679
> 2012-11-07 16:18:52,374 INFO  [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) usage
job complete
>
> Any ideas how to resolve/debug?
>
> Regards
>
> Tamas Monos                                               DDI         +44(0)2034687012
> Chief Technical                                             Office    +44(0)2034687000
> Veber: The Hosting Specialists               Fax         +44(0)871 522 7057
> http://www.veber.co.uk
>
> Follow us on Twitter: www.twitter.com/veberhost
> Follow us on Facebook: www.facebook.com/veberhost
>
> -----Original Message-----
> From: Rajesh Battala [mailto:rajesh.battala@citrix.com]
> Sent: 07 November 2012 16:32
> To: cloudstack-users@incubator.apache.org
> Subject: RE: CS 4.0 upgrade on CentOS
>
> As it is a Test upgrade, Just quick workaround would be change the gpgcheck from 1 to
0 in the repo config file to continue the installation process.
>
> Thanks
> Rajesh Battala
>
> -----Original Message-----
> From: Tamas Monos [mailto:tamasm@veber.co.uk]
> Sent: Wednesday, November 07, 2012 9:29 PM
> To: cloudstack-users@incubator.apache.org
> Subject: CS 4.0 upgrade on CentOS
>
> Hi,
>
> I'm just about to run a test upgrade from 3.0.2 to 4.0 but run into issues with:
>
> Package cloud-client-ui-4.0.0-0.140.el6.4.0.x86_64.rpm is not signed
>
> I cannot find the keys to import on http://cloudstack.apt-get.eu/rhel/4.0/
>
> Anyone?
>
> Regards
>
> Tamas Monos                                               DDI         +44(0)2034687012
> Chief Technical                                             Office    +44(0)2034687000
> Veber: The Hosting Specialists               Fax         +44(0)871 522 7057
> http://www.veber.co.uk<http://www.veber.co.uk/>
>
> Follow us on Twitter: www.twitter.com/veberhost<http://www.twitter.com/veberhost>
> Follow us on Facebook: www.facebook.com/veberhost<http://www.facebook.com/veberhost>
>
>
>



Mime
View raw message