-
Incident report
-
Resolution: Duplicate
-
Trivial
-
None
-
3.4.5
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" } } } } }'
- duplicates
-
ZBX-13276 Empty Graphs in Web with history data in elasticsearch
- Closed