Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Date: Thu, 22 May 2014 20:39:02 +0000 (UTC)
From: "Animesh Chaturvedi (JIRA)" <jira@apache.org>
To: cloudstack-issues@incubator.apache.org
Message-ID: <JIRA.12713017.1399525821181.3951.1400791142714@arcas>
In-Reply-To: <JIRA.12713017.1399525821181@arcas>
References: <JIRA.12713017.1399525821181@arcas>
Subject: [jira] [Updated] (CLOUDSTACK-6603) [Upgrade]DB Exception while
 Autoscale monitoring after upgrading from 4.3 to 4.4
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CLOUDSTACK-6603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Animesh Chaturvedi updated CLOUDSTACK-6603:
-------------------------------------------


BULK EDIT> There is no update on these issues in last 10 days, please provide the update. If you are working on it mark the issue "In Progress"

> [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)