# \_shards problem when create query

**URL:** <https://discuss.elastic.co/t/-shards-problem-when-create-query/25975>\
**Category:** Elasticsearch\
**Created:** [July 21, 2015, 10:36am UTC](https://discuss.elastic.co/t/-shards-problem-when-create-query/25975 "2015-07-21T10:36:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Smasell](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/smasell/32/43483_2.png) [@Smasell](https://discuss.elastic.co/u/Smasell)\
**Post date:** [July 21, 2015, 10:36am UTC](https://discuss.elastic.co/t/-shards-problem-when-create-query/25975/1 "2015-07-21T10:36:41Z")

</div>

Hi!!! I have response like this, when I create a query  
{  
"took": 3568,  
"timed\_out": false,  
"\_shards": {  
"total": 20,  
"successful": 10,  
"failed": 10,  
"failures": [  
{  
"index": "mygame",  
"shard": 0,  
"status": 500,  
"reason": "QueryPhaseExecutionException[[mygame][0]: query[filtered(message:craftcard)-\>cache(\_type:logs)],from[0],size[10],sort[\<custom:"@timestamp": org.elasticsearch.index.fielddata.fieldcomparator.LongValuesComparatorSource@4ef480a\>!]: Query Failed [Failed to execute main query]]; nested: ElasticsearchException[org.elasticsearch.common.breaker.CircuitBreakingException: [PARENT] Data too large, data for [@timestamp] would be larger than limit of [17990051430/16.7gb]]; nested: UncheckedExecutionException[org.elasticsearch.common.breaker.CircuitBreakingException: [PARENT] Data too large, data for [@timestamp] would be larger than limit of [17990051430/16.7gb]]; nested: CircuitBreakingException[[PARENT] Data too large, data for [@timestamp] would be larger than limit of [17990051430/16.7gb]]; "  
},  
what is the problem?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 23, 2015, 6:48am UTC](https://discuss.elastic.co/t/-shards-problem-when-create-query/25975/2 "2015-07-23T06:48:06Z")

</div>

> [@Smasell](#):
>
> Data too large, data for [@timestamp] would be larger than limit of [17990051430/16.7gb]

See [https://www.elastic.co/guide/en/elasticsearch/reference/current/index-modules-fielddata.html#circuit-breaker](https://www.elastic.co/guide/en/elasticsearch/reference/current/index-modules-fielddata.html#circuit-breaker)

Basically you have too much data for the amount of heap you have.

---

<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 5, 2017, 11:59pm UTC](https://discuss.elastic.co/t/-shards-problem-when-create-query/25975/3 "2017-07-05T23:59:44Z")

</div>