[
https://issues.apache.org/jira/browse/EAGLE-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16034400#comment-16034400
]
JiJun Tang edited comment on EAGLE-1030 at 6/2/17 9:51 AM:
-----------------------------------------------------------
As a workaround, you can add column site in table eaglejpa_process_process. I
advice you to use hbase.
was (Author: r7raul):
As a workaround, you can add column site in table eaglejpa_process_process.
> Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC
> ---------------------------------------------------------------------------
>
> Key: EAGLE-1030
> URL: https://issues.apache.org/jira/browse/EAGLE-1030
> Project: Eagle
> Issue Type: Bug
> Affects Versions: v0.5.0
> Environment: Cent 0S 6.8
> MySQL Community Server (GPL) 5.7.18
> x86_64 for linux
> eagle 0.5
> hadoop 2.6.4
> Reporter: Alexandre
>
> Hi,
> I'm using JDBC for apache eagle and i have this exception in
> "log/eagle-server.log":
> ERROR [2017-06-02 08:02:45,403] org.apache.eagle.storage.jdbc.JdbcStorage:
> Failed to query by: SELECT max(eaglejpa_process_process.currentTimeStamp),
> eaglejpa_process_process.site FROM eaglejpa_process_process WHERE
> (eaglejpa_process_process.timestamp>=? AND
> eaglejpa_process_process.timestamp<? AND eaglejpa_process_process.site=?)
> GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements:
> [1493798565000,1496390565000,site1]
> ! com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
> 'eaglejpa_process_process.site' in 'field list'
> ! at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.8.0_31]
> ! at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> ~[na:1.8.0_31]
> ! at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_31]
> ! at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
> ~[na:1.8.0_31]
> ! 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.executeQuery(PreparedStatement.java:2030)
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1535)
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! ... 61 common frames omitted
> ! Causing: org.apache.torque.TorqueException:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
> 'eaglejpa_process_process.site' in 'field list'
> ! 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.doSelect(BasePeerImpl.java:1608)
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1152)
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:75)
> ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! ... 59 common frames omitted
> ! Causing: java.io.IOException: Failed to query by: SELECT
> max(eaglejpa_process_process.currentTimeStamp), eaglejpa_process_process.site
> FROM eaglejpa_process_process WHERE (eaglejpa_process_process.timestamp>=?
> AND eaglejpa_process_process.timestamp<? AND eaglejpa_process_process.site=?)
> GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements:
> [1493798565000,1496390565000,site1]
> ! at
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:82)
> ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:161)
> ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at
> org.apache.eagle.storage.operation.QueryStatement.execute(QueryStatement.java:47)
> [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at
> org.apache.eagle.service.generic.GenericEntityServiceResource.search(GenericEntityServiceResource.java:444)
> [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source) ~[na:na]
> ! at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_31]
> ! at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_31]
> ! 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:348)
> [eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at io.dropwizard.jetty.BiDiGzipFilter.doFilter(BiDiGzipFilter.java:127)
> [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_31]
> I have exactly the same issue with "alert_detail_alert_detail.count"
> -> Unknown column 'alert_detail_alert_detail.count' in 'field list'
> thanks in advance for your help!
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
