I'm fairly sure I did - however that makes me wonder if I restored over the top. Good pointer, I'll check that out.
Alex Hitchins +44 7788 423 969 -----Original Message----- From: Trippie [mailto:trip...@gmail.com] On Behalf Of Hugo Trippaers Sent: 28 January 2014 11:33 To: dev Subject: Re: Jetty on Windows 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. 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.
