Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-13314

Elasticsearch - Graphs not working

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 3.4.5
    • Frontend (F)

      Hello,

      I have just started testing out the ES functionality and the initial setup is up and running (See es_stored_values.jpg), but now when trying to see some graphs it seems like the there is an issue when extracting the data points from Es:

      The following error appears anytime I try to view a graph:

      Elasticsearch log
      [2018-01-10T07:58:46,203][WARN ][o.e.d.c.ParseField       ] Deprecated field [inline] used, expected [source] instead
      [2018-01-10T07:58:46,209][WARN ][r.suppressed             ] path: /uint/values/_search, params: {index=uint, type=values}
      org.elasticsearch.action.search.SearchPhaseExecutionException: all shards failed
              at org.elasticsearch.action.search.AbstractSearchAsyncAction.onPhaseFailure(AbstractSearchAsyncAction.java:274) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.AbstractSearchAsyncAction.executeNextPhase(AbstractSearchAsyncAction.java:132) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.AbstractSearchAsyncAction.onPhaseDone(AbstractSearchAsyncAction.java:243) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.InitialSearchPhase.onShardFailure(InitialSearchPhase.java:107) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.InitialSearchPhase.access$100(InitialSearchPhase.java:49) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.InitialSearchPhase$2.lambda$onFailure$1(InitialSearchPhase.java:217) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.InitialSearchPhase.maybeFork(InitialSearchPhase.java:171) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.InitialSearchPhase.access$000(InitialSearchPhase.java:49) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.InitialSearchPhase$2.onFailure(InitialSearchPhase.java:217) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.SearchExecutionStatsCollector.onFailure(SearchExecutionStatsCollector.java:73) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.ActionListenerResponseHandler.handleException(ActionListenerResponseHandler.java:51) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.SearchTransportService$ConnectionCountingHandler.handleException(SearchTransportService.java:531) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.transport.TransportService$ContextRestoreResponseHandler.handleException(TransportService.java:1056) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.transport.TransportService$DirectResponseChannel.processException(TransportService.java:1149) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.transport.TransportService$DirectResponseChannel.sendResponse(TransportService.java:1133) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.transport.TaskTransportChannel.sendResponse(TaskTransportChannel.java:66) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.action.search.SearchTransportService$6$1.onFailure(SearchTransportService.java:389) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService$2.onFailure(SearchService.java:318) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.common.util.concurrent.TimedRunnable.doRun(TimedRunnable.java:41) [elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37) [elasticsearch-6.1.1.jar:6.1.1]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
              at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
      Caused by: org.elasticsearch.script.ScriptException: runtime error
              at org.elasticsearch.painless.PainlessScript.convertToScriptException(PainlessScript.java:101) ~[?:?]
              at org.elasticsearch.painless.PainlessScript$Script.execute(Math.floor((params.width*(((long)doc['clock'].value/1000+params.delta)%params.size))/params.size):5) ~[?:?]
              at org.elasticsearch.painless.ScriptImpl.run(ScriptImpl.java:105) ~[?:?]
              at org.elasticsearch.search.aggregations.support.values.ScriptBytesValues.advanceExact(ScriptBytesValues.java:54) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.terms.StringTermsAggregator$1.collect(StringTermsAggregator.java:81) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.AggregatorFactory$MultiBucketAggregatorWrapper$1.collect(AggregatorFactory.java:140) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.BestBucketsDeferringCollector.prepareSelectedBuckets(BestBucketsDeferringCollector.java:178) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.DeferringBucketCollector.replay(DeferringBucketCollector.java:44) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.DeferableBucketAggregator.runDeferredCollections(DeferableBucketAggregator.java:91) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.terms.LongTermsAggregator.buildAggregation(LongTermsAggregator.java:155) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.AggregationPhase.execute(AggregationPhase.java:129) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.query.QueryPhase.execute(QueryPhase.java:116) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService.loadOrExecuteQueryPhase(SearchService.java:301) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:334) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:310) ~[elasticsearch-6.1.1.jar:6.1.1]
              ... 9 more
      Caused by: java.lang.ClassCastException: org.joda.time.MutableDateTime cannot be cast to java.lang.Number
              at org.elasticsearch.painless.Def.DefTolongExplicit(Def.java:823) ~[?:?]
              at org.elasticsearch.painless.PainlessScript$Script.execute(Math.floor((params.width*(((long)doc['clock'].value/1000+params.delta)%params.size))/params.size):46) ~[?:?]
              at org.elasticsearch.painless.ScriptImpl.run(ScriptImpl.java:105) ~[?:?]
              at org.elasticsearch.search.aggregations.support.values.ScriptBytesValues.advanceExact(ScriptBytesValues.java:54) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.terms.StringTermsAggregator$1.collect(StringTermsAggregator.java:81) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.AggregatorFactory$MultiBucketAggregatorWrapper$1.collect(AggregatorFactory.java:140) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.BestBucketsDeferringCollector.prepareSelectedBuckets(BestBucketsDeferringCollector.java:178) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.DeferringBucketCollector.replay(DeferringBucketCollector.java:44) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.DeferableBucketAggregator.runDeferredCollections(DeferableBucketAggregator.java:91) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.bucket.terms.LongTermsAggregator.buildAggregation(LongTermsAggregator.java:155) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.aggregations.AggregationPhase.execute(AggregationPhase.java:129) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.query.QueryPhase.execute(QueryPhase.java:116) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService.loadOrExecuteQueryPhase(SearchService.java:301) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:334) ~[elasticsearch-6.1.1.jar:6.1.1]
              at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:310) ~[elasticsearch-6.1.1.jar:6.1.1]
              ... 9 more
      

      This is the defined type:

      Elasticsearch Type Import
      curl -vv -X PUT -H "Content-Type: application/json" http://localhost:9200/uint -d '{
         "settings" : {
            "index" : {
               "number_of_replicas" : 1,
               "number_of_shards" : 5
            }
         },
         "mappings" : {
            "values" : {
               "properties" : {
                  "itemid" : {
                     "type" : "long"
                  },
                  "clock" : {
                     "format" : "epoch_second",
                     "type" : "date"
                  },
                  "value" : {
                     "type" : "long"
                  }
               }
            }
         }
      }'
      

            Unassigned Unassigned
            syepes Sebastian YEPES
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: