You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@eagle.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/04/09 11:02:25 UTC

[jira] [Commented] (EAGLE-224) Column not found to EAGLE_METRIC when using JDBC

    [ https://issues.apache.org/jira/browse/EAGLE-224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15233460#comment-15233460 ] 

ASF GitHub Bot commented on EAGLE-224:
--------------------------------------

GitHub user haoch opened a pull request:

    https://github.com/apache/incubator-eagle/pull/139

    EAGLE-224 Add default columns "site","application","policyId" for eagle_metric table

    https://issues.apache.org/jira/browse/EAGLE-224

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/haoch/incubator-eagle fix-jdbc-metric-schema

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-eagle/pull/139.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #139
    
----
commit 03869c96c7c63cefd472a663bd57f5a47fadafb6
Author: Hao Chen <ha...@apache.org>
Date:   2016-04-09T08:58:49Z

    Add default colomns "site","application","policyId" for eagle_metric table

----


> 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)