Lost results in ElasticSearch index with autoupdate

Asked Mar 05 '14 at 10:13

Active Mar 05 '14 at 10:44

Viewed 168 times

I have problem with data being lost when using a jdbc driver to update elasticsearch from a mysql database. My river is below:

curl -XPUT 'http://localhost:9200/_river/river_index_type/_meta' -d '
{
    "type": "jdbc",
    "jdbc": {
        "strategy": "simple",
        "driver": "com.mysql.jdbc.Driver",
        "url": "jdbc:mysql://localhost/tt",
        "user": "user",
        "password": "password",
        "sql": "SELECT p.product_id AS _id, ... FROM product p ... WHERE ...",
        "poll": "5m",
        "autocommit": true
    },
    "index": {
        "type": "type",
        "index": "index"
    }
}

Initially everything works fine, but later, instead of 1200 results in my index i only have 800-900, and each five minutes the count changes. I don't understand what the problem is. Any help would be appreciated.

edited Mar 05 '14 at 10:44

rasjani

7,372
4
22
35

asked Mar 05 '14 at 10:13

i.paramonov

Please try [this](http://stackoverflow.com/questions/19976566/in-jdbc-river-how-to-stop-housekeeping-not-to-delete-records) if problem of same as mine :) – Roopendra Mar 05 '14 at 10:57
Thanks, I'll try, one day I will unsubscribe) – i.paramonov Mar 05 '14 at 11:14
That was better, but still lost data, five days everything worked fine, but now again lost about 200-300 records... – i.paramonov Mar 11 '14 at 08:49

Lost results in ElasticSearch index with autoupdate

0 Answers0