You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "sadhu suresh (JIRA)" <ji...@apache.org> on 2014/06/19 11:38:24 UTC
[jira] [Closed] (CLOUDSTACK-6603) [Upgrade]DB Exception while
Autoscale monitoring after upgrading from 4.3 to 4.4
[ https://issues.apache.org/jira/browse/CLOUDSTACK-6603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
sadhu suresh closed CLOUDSTACK-6603.
------------------------------------
upgrade form 4.3 to 4.4 successful.not seen any issue as mentioned in the issue so closing the issue.
mysql> select * from version;
+----+---------+---------------------+----------+
| id | version | updated | step |
+----+---------+---------------------+----------+
| 1 | 4.0.0 | 2014-05-30 16:09:55 | Complete |
| 2 | 4.1.0 | 2014-05-30 11:14:16 | Complete |
| 3 | 4.2.0 | 2014-05-30 11:14:16 | Complete |
| 4 | 4.2.1 | 2014-05-30 11:14:16 | Complete |
| 5 | 4.3.0 | 2014-05-30 11:14:16 | Complete |
| 6 | 4.4.0 | 2014-06-19 14:49:28 | Complete |
+----+---------+---------------------+----------+
6 rows in set (0.00 sec)
> [Upgrade]DB Exception while Autoscale monitoring after upgrading from 4.3 to 4.4
> --------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-6603
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6603
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Upgrade
> Affects Versions: 4.4.0
> Reporter: manasaveloori
> Assignee: Rajesh Battala
> Priority: Blocker
> Fix For: 4.4.0
>
> Attachments: management-server.rar, mysqldump43.dmp, mysqldump44.dmp
>
>
> 1. Deploy CS 4.3 with 2 zones using xen 6.1 and KVM hypervisor.
> 2. Configured LB rules,firewall rules.
> 3. Registered the template for 4.4 (using the naming convention systemvm-xenserver-4.4,systemvm-kvm-4.4)
> 4. Upgraded to 4.4
> Start the management server:
> Below are the observations:
> 2014-05-05 05:05:13,567 DEBUG [c.c.s.StatsCollector] (StatsCollector-4:ctx-e36f20e1) AutoScaling Monitor is running...
> 2014-05-05 05:05:13,577 ERROR [c.c.s.StatsCollector] (StatsCollector-4:ctx-e36f20e1) Error trying to monitor autoscaling
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@5b140551: SELECT autoscale_vmgroups.id, autoscale_vmgroups.uuid, autoscale_vmgroups.zone_id, autoscale_vmgroups.domain_id, autoscale_vmgroups.account_id, autoscale_vmgroups.load_balancer_id, autoscale_vmgroups.min_members, autoscale_vmgroups.max_members, autoscale_vmgroups.member_port, autoscale_vmgroups.interval, autoscale_vmgroups.last_interval, autoscale_vmgroups.profile_id, autoscale_vmgroups.removed, autoscale_vmgroups.created, autoscale_vmgroups.state, autoscale_vmgroups.display FROM autoscale_vmgroups WHERE autoscale_vmgroups.removed IS NULL
> at com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:1127)
> at com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1150)
> at com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1136)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
> at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> at com.sun.proxy.$Proxy220.listAll(Unknown Source)
> at com.cloud.server.StatsCollector$AutoScaleMonitor.runInContext(StatsCollector.java:673)
> at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49)
> at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56)
> at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103)
> at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53)
> at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'autoscale_vmgroups.last_interval' 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:526)
> 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:96)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:1121)
--
This message was sent by Atlassian JIRA
(v6.2#6252)