Hi, eagle_metric_eagle_metric_schema is having a column_name as "group" which is a reserved keyword. I am getting an error as mysql syntax error near group when i am trying to run the apache eagle application for hadoop_metric_monitor. Initially i was getting error even in creating this table with group keyword as column but i resolved it using group .Now it is trying to write to some of the table which is having group as a cloumn_name. That's why it is throwing error. Can somebody help me out.
I have attached the error log along with mail. _______ Regards Vikash Sent from Outlook<http://aka.ms/weboutlook>
ERROR [2017-05-02 08:09:05,662] org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityWriterImpl: Failed to write records, rolling back ! com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group,name,uuid,granularity,metricFields,site) VALUES (1493712545454,0,_binary'\' at line 1 ! at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source) ~[na:na] ! at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_121] ! at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_121] ! at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.torque.util.BasePeerImpl.doInsert(BasePeerImpl.java:773) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! ... 60 common frames omitted ! Causing: org.apache.torque.TorqueException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group,name,uuid,granularity,metricFields,site) VALUES (1493712545454,0,_binary'\' at line 1 ! at org.apache.torque.util.ExceptionMapperImpl.toTorqueException(ExceptionMapperImpl.java:59) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.torque.util.BasePeerImpl.doInsert(BasePeerImpl.java:783) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityWriterImpl.write(JdbcEntityWriterImpl.java:85) ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT] ! at org.apache.eagle.storage.jdbc.JdbcStorage.create(JdbcStorage.java:90) [eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT] ! at org.apache.eagle.storage.operation.CreateStatement.execute(CreateStatement.java:63) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.eagle.service.generic.GenericEntityServiceResource.create(GenericEntityServiceResource.java:137) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) ~[na:na] ! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121] ! at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121] ! at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.jersey.guava.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37) [dropwizard-jersey-0.7.1.jar:0.7.1] ! at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.jetty.NonblockingServletHolder.handle(NonblockingServletHolder.java:49) [dropwizard-jetty-0.7.1.jar:0.7.1] ! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1515) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:295) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.jetty.BiDiGzipFilter.doFilter(BiDiGzipFilter.java:123) [dropwizard-jetty-0.7.1.jar:0.7.1] ! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:29) [dropwizard-servlets-0.7.1.jar:0.7.1] ! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.jersey.filter.AllowedMethodsFilter.handle(AllowedMethodsFilter.java:44) [dropwizard-jersey-0.7.1.jar:0.7.1] ! at io.dropwizard.jersey.filter.AllowedMethodsFilter.doFilter(AllowedMethodsFilter.java:39) [dropwizard-jersey-0.7.1.jar:0.7.1] ! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.eagle.alert.resource.SimpleCORSFiler.doFilter(SimpleCORSFiler.java:51) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:66) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:519) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1097) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:448) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1031) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:136) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.codahale.metrics.jetty9.InstrumentedHandler.handle(InstrumentedHandler.java:175) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.jetty.RoutingHandler.handle(RoutingHandler.java:51) [dropwizard-jetty-0.7.1.jar:0.7.1] ! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.RequestLogHandler.handle(RequestLogHandler.java:92) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:162) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.Server.handle(Server.java:446) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:271) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:246) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.io.AbstractConnection$ReadCallback.run(AbstractConnection.java:358) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:601) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:532) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121] DEBUG [2017-05-02 08:09:05,663] org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityWriterImpl: Closing connection ERROR [2017-05-02 08:09:05,726] org.apache.eagle.service.generic.GenericEntityServiceResource: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'component' in 'field list' ! com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'component' in 'field list' ! at sun.reflect.GeneratedConstructorAccessor88.newInstance(Unknown Source) ~[na:na] ! at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_121] ! at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_121] ! at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2077) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2062) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.torque.util.BasePeerImpl.doInsert(BasePeerImpl.java:773) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityWriterImpl.write(JdbcEntityWriterImpl.java:85) ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT] ! at org.apache.eagle.storage.jdbc.JdbcStorage.create(JdbcStorage.java:90) ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT] ! ... 58 common frames omitted ! Causing: java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'component' in 'field list' ! at org.apache.eagle.storage.jdbc.JdbcStorage.create(JdbcStorage.java:97) ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT] ! at org.apache.eagle.storage.operation.CreateStatement.execute(CreateStatement.java:63) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at org.apache.eagle.service.generic.GenericEntityServiceResource.create(GenericEntityServiceResource.java:137) ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) ~[na:na] ! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121] ! at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121] ! at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na] ! at io.dropwizard.jersey.guava.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37) [dropwizard-jersey-0.7.1.jar:0.7.1]
