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.batt...@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:tam...@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>
