manasaveloori created CLOUDSTACK-6603:
-----------------------------------------
Summary: [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
Priority: Blocker
Fix For: 4.4.0
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)
