You should delete the river instance after usage. Otherwise, the river is executed each time the node starts.
Jörg On Mon, Jan 26, 2015 at 1:09 PM, Abid Hussain <[email protected]> wrote: > Hi all, > > I configured a river for one-time indexing like: > PUT /_river/my_river/_meta > { > "type": "jdbc", > "jdbc": { > "driver": "com.mysql.jdbc.Driver", > "url": "jdbc:mysql://192.168.110.180:3306/my_db", > "user": "user", > "password": "password", > "index": "my_idx", > "type": "order", > "sql": "SELECT o.order_id AS _id, o.order_name FROM orders o" > } > } > > > After performing the PUT, the data is being indexed. When finished, I stop > the server and start it again. The CPU load now is remarkably high. Looking > at /_river/jdbc/*/_state it tells me that *last_active_end* is null. > > So, does the restart of elasicsearch trigger a complete reindexing? If so, > how can I avoid this - e.g by using timestamps? > > Regards, > > Abid > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/b006c70b-93f7-48a9-b423-136d288ef7f3%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/b006c70b-93f7-48a9-b423-136d288ef7f3%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoE9J_TvKbE7%2BWO7_DByD%3DoQ1M293BOxLoX_AchyeMMJJw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
