Hao Chen created EAGLE-224: ------------------------------ Summary: Column not found to EAGLE_METRIC when using JDBC Key: EAGLE-224 URL: https://issues.apache.org/jira/browse/EAGLE-224 Project: Eagle Issue Type: Bug Affects Versions: v0.3.0 Reporter: Hao Chen Assignee: Hao Chen
Some of the column are missing in table eagle_metric, site, application, policyId, there might be others : URL: ../rest/entities?query=GenericMetricService[@application="dgCassandraLogMonitor" AND @policyId="dg_csd_user_policy"]<@site>{sum(value)}&pageSize=100000&timeSeries=true&intervalmin=1440&startTime=2016-02-23 00:00:00&endTime=2016-03-24 00:00:00&metricName=eagle.alert.fail.count Params: undefined Exception: java.io.IOException: org.apache.torque.TorqueException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'eagle_metric.site' in 'field list' org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:179) org.apache.eagle.storage.operation.QueryStatement.execute(QueryStatement.java:47) org.apache.eagle.service.generic.GenericEntityServiceResource.search(GenericEntityServiceResource.java:443) sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:606) com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288) -- This message was sent by Atlassian JIRA (v6.3.4#6332)