# Shards Failed on geoip

**URL:** https://discuss.elastic.co/t/shards-failed-on-geoip/220050
**Category:** Kibana
**Created:** [February 19, 2020, 6:56pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050 "2020-02-19T18:56:48Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![fastxl](https://avatars.discourse-cdn.com/v4/letter/f/85e7bf/32.png) [@fastxl](https://discuss.elastic.co/u/fastxl)
#### Post date: [February 19, 2020, 6:56pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/1 "2020-02-19T18:56:48Z")

</div>

Have had ELK up and running now for a few days. All was working just fine. Today however and am getting the attached error and data isn't showing up in 2 panels.

 ![kibana-shards-faild](https://us1.discourse-cdn.com/elastic/original/3X/7/1/71fb07275a3ed750a7fbc7797f4aa191f73b8298.jpeg)

When I try to click on Show Details it's a dead link. How can I trouble shoot this?

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [February 19, 2020, 7:00pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/2 "2020-02-19T19:00:10Z")

</div>

You may be able to use the Kibana inspector or the Network tab of the browser developer tools to capture the request that is causing problems.

---

<div class="post-metadata">

### Author: ![fastxl](https://avatars.discourse-cdn.com/v4/letter/f/85e7bf/32.png) [@fastxl](https://discuss.elastic.co/u/fastxl)
#### Post date: [February 19, 2020, 8:35pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/3 "2020-02-19T20:35:06Z")

</div>

When doing some Inspecting I see this error

> "java.util.concurrent.ExecutionException: CircuitBreakingException[[fielddata] Data too large, data for [\_id] would be [420863022/401.3mb], which is larger than the limit of [415550668/396.2mb]]",

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [February 19, 2020, 8:46pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/4 "2020-02-19T20:46:57Z")

</div>

Okay, this is a common issue when aggregating on `_id`. Take a look at this: [https://github.com/elastic/elasticsearch/issues/43599](https://github.com/elastic/elasticsearch/issues/43599)

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [February 19, 2020, 8:53pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/5 "2020-02-19T20:53:34Z")

</div>

We also recommend against aggregating on the `_id` field in general [https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-id-field.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-id-field.html)

---

<div class="post-metadata">

### Author: ![fastxl](https://avatars.discourse-cdn.com/v4/letter/f/85e7bf/32.png) [@fastxl](https://discuss.elastic.co/u/fastxl)
#### Post date: [February 20, 2020, 12:41pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/6 "2020-02-20T12:41:35Z")

</div>

Thanks for the direction. I am a bit new at this and not quite sure how to handle fixing it. How would I duplicate the \_id field to another?

```
{
  "aggs": {
    "2": {
      "terms": {
        "field": "geoip.country_name.keyword",
        "order": {
          "1": "desc"
        },
        "size": 5
      },
      "aggs": {
        "1": {
          "cardinality": {
            "field": "_id"
          }
        }
      }
    }
  },
```

---

<div class="post-metadata">

### Author: ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [February 20, 2020, 2:28pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/7 "2020-02-20T14:28:32Z")

</div>

You can't do this in your query, you would need to change your mapping. Unfortunately I don't know how to set this up, but my guess is that it involves the copy\_to parameter: [https://www.elastic.co/guide/en/elasticsearch/reference/current/copy-to.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/copy-to.html)

---

<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: [March 19, 2020, 2:40pm UTC](https://discuss.elastic.co/t/shards-failed-on-geoip/220050/8 "2020-03-19T14:40:23Z")

</div>

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