# \[es/search\] failed: \[search\_phase\_execution\_exception\] all shards failed
**URL:** https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428
**Category:** Elasticsearch
**Tags:** language-clients
**Created:** [June 7, 2023, 10:05am UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428 "2023-06-07T10:05:59Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@FTOR](https://discuss.elastic.co/u/FTOR)
#### Post date: [June 7, 2023, 10:05am UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/1 "2023-06-07T10:05:59Z")
Hello,
I would like to get documents from an index that contains a huge number of data ~ (1 million).
I am using ElasticSearchClient to connect and get information from Elasticsearch. I tested the solution with a small number of data and it works well. But I got an error while testing with size(105000). Do you have an idea how to solve the problem ?
Below the implementation of the connexion, the request query and the error
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 7, 2023, 11:02pm UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/2 "2023-06-07T23:02:46Z")
Please don't post pictures of text, logs or code. They are difficult to read, impossible to search and replicate (if it's code), and some people may not be even able to see them 🙂
---
### Author:  [@FTOR](https://discuss.elastic.co/u/FTOR)
#### Post date: [June 8, 2023, 8:40am UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/3 "2023-06-08T08:40:07Z")
Ok thank you I take note. I updated some parameter setting on the index in order to enhance the result window.
PUT /MyIndex/\_settings
{
"index" : {
"max\_result\_window" : 2100000
}
}
I updated the request on the code in order to get the total hits : .trackTotalHits(t-\>t.enabled(true))
SearchResponse response = client.search(s -\> s
.index(index)
.size(1900000)
.trackTotalHits(t-\>t.enabled(true))
.query(QueryBuilders.matchAll().build().\_toQuery())
,
MyClass.class
);
I get more documents but it's not enough comparing to the number of documents on Elasticsearch
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [June 8, 2023, 8:45am UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/4 "2023-06-08T08:45:16Z")
What is the specification of your cluster? How much heap do you have assigned?
Increasing that limit will put a lot more load on the cluster and it is not clear it is able to handle this. Is there anything in the Elasticsearch logs?
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [June 8, 2023, 9:03am UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/5 "2023-06-08T09:03:03Z")
You can use:
- the [`size` and `from` parameters](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-from-size.html) to display by default up to 10000 records to your users. If you want to change this limit, you can change `index.max_result_window` setting but be aware of the consequences (ie memory).
- the [search after](https://www.elastic.co/guide/en/elasticsearch/reference/current/paginate-search-results.html#search-after) feature to do deep pagination.
- the [Scroll API](https://www.elastic.co/guide/en/elasticsearch/reference/current/paginate-search-results.html#scroll-search-results) if you want to extract a resultset to be consumed by another tool later. (Not recommended anymore)
---
### Author:  [@FTOR](https://discuss.elastic.co/u/FTOR)
#### Post date: [June 12, 2023, 1:30pm UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/6 "2023-06-12T13:30:41Z")
> [@dadoonet](#):
>
> - display by default up to 10000 records to your users. If you want to change this limit, you can change `index.max_result_window` setting but be aware of the consequences (ie memory).
> - the [search after](https://www.elastic.co/guide/en/elasticsearch/reference/current/paginate-search-results.html#search-after) feature to do deep pagination.
Thank you for your response !
I tried the search after with a PIT. However, I faced two issues : time performance and total number is not enough
1. Time performance: The query on dev tools takes 4s. On the other hand, it takes 10s in the java API.
2. I don't get the exact number of documents on Elasticsearch index. I think the query does not consider duplicates
---
### Author:  [@FTOR](https://discuss.elastic.co/u/FTOR)
#### Post date: [June 12, 2023, 1:31pm UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/7 "2023-06-12T13:31:52Z")
I can not change the parameters of the cluster. They are fixed by the architects
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2023, 1:32pm UTC](https://discuss.elastic.co/t/es-search-failed-search-phase-execution-exception-all-shards-failed/335428/8 "2023-07-10T13:32:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.