# Load index to elasticsearch

**URL:** <https://discuss.elastic.co/t/load-index-to-elasticsearch/59825>\
**Category:** Elasticsearch\
**Created:** [September 5, 2016, 4:00pm UTC](https://discuss.elastic.co/t/load-index-to-elasticsearch/59825 "2016-09-05T16:00:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![FrancescoNic23](https://avatars.discourse-cdn.com/v4/letter/f/c4cdca/32.png) [@FrancescoNic23](https://discuss.elastic.co/u/FrancescoNic23)\
**Post date:** [September 5, 2016, 4:00pm UTC](https://discuss.elastic.co/t/load-index-to-elasticsearch/59825/1 "2016-09-05T16:00:16Z")

</div>

Hi,  
i have a problem when i load index and file.conf. When i launch the command C:\Users\Standard\Documents\kibi-4.5.3-windows64\logstash\bin\logstash  
-f ordineditrasporto.conf , the execution is correct. But when i go in  
the plugin GUI elasticsearch ordineditrasporto is too big in docs than  
the real records in my database mysql. But the unexpected thing is that  
the number of docs grow without a limit and elasticsearch continues to  
process as a loop. But for 3 indexes, veicolo (240 records), vettore  
(40 records) and cella(3844 records) , the result of load in elasticsearch is correct: the number  
of docs is right (I end the execution of logstash when i see 40 or 240 or 3844).  
This problem emerges for others indexes.

This is an example of conf file:

input{  
jdbc {  
jdbc\_driver\_library =\> "C:\Users\Standard\Documents\kibi-4.5.3-windows64\elasticsearch\lib\mysql-connector-java-5.1.38-bin"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:3306/optfrancesco?autoReconnect=true&useSSL=false"  
jdbc\_user =\> "root"  
jdbc\_password =\> "P1nkFloyd"  
statement =\> "SELECT \* FROM optfrancesco.pianoconsegna  
schedule =\> "\* \* \* \* \*"  
jdbc\_paging\_enabled =\> "true"  
jdbc\_page\_size =\> "13619"  
}  
}

output{  
elasticsearch{  
action =\>"index"  
index =\> "pianoconsegna"  
document\_type =\> "Pianoconsegna"  
manage\_template =\> false  
doc\_as\_upsert =\> true  
hosts =\> ["127.0.0.1"]  
}  
}

What can i do?

Thank you,

Francesco

---

<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:** [September 5, 2016, 11:07pm UTC](https://discuss.elastic.co/t/load-index-to-elasticsearch/59825/2 "2016-09-05T23:07:08Z")

</div>

You're using Kibi here right?

---

<div class="post-metadata">

**Author:** ![FrancescoNic23](https://avatars.discourse-cdn.com/v4/letter/f/c4cdca/32.png) [@FrancescoNic23](https://discuss.elastic.co/u/FrancescoNic23)\
**Post date:** [September 5, 2016, 11:56pm UTC](https://discuss.elastic.co/t/load-index-to-elasticsearch/59825/3 "2016-09-05T23:56:21Z")

</div>

Yes i'm using kibi but i can't do nothing if the data aren't correct in  
elasticsearch.

Thanks

---

<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, 10:22pm UTC](https://discuss.elastic.co/t/load-index-to-elasticsearch/59825/4 "2017-07-05T22:22:26Z")

</div>