You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Tamas Monos <ta...@veber.co.uk> on 2012/11/07 16:58:56 UTC
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>
Re: CS 4.0 upgrade on CentOS
Posted by France <ma...@isg.si>.
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>
>
>
>
RE: CS 4.0 upgrade on CentOS
Posted by Tamas Monos <ta...@veber.co.uk>.
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>
RE: CS 4.0 upgrade on CentOS
Posted by Rajesh Battala <ra...@citrix.com>.
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>