# ElasticSearch Cutodd Limit

**URL:** <https://discuss.elastic.co/t/elasticsearch-cutodd-limit/221390>\
**Category:** Elasticsearch\
**Created:** [February 28, 2020, 8:42am UTC](https://discuss.elastic.co/t/elasticsearch-cutodd-limit/221390 "2020-02-28T08:42:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aditya2](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@Aditya2](https://discuss.elastic.co/u/Aditya2)\
**Post date:** [February 28, 2020, 8:42am UTC](https://discuss.elastic.co/t/elasticsearch-cutodd-limit/221390/1 "2020-02-28T08:42:34Z")

</div>

I am trying to push data from a database to ElasticSearch. The records is in Json format and each records is of about 300 lines. I am trying to push about 1000 records. The ElasticSearch shows only 9-10 records. Is there a Threshold limit to the no of records in ElasticSearch?

---

<div class="post-metadata">

**Author:** ![HenningAndersen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/henningandersen/32/48188_2.png) [@HenningAndersen](https://discuss.elastic.co/u/HenningAndersen)\
**Post date:** [February 28, 2020, 10:05am UTC](https://discuss.elastic.co/t/elasticsearch-cutodd-limit/221390/2 "2020-02-28T10:05:09Z")

</div>

Hi @Aditya2,

there are limits, but not in that range. An index is divided into shards and each shard can maximum hold around 2 billion docs (2^31-1).

Elasticsearch will report back errors if there are issues with any of the docs. Are you using the `_bulk` API or the index API? If using the `_bulk` API, notice that it will return an outer level 200 OK even if there are errors. It then returns a separate status code per doc in the response, see [Bulk API](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-bulk.html).

Also notice that the `_bulk` API has special requirements around line breaks.

Can you elaborate a bit on how data are pushed from the database to Elasticsearch?

---

<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 27, 2020, 10:07am UTC](https://discuss.elastic.co/t/elasticsearch-cutodd-limit/221390/3 "2020-03-27T10:07:16Z")

</div>

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