Hey Alex, Did you reinitialize the database prior to running the jetty target?
Cheers, Hugo On 28 jan. 2014, at 11:42, Alex Hitchins <alex.hitch...@shapeblue.com> wrote: > All, > > I'm successfully getting the UI to build and getting it to run on my windows > machine through Jetty. That said, I always get the following error from the > command line (at bottom of email). I notice it's a SQL issue regards to auto > scaling - is this my configuration that's broken or is this a known issue? > > ERROR [c.c.s.StatsCollector] (StatsCollector-2:ctx-752f7e49) Error trying to > mon > itor autoscaling > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: > com.mysql.jdbc > .JDBC4PreparedStatement@41c319ee: SELECT autoscale_vmgroups.id, > autoscale_vmgrou > ps.uuid, autoscale_vmgroups.zone_id, autoscale_vmgroups.domain_id, > autoscale_vmg > roups.account_id, autoscale_vmgroups.load_balancer_id, > autoscale_vmgroups.min_me > mbers, 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 FROM autoscale_vmgroups WHERE autoscale_vmgroups.removed IS NULL > at > com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:112 > 4) > at com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1147) > at com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1133) > at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti > on(AopUtils.java:317) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo > inpoint(ReflectiveMethodInvocation.java:183) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:150) > at > com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionCo > ntextInterceptor.java:34) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:161) > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok > e(ExposeInvocationInterceptor.java:91) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:172) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami > cAopProxy.java:204) > at com.sun.proxy.$Proxy235.listAll(Unknown Source) > at > com.cloud.server.StatsCollector$AutoScaleMonitor.runInContext(StatsCo > llector.java:649) > at > org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(Ma > nagedContextRunnable.java:49) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.ca > ll(DefaultManagedContext.java:56) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.call > WithContext(DefaultManagedContext.java:103) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runW > ithContext(DefaultManagedContext.java:53) > at > org.apache.cloudstack.managed.context.ManagedContextRunnable.run(Mana > gedContextRunnable.java:46) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47 > 1) > 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 > co > lumn 'autoscale_vmgroups.last_interval' in 'field list' > at sun.reflect.GeneratedConstructorAccessor89.newInstance(Unknown > Source > ) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC > onstructorAccessorImpl.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:1053) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja > va:2155) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: > 2318) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele > gatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele > gatingPreparedStatement.java:96) > at > com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:111 > 8) > > > Regards, > > Alex Hitchins > ShapeBlue > > Need Enterprise Grade Support for Apache CloudStack? > Our CloudStack Infrastructure > Support<http://shapeblue.com/cloudstack-infrastructure-support/> offers the > best 24/7 SLA for CloudStack Environments. > > Apache CloudStack Bootcamp training courses > > **NEW!** CloudStack 4.2.1 training<http://shapeblue.com/cloudstack-training/> > 18th-19th February 2014, Brazil. > Classroom<http://shapeblue.com/cloudstack-training/> > 17th-23rd March 2014, Region A. Instructor led, > On-line<http://shapeblue.com/cloudstack-training/> > 24th-28th March 2014, Region B. Instructor led, > On-line<http://shapeblue.com/cloudstack-training/> > 16th-20th June 2014, Region A. Instructor led, > On-line<http://shapeblue.com/cloudstack-training/> > 23rd-27th June 2014, Region B. Instructor led, > On-line<http://shapeblue.com/cloudstack-training/> > > This email and any attachments to it may be confidential and are intended > solely for the use of the individual to whom it is addressed. Any views or > opinions expressed are solely those of the author and do not necessarily > represent those of Shape Blue Ltd or related companies. If you are not the > intended recipient of this email, you must neither take any action based upon > its contents, nor copy or show it to anyone. Please contact the sender if you > believe you have received this email in error. Shape Blue Ltd is a company > incorporated in England & Wales. ShapeBlue Services India LLP is a company > incorporated in India and is operated under license from Shape Blue Ltd. > Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is > operated under license from Shape Blue Ltd. ShapeBlue is a registered > trademark.
