# Inconsistent facet results

**URL:** <https://discuss.elastic.co/t/inconsistent-facet-results/8850>\
**Category:** Elasticsearch\
**Created:** [August 26, 2012, 11:44am UTC](https://discuss.elastic.co/t/inconsistent-facet-results/8850 "2012-08-26T11:44:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aromasca](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aromasca/32/2756_2.png) [@aromasca](https://discuss.elastic.co/u/aromasca)\
**Post date:** [August 26, 2012, 11:44am UTC](https://discuss.elastic.co/t/inconsistent-facet-results/8850/1 "2012-08-26T11:44:56Z")

</div>

Hi, we are running a 7 machine cluster in EC2 and when were expirencing a  
little inconsistency when we run the same query against a different machine.  
We have a load balancer in front so each request is handled by a different  
node, however we are getting about 5% mismatch with the facets.  
We have tried flushing the index, and clearing the index cache but none of  
these help and the facet counts still change from node to node.

here is an example query:

{  
"filtered" : {  
"query" : {  
"term" : {  
"tem1" : "abcde-fghijk"  
}  
},  
"filter" : {  
"range" : {  
"timestamp" : {  
"from" : 1325368800000,  
"to" : 1345496399999  
}  
}  
}  
}  
},  
"facets" : {  
"tab\_types" : {  
"terms" : {  
"field" : "pageType",  
"size" : 20  
}  
}  
}

--

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [August 26, 2012, 12:54pm UTC](https://discuss.elastic.co/t/inconsistent-facet-results/8850/2 "2012-08-26T12:54:59Z")

</div>

I have already seen this some weeks ago.  
One of my node had inconsistent data. I stopped the node, let the shards been replicated in the cluster, delete data dir and restart ES.

But, if you are unlucky, you will perhaps have to reindex...

HTH

--  
David 😉  
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 26 août 2012 à 13:44, aromasca [aromasca@gmail.com](mailto:aromasca@gmail.com) a écrit :

> Hi, we are running a 7 machine cluster in EC2 and when were expirencing a little inconsistency when we run the same query against a different machine.  
> We have a load balancer in front so each request is handled by a different node, however we are getting about 5% mismatch with the facets.  
> We have tried flushing the index, and clearing the index cache but none of these help and the facet counts still change from node to node.
> 
> here is an example query:
> 
> ## { "filtered" : { "query" : { "term" : { "tem1" : "abcde-fghijk" } }, "filter" : { "range" : { "timestamp" : { "from" : 1325368800000, "to" : 1345496399999 } } } } }, "facets" : { "tab\_types" : { "terms" : { "field" : "pageType", "size" : 20 } } }

--

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 3:15am UTC](https://discuss.elastic.co/t/inconsistent-facet-results/8850/3 "2017-07-06T03:15:01Z")

</div>

Closed on July 6, 2017, 3:15am UTC