[
https://issues.apache.org/jira/browse/EAGLE-224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hao Chen resolved EAGLE-224.
----------------------------
Resolution: Fixed
> 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)
