ES doesn't update from MySql

Elastic Stack Elasticsearch
1

Hi everyone,
I've a MySql database with 17727677 rows. I've created a jdbc river to
connect it to ElasticSearch cluster composed by 11 nodes (1 master and 10
slaves). This is my river.

curl -XGET 'http://localhost:9200/_river/airplanethreey/_meta'
{"_index":"_river","_type":"airplanethreey","_id":"_meta","_version":1,"exists":true,
"_source" : {
"type" : "jdbc",
"jdbc" : {
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://localhost:3306/airplanethreey",
"user" : "root",
"password" : "pass",
"sql" : "SELECT ID as _id, and the other fields",
"poll" : "1m",
"strategy" : "simple",

      "autocommit" : "true" 
    }, 
"index" : { 
    "index" : "airplanethreey", 
    "type" : "flight" 
}

}}

With a smaller dataset it works and there is the update in ElasticSearch,
with the big one no: in the terminal of master node of ES there is "always"
this situation : the computing never ends

https://lh4.googleusercontent.com/-6Zm0t73yX4U/UhzYKpRZUEI/AAAAAAAAAok/-cPkup8iv9A/s1600/Screenshot.png

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

2

For streaming large result sets, the MySQL JDBC driver connection must not
be set to autocommit: true.

Jörg

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.