# ElasticSearch produces failures during query execution

**URL:** <https://discuss.elastic.co/t/elasticsearch-produces-failures-during-query-execution/7247>\
**Category:** Elasticsearch\
**Created:** [April 6, 2012, 3:55am UTC](https://discuss.elastic.co/t/elasticsearch-produces-failures-during-query-execution/7247 "2012-04-06T03:55:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mikhail\_Berezovsky](https://avatars.discourse-cdn.com/v4/letter/m/8edcca/32.png) [@Mikhail\_Berezovsky](https://discuss.elastic.co/u/Mikhail_Berezovsky)\
**Post date:** [April 6, 2012, 3:55am UTC](https://discuss.elastic.co/t/elasticsearch-produces-failures-during-query-execution/7247/1 "2012-04-06T03:55:51Z")

</div>

Hello.  
I try to complete the following query, but the elasticsearch engine  
returns to me strange results. Fiddler shows that the engine generates  
some failures (see later).  
How I can rebuild the query to get correct result?

The Query:  
{  
"min\_score":0.09,  
"query":{  
"bool":{  
"should":[  
{  
"filtered":{  
"query":{  
"text":{  
"name":{  
"query":"",  
"type":"phrase\_prefix",  
"operator":"or",  
"fuzziness":1,  
"prefix\_length":0,  
"boost":2  
}  
}  
},  
"filter":{  
"nested":{  
"path":"recalls",  
"query":{  
"bool":{  
"must":[  
{  
"term":{  
"recalls.atMorning":"true"  
}  
}  
]  
}  
},  
"\_cache":true  
}  
}  
}  
},  
{  
"filtered":{  
"query":{  
"match\_all":{

```
                 }
              },
              "filter":{
                 "nested":{
                    "path":"recalls",
                    "query":{
                       "bool":{
                          "must":[
                             {
                                "term":{
                                   "recalls.atMorning":"true"
                                }
                             }
                          ]
                       }
                    },
                    "_cache":true
                 }
              }
           }
        }
     ]
  }

```

},  
"from":0,  
"size":50  
}

Results:

{  
"took" : 0,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 5,  
"successful" : 4,  
"failed" : 1,  
"failures" : [ {  
"index" : "cards\_bmv",  
"shard" : 1,  
"status" : 500,  
"reason" : "QueryPhaseExecutionException[[cards\_bmv][1]:  
query[filtered(MatchNoDocsQuery)-\>QueryWrapperFilter(BlockJoinQuery  
(filtered(+recalls.date:[1333324800000 TO \*] +recalls.atMorning:T)-

> FilterCacheFilterWrapper(\_type:\_\_recalls)))  
> ConstantScore(QueryWrapperFilter(BlockJoinQuery  
> (filtered(+recalls.date:[1333324800000 TO \*] +recalls.atMorning:T)-  
> FilterCacheFilterWrapper(\_type:\_\_recalls))))],from[0],size[50]: Query  
> Failed [Failed to execute main query]]; nested: "  
> } ]  
> },  
> "hits" : {  
> "total" : 2,  
> "max\_score" : 0.5,  
> "hits" : [ {  
> "\_index" : "cards\_bmv",  
> "\_type" : "cards",  
> "\_id" : "172",  
> ...

---

<div class="post-metadata">

**Author:** ![kimchy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kimchy/32/44952_2.png) [@kimchy](https://discuss.elastic.co/u/kimchy)\
**Post date:** [April 8, 2012, 6:06pm UTC](https://discuss.elastic.co/t/elasticsearch-produces-failures-during-query-execution/7247/2 "2012-04-08T18:06:34Z")

</div>

There should be a failure in the log itself of elasticsearch, can you gist  
it?

On Fri, Apr 6, 2012 at 6:55 AM, Mikhail Berezovsky \<  
[mikhail.berezovsky@gmail.com](mailto:mikhail.berezovsky@gmail.com)\> wrote:

> Hello.  
> I try to complete the following query, but the elasticsearch engine  
> returns to me strange results. Fiddler shows that the engine generates  
> some failures (see later).  
> How I can rebuild the query to get correct result?
> 
> The Query:  
> {  
> "min\_score":0.09,  
> "query":{  
> "bool":{  
> "should":[  
> {  
> "filtered":{  
> "query":{  
> "text":{  
> "name":{  
> "query":"",  
> "type":"phrase\_prefix",  
> "operator":"or",  
> "fuzziness":1,  
> "prefix\_length":0,  
> "boost":2  
> }  
> }  
> },  
> "filter":{  
> "nested":{  
> "path":"recalls",  
> "query":{  
> "bool":{  
> "must":[  
> {  
> "term":{  
> "recalls.atMorning":"true"  
> }  
> }  
> ]  
> }  
> },  
> "\_cache":true  
> }  
> }  
> }  
> },  
> {  
> "filtered":{  
> "query":{  
> "match\_all":{
> 
> ```
> }
> },
> "filter":{
> "nested":{
> "path":"recalls",
> "query":{
> "bool":{
> "must":[
> {
> "term":{
> "recalls.atMorning":"true"
> }
> }
> ]
> }
> },
> "_cache":true
> }
> }
> }
> }
> ]
> }
> 
> ```
> 
> },  
> "from":0,  
> "size":50  
> }
> 
> Results:
> 
> {  
> "took" : 0,  
> "timed\_out" : false,  
> "\_shards" : {  
> "total" : 5,  
> "successful" : 4,  
> "failed" : 1,  
> "failures" : [ {  
> "index" : "cards\_bmv",  
> "shard" : 1,  
> "status" : 500,  
> "reason" : "QueryPhaseExecutionException[[cards\_bmv][1]:  
> query[filtered(MatchNoDocsQuery)-\>QueryWrapperFilter(BlockJoinQuery  
> (filtered(+recalls.date:[1333324800000 TO \*] +recalls.atMorning:T)-
> 
> > FilterCacheFilterWrapper(\_type:\_\_recalls)))  
> > ConstantScore(QueryWrapperFilter(BlockJoinQuery  
> > (filtered(+recalls.date:[1333324800000 TO \*] +recalls.atMorning:T)-  
> > FilterCacheFilterWrapper(\_type:\_\_recalls))))],from[0],size[50]: Query  
> > Failed [Failed to execute main query]]; nested: "  
> > } ]  
> > },  
> > "hits" : {  
> > "total" : 2,  
> > "max\_score" : 0.5,  
> > "hits" : [ {  
> > "\_index" : "cards\_bmv",  
> > "\_type" : "cards",  
> > "\_id" : "172",  
> > ...

---

<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:33am UTC](https://discuss.elastic.co/t/elasticsearch-produces-failures-during-query-execution/7247/3 "2017-07-06T03:33:13Z")

</div>