# \[FIELDDATA\] Data too large, data for \[cubeId\] would be larger than limit of \[155713536/148.5mb\]\];

**URL:** https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086
**Category:** Elasticsearch
**Created:** [December 29, 2015, 4:50am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086 "2015-12-29T04:50:00Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![LDA-MAN](https://avatars.discourse-cdn.com/v4/letter/l/a3d4f5/32.png) [@LDA-MAN](https://discuss.elastic.co/u/LDA-MAN)
#### Post date: [December 29, 2015, 4:50am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/1 "2015-12-29T04:50:00Z")

</div>

when i search index and use aggregation ，i got this problem which i never catch and use normal before!  
the full exception like this:  
2015-12-29 12:45:38 ERROR com.eps.search.service.indicator.IndicatorServiceImpl[http-bio-8080-exec-2] 3670133 ms - searchIndicatorResult.error---  
org.elasticsearch.action.search.SearchPhaseExecutionException: Failed to execute phase [query], all shards failed; shardFailures {[vCSoIfjWTs2Pk\_j6Kno9RQ][fact\_indicator][0]: ElasticsearchException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: UncheckedExecutionException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: CircuitBreakingException[[FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; }{[vCSoIfjWTs2Pk\_j6Kno9RQ][fact\_indicator][1]: ElasticsearchException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: UncheckedExecutionException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: CircuitBreakingException[[FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; }{[vCSoIfjWTs2Pk\_j6Kno9RQ][fact\_indicator][2]: ElasticsearchException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: UncheckedExecutionException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: CircuitBreakingException[[FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; }{[vCSoIfjWTs2Pk\_j6Kno9RQ][fact\_indicator][3]: ElasticsearchException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: UncheckedExecutionException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: CircuitBreakingException[[FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; }{[vCSoIfjWTs2Pk\_j6Kno9RQ][fact\_indicator][4]: ElasticsearchException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: UncheckedExecutionException[org.elasticsearch.common.breaker.CircuitBreakingException: [FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; nested: CircuitBreakingException[[FIELDDATA] Data too large, data for [cubeId] would be larger than limit of [155713536/148.5mb]]; }  
at org.elasticsearch.action.search.type.TransportSearchDfsQueryThenFetchAction$AsyncAction.onQueryFailure(TransportSearchDfsQueryThenFetchAction.java:137)  
at org.elasticsearch.action.search.type.TransportSearchDfsQueryThenFetchAction$AsyncAction$1.onFailure(TransportSearchDfsQueryThenFetchAction.java:118)  
at org.elasticsearch.search.action.SearchServiceTransportAction$23.run(SearchServiceTransportAction.java:565)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)  
at java.lang.Thread.run(Thread.java:745)

 ![](https://us1.discourse-cdn.com/elastic/original/2X/f/f6b722851423877c799c654389bcdc352a59bba9.png)  
 ![](https://us1.discourse-cdn.com/elastic/original/2X/4/4c84eead2c5d953226739d77d944bb6e4192f4f8.png)

---

<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: [December 29, 2015, 4:51am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/2 "2015-12-29T04:51:30Z")

</div>

You need add more heap or query less data.

---

<div class="post-metadata">

### Author: ![LDA-MAN](https://avatars.discourse-cdn.com/v4/letter/l/a3d4f5/32.png) [@LDA-MAN](https://discuss.elastic.co/u/LDA-MAN)
#### Post date: [December 29, 2015, 5:08am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/3 "2015-12-29T05:08:05Z")

</div>

thanks,but i use this method normally before and never occur it.

where can i set the heap for my query memory？ is in the elasticsearch.yml?

the problem is i query my data and set size 15 already...  
one time,i query and the keyword is [null.is](http://null.is) this occur the problem ?

---

<div class="post-metadata">

### Author: ![LDA-MAN](https://avatars.discourse-cdn.com/v4/letter/l/a3d4f5/32.png) [@LDA-MAN](https://discuss.elastic.co/u/LDA-MAN)
#### Post date: [December 29, 2015, 5:11am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/4 "2015-12-29T05:11:24Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/2X/c/cf0d368a5b8a319476e66fc9cf119cf3c180f147.png)

---

<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: [December 29, 2015, 5:11am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/5 "2015-12-29T05:11:52Z")

</div>

Please don't attach images, copy the text.

How did you install ES?

---

<div class="post-metadata">

### Author: ![LDA-MAN](https://avatars.discourse-cdn.com/v4/letter/l/a3d4f5/32.png) [@LDA-MAN](https://discuss.elastic.co/u/LDA-MAN)
#### Post date: [December 29, 2015, 5:13am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/6 "2015-12-29T05:13:41Z")

</div>

sorry..

ES\_CLASSPATH=$ES\_CLASSPATH:$ES\_HOME/lib/elasticsearch-1.7.1.jar:$ES\_HOME/lib/_:$ES\_HOME/lib/sigar/_

if ["x$ES\_MIN\_MEM" = "x"]; then  
ES\_MIN\_MEM=256m  
fi  
if ["x$ES\_MAX\_MEM" = "x"]; then  
ES\_MAX\_MEM=2g  
fi  
if ["x$ES\_HEAP\_SIZE" != "x"]; then  
ES\_MIN\_MEM=$ES\_HEAP\_SIZE  
ES\_MAX\_MEM=$ES\_HEAP\_SIZE  
fi

---

<div class="post-metadata">

### Author: ![LDA-MAN](https://avatars.discourse-cdn.com/v4/letter/l/a3d4f5/32.png) [@LDA-MAN](https://discuss.elastic.co/u/LDA-MAN)
#### Post date: [December 29, 2015, 5:15am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/7 "2015-12-29T05:15:18Z")

</div>

and i install it with elasticsearch-1.7.1.tar.gz in centos 7.0 and just unzip it .  
start it whit a elasticsearch-service.

---

<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: [December 29, 2015, 6:14am UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/8 "2015-12-29T06:14:14Z")

</div>

You should really use the RPM, it includes things like standard install, config and logging directories as well as service wrappers.

---

<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:28pm UTC](https://discuss.elastic.co/t/fielddata-data-too-large-data-for-cubeid-would-be-larger-than-limit-of-155713536-148-5mb/38086/9 "2017-07-05T23:28:11Z")

</div>


