You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Alex Hitchins <al...@shapeblue.com> on 2014/01/28 11:42:07 UTC

Jetty on Windows

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.

RE: Jetty on Windows

Posted by Alex Hitchins <al...@shapeblue.com>.
Rebuilt the database, now failing on a spring framework issue. Going to rebuild all and try again.



Alex Hitchins
+44 7788 423 969

-----Original Message-----
From: Trippie [mailto:trippie@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 <al...@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.

RE: Jetty on Windows

Posted by Alex Hitchins <al...@shapeblue.com>.
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:trippie@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 <al...@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.

Re: Jetty on Windows

Posted by Hugo Trippaers <hu...@trippaers.nl>.
Hey Alex,

Did you reinitialize the database prior to running the jetty target?

Cheers,

Hugo

On 28 jan. 2014, at 11:42, Alex Hitchins <al...@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.