[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14144566#comment-14144566 ] ASF subversion and git services commented on CLOUDSTACK-6603: - Commit 0c3d0cc954b7c276640a71b636f78928f55e97a2 in cloudstack's branch refs/heads/master from [~rajesh_battala] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=0c3d0cc ] CLOUDSTACK-6603 [Upgrade]DB Exception while Autoscale monitoring after upgrading from 4.3 to 4.4 (cherry picked from commit c282bb3a1293fbbfdb306263ea52464862670fb3) (cherry picked from commit fc7d0b2a333e510619f14528a72e35bbf9ed7045) [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
[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14026355#comment-14026355 ] ASF subversion and git services commented on CLOUDSTACK-6603: - Commit fc7d0b2a333e510619f14528a72e35bbf9ed7045 in cloudstack's branch refs/heads/4.4 from [~rajesh_battala] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=fc7d0b2 ] CLOUDSTACK-6603 [Upgrade]DB Exception while Autoscale monitoring after upgrading from 4.3 to 4.4 (cherry picked from commit c282bb3a1293fbbfdb306263ea52464862670fb3) [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
[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14021875#comment-14021875 ] ASF subversion and git services commented on CLOUDSTACK-6603: - Commit c282bb3a1293fbbfdb306263ea52464862670fb3 in cloudstack's branch refs/heads/4.4-forward from [~rajesh_battala] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=c282bb3 ] CLOUDSTACK-6603 [Upgrade]DB Exception while Autoscale monitoring after upgrading from 4.3 to 4.4 [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
[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14015397#comment-14015397 ] Rajesh Battala commented on CLOUDSTACK-6603: this issues got created by this commit https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=commit;h=dc151115be3e922933ea26ab1507eb6469a91e11 schema of autoscale_vmgroups table got changed in wrong version of schema file cause the upgrade failed. Instead of adding to the upgrade path file it was added to setup/db/db/schema-40to410.sql file. [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)
[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14014525#comment-14014525 ] Rajesh Battala commented on CLOUDSTACK-6603: last_interval column is created along with the table creation of autoscale_vmgroups from ./db/db/schema-40to410.sql In 4.2 and 4.3, deploying db autoscale_vmgroups tables don't have last_interval column. but in 4.4 code deploying db this column is present. As the column last_interval is missing, autoscale manager and autoscalevmgroupvo is referring to this column exception is happening. [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
[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14011221#comment-14011221 ] Rajesh Battala commented on CLOUDSTACK-6603: I have analysed the dumps. this field last_interval is not present in 43 db dmp and 4.4 db dmp. Will figure out any new code changes had caused issues. [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
[jira] [Commented] (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:comment-tabpanelfocusedCommentId=14010021#comment-14010021 ] Animesh Chaturvedi commented on CLOUDSTACK-6603: rajesh please provide update on this issue. [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