# ES jdbc river problem

**URL:** <https://discuss.elastic.co/t/es-jdbc-river-problem/19505>\
**Category:** Elasticsearch\
**Created:** [August 28, 2014, 9:03am UTC](https://discuss.elastic.co/t/es-jdbc-river-problem/19505 "2014-08-28T09:03:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zubair](https://avatars.discourse-cdn.com/v4/letter/z/848f3c/32.png) [@zubair](https://discuss.elastic.co/u/zubair)\
**Post date:** [August 28, 2014, 9:03am UTC](https://discuss.elastic.co/t/es-jdbc-river-problem/19505/1 "2014-08-28T09:03:48Z")

</div>

I am trying to feed data into Elastic Search using jdbc river but this river is not getting all the data. I have 450000 records in MySQL table but in ES i get only about 230000 records.

Here is my ES river setting:

curl -XPUT 'localhost:9200/\_river/my\_jdbc\_river/\_meta' -d '{  
"type" : "jdbc",  
"jdbc" : {  
"url" : "jdbc:mysql://localhost:3306/test",  
"user" : "test",  
"password" : "test",  
"sql" : "select \* from test" },  
"index":{  
"index" : "test",  
"bulk\_size":600,  
"max\_bulk\_requests":10,  
"bulk\_timeout":"5s",  
"autocommit":"true"  
}  
}'  
I have looked in Elastic Search documentation but i could not find the solution. I am using river-jdbc-1.1.0.2 version.

---

<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 6, 2017, 1:05am UTC](https://discuss.elastic.co/t/es-jdbc-river-problem/19505/2 "2017-07-06T01:05:50Z")

</div>