Term_stats return sometime return meaningless number


(youwei chen) #1

Our elasticsearch instance sometime return meaningless number for
terms_stats, query return correct data.

I am using Kibana as front end, this is generated query:

{"facets":{"terms":{"terms_stats":{"value_field":"metric","key_field":"host","size":10,"order":"count"},"facet_filter":{"fquery":{"query":{"filtered":{"query":{"bool":{"should":[{"query_string":{"query":"(service:".StorageProxy.RecentReadLatencyMicros")
AND (layer:"cassandra") AND (@timestamp:[now-1m TO now]) AND
host:169.26.4.167"}}]}},"filter":{"bool":{"must":[{"range":{"@timestamp":{"from":1408992976055,"to":"now"}}},{"terms":{"host":["169.26.4.167"]}},{"terms":{"host":["169.26.4.167"]}}]}}}}}}}},"size":0}

max=4.6366831074216192E+18
mean=1.5455610358072064E+18
min=0
term=169.26.4.167
total=4.6366831074216192E+18

the metric field would have some number between 0 and 100 while the term
stat report huge number. If i delete index, it will show correct term
stats again.

I tried refresh, close/open index, none seem to work except delete the
index and recreate it. Have anyone face similar issue?

Thanks.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5e141e56-7e01-4899-949f-c3d7f69a353d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(youwei chen) #2

Additional information:

take mean of boolean value return 4,607,182,418,800,017,408

Thanks

On Tuesday, August 26, 2014 3:58:43 PM UTC-4, youwei chen wrote:

Our elasticsearch instance sometime return meaningless number for
terms_stats, query return correct data.

I am using Kibana as front end, this is generated query:

{"facets":{"terms":{"terms_stats":{"value_field":"metric","key_field":"host","size":10,"order":"count"},"facet_filter":{"fquery":{"query":{"filtered":{"query":{"bool":{"should":[{"query_string":{"query":"(service:".StorageProxy.RecentReadLatencyMicros")
AND (layer:"cassandra") AND (@timestamp:[now-1m TO now]) AND
host:169.26.4.167"}}]}},"filter":{"bool":{"must":[{"range":{"@timestamp":{"from":1408992976055,"to":"now"}}},{"terms":{"host":["169.26.4.167"]}},{"terms":{"host":["169.26.4.167"]}}]}}}}}}}},"size":0}

max=4.6366831074216192E+18
mean=1.5455610358072064E+18
min=0
term=169.26.4.167
total=4.6366831074216192E+18

the metric field would have some number between 0 and 100 while the term
stat report huge number. If i delete index, it will show correct term
stats again.

I tried refresh, close/open index, none seem to work except delete the
index and recreate it. Have anyone face similar issue?

Thanks.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/781d0077-93d4-4d1d-93ca-953e84704964%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Jaspal Banwait) #3

Has anyone else seen this and resolved it as I am facing the same issue. The only way I have managed to fix this is to delete all the indexes which is not ideal. This is us from using this in live as this is less than ideal.


(system) #4