# Terms list might be incomplete because the request is taking to long

**URL:** <https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768>\
**Category:** Kibana\
**Created:** [May 1, 2020, 9:24pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768 "2020-05-01T21:24:37Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 1, 2020, 9:24pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/1 "2020-05-01T21:24:37Z")

</div>

Hello guys,  
Can you help me to fix this error  
terms list might be incomplete because the request is taking to long. Adjust the autocomplete settings in kibana.yml for complete results.  
Im using kibana with 16 RAM to visualize 1 G of data .

Thank you

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 1, 2020, 11:56pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/2 "2020-05-01T23:56:30Z")

</div>

Hello @Fedi_Ben_Messaoud

Can you tell the version of the Elastic Stack you're using?  
Is this happening when you are typing on the Kibana search bar?

We're aware of a possible regression on 7.6.0 and fixed on 7.6.1 ([https://github.com/elastic/kibana/pull/58784](https://github.com/elastic/kibana/pull/58784)).

Other reasons might be an overwhelmed Elasticsearch cluster.  
Could you please share the output of:

- `GET _cat/fielddata?v`
- `GET _cat/nodes?v&h=*`
- `GET _cat/indices?s=index&v`

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 2, 2020, 12:09am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/3 "2020-05-02T00:09:03Z")

</div>

I get this problem when i try to get values into a select list .. i can t get all values from my data. and my elastic version is 7.6.1.

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 2, 2020, 12:10am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/4 "2020-05-02T00:10:37Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/b/a/ba0e7e9071e4dbab97d1be0e94511b3e6af2af9d.png)

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 2, 2020, 12:27am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/5 "2020-05-02T00:27:04Z")

</div>

Can you please try to run this request on Dev Tools and paste here the full response?

```auto
GET openmedic/_search
{
  "size": 0,
  "aggs": {
    "annees": {
      "terms": {
        "field": "ANNEE.keyword",
        "size": 5
      }
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 2, 2020, 12:37am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/6 "2020-05-02T00:37:15Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/e/e/ee3d73c3fdf99de01e3c92948ef66ff1f0794f4a.png)

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 2, 2020, 12:39am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/7 "2020-05-02T00:39:07Z")

</div>

I think your problem was just temporary... The request takes only 122 ms.

If your Elasticsearch cluster & Kibana are running locally, it might happen that other processes running on your computer stole some resources.

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 2, 2020, 12:47am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/8 "2020-05-02T00:47:38Z")

</div>

11 G of memory are free 😕

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 2, 2020, 12:56am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/9 "2020-05-02T00:56:46Z")

</div>

The query I've asked to run simulates what the `Control` visualization is doing behind the scenes.

It returned in 122ms.

The message popup shows up when the `Control` visualization takes more than 1 second to be generated.

Does the warning shows up when you add the `Control` visualization in a dashboard?  
Or it was just a message which showed up just once?

If you want, in `kibana.yml` you can set `kibana.autocompleteTimeout: 10000`.

I do not know your configuration but if they're installed locally this is clearly a development setup.  
There are your browser and your desktop environment running.

I've suggested to share the results of few commands to understand your current setup.  
Did you increase the JVM Heap to 1 or 2 GB? Or you're running with default settings?

Hope it helps.

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 2, 2020, 1:23am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/10 "2020-05-02T01:23:22Z")

</div>

The problem is that i can t get all years and the problem still exist when i add the visualisation in the dashboard .

Yes i increased th elastic jvm to 4 Gb but i still have the same problem

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/9/e95b445debd999e044e84094097e89a49b17eb80.png)

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 2, 2020, 1:37am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/11 "2020-05-02T01:37:47Z")

</div>

> [@Fedi\_Ben\_Messaoud](#):
>
> The problem is that i can t get all years and the problem still exist when i add the visualisation in the dashboard .

I think you do not see all the years because you are saving the visualization with some filters already set (see at the top, below the search bar)

The query I've run is limited to 5 years and it matches all the documents. There are only 3 distinct years in all the documents of the index.

You opened this post to ask about the warning message.  
I am trying to help and explained why it shows up.

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 2, 2020, 2:03am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/12 "2020-05-02T02:03:43Z")

</div>

There is no filters.  
Thank you for your help 🙂

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 2, 2020, 9:48am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/13 "2020-05-02T09:48:08Z")

</div>

I need a screenshot or something to troubleshoot

---

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 6, 2020, 7:27am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/14 "2020-05-06T07:27:58Z")

</div>

I'm also facing the same issue, for me also, it doesn't seem like it's taking that long to load the list. Plus, I've also tried increasing the kibana.autocompleteTerminateAfter and kibana.autocompleteTimeout values.  
@Fedi_Ben_Messaoud Can you please inform me about the solution in case you've resolved this issue?

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 6, 2020, 3:54pm UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/15 "2020-05-06T15:54:20Z")

</div>

Sorry i didn t resolve the problem.

---

<div class="post-metadata">

**Author:** ![Pablo95](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@Pablo95](https://discuss.elastic.co/u/Pablo95)\
**Post date:** [May 9, 2020, 11:48am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/16 "2020-05-09T11:48:26Z")

</div>

I had the same problem, but what i just do was to unselect "Dynamic Options" option and set the number of options (Size) I wanted to show.

That solve the problem for me. Hope that can help you too. @Fedi_Ben_Messaoud

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 10, 2020, 1:22am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/17 "2020-05-10T01:22:01Z")

</div>

Hello guys .  
The solution is to set kibana.autocompleteTerminateAfter to the number of documents in your index.  
kibana.autocompleteTerminateAfter is the number of documents per shard.  
For exemple if you have 1 shard and one million documents in your index you should add this line in your kibana.yml  
kibana.autocompleteTerminateAfter: 1000000

---

<div class="post-metadata">

**Author:** ![Fedi\_Ben\_Messaoud](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fedi_ben_messaoud/32/67544_2.png) [@Fedi\_Ben\_Messaoud](https://discuss.elastic.co/u/Fedi_Ben_Messaoud)\
**Post date:** [May 10, 2020, 1:34am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/18 "2020-05-10T01:34:20Z")

</div>

Hello you can try this solution.  
Hope that can help you too

---

<div class="post-metadata">

**Author:** ![Jaishree\_Pal](https://avatars.discourse-cdn.com/v4/letter/j/f475e1/32.png) [@Jaishree\_Pal](https://discuss.elastic.co/u/Jaishree_Pal)\
**Post date:** [May 11, 2020, 11:33am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/19 "2020-05-11T11:33:40Z")

</div>

Thanks @Fedi_Ben_Messaoud. My problem is also resolved now.

---

<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:** [June 8, 2020, 11:33am UTC](https://discuss.elastic.co/t/terms-list-might-be-incomplete-because-the-request-is-taking-to-long/230768/20 "2020-06-08T11:33:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
