# Manually starting rivers? **URL:** \ **Category:** Elasticsearch\ **Created:** [October 3, 2014, 2:18pm UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064 "2014-10-03T14:18:47Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![sampson](https://avatars.discourse-cdn.com/v4/letter/s/22d042/32.png) [@sampson](https://discuss.elastic.co/u/sampson)\ **Post date:** [October 3, 2014, 2:18pm UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064/1 "2014-10-03T14:18:47Z")
Maybe I'm overlooking it in the documentation, but when I create a river (jdbc/mysql in my case), the data import runs just fine. They seem to only run one at a time. However, without deleting and re-creating, how can I manually start a river that is already defined? In this case, I have a largely static data set. I don't need a scheduled job. Just need to kick off an import when I import new data. Ideally, I'd like to be able to restart the import job through something like [http://host:9200/\_river/my\_river/\_restart](http://host:9200/_river/my_river/_restart). Does something like this exist? Thanks! -- 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](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [October 3, 2014, 2:21pm UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064/2 "2014-10-03T14:21:50Z")
It depends on the river implementation. This is something I added in FSriver: [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river) Not sure if Jörg implemented something similar in JDBC river. -- David Pilato | Technical Advocate | [elasticsearch.com](http://elasticsearch.com) [david.pilato@elasticsearch.com](mailto:david.pilato@elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 3 octobre 2014 à 16:18:50, sampson (brad@schulzfamily.org) a écrit: Maybe I'm overlooking it in the documentation, but when I create a river (jdbc/mysql in my case), the data import runs just fine. They seem to only run one at a time. However, without deleting and re-creating, how can I manually start a river that is already defined? In this case, I have a largely static data set. I don't need a scheduled job. Just need to kick off an import when I import new data. Ideally, I'd like to be able to restart the import job through something like [http://host:9200/\_river/my\_river/\_restart](http://host:9200/_river/my_river/_restart). Does something like this exist? ## Thanks! 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](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/etPan.542eb0fe.6b68079a.3d55%40MacBook-Air-de-David.local](https://groups.google.com/d/msgid/elasticsearch/etPan.542eb0fe.6b68079a.3d55%40MacBook-Air-de-David.local). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![sampson](https://avatars.discourse-cdn.com/v4/letter/s/22d042/32.png) [@sampson](https://discuss.elastic.co/u/sampson)\ **Post date:** [October 3, 2014, 2:24pm UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064/3 "2014-10-03T14:24:40Z")
Thanks, David! For this application I am using the JDBC river...hopefully there is a restart there that I'm just missing. Your library looks really good! On Friday, October 3, 2014 10:22:15 AM UTC-4, David Pilato wrote: > It depends on the river implementation. > > This is something I added in FSriver: > [GitHub - dadoonet/fscrawler: Elasticsearch File System Crawler (FS Crawler)](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river) > > [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river) > N [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river)ot > sure if Jörg implemented something similar in JDBC river. > > -- > _David Pilato_ | Technical Advocate | _[elasticsearch.com](http://elasticsearch.com) > [http://elasticsearch.com](http://elasticsearch.com)_ > [david....@elasticsearch.com](mailto:david....@elasticsearch.com) \ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr > [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs > [http://twitter.com/scrutmydocs](http://twitter.com/scrutmydocs) > [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 3 octobre 2014 à 16:18:50, sampson ([br...@schulzfamily.org](mailto:br...@schulzfamily.org) > \) a écrit: > > Maybe I'm overlooking it in the documentation, but when I create a river > (jdbc/mysql in my case), the data import runs just fine. They seem to only > run one at a time. However, without deleting and re-creating, how can I > manually start a river that is already defined? In this case, I have a > largely static data set. I don't need a scheduled job. Just need to kick > off an import when I import new data. Ideally, I'd like to be able to > restart the import job through something like > [http://host:9200/\_river/my\_river/\_restart](http://host:9200/_river/my_river/_restart). > > Does something like this exist? > > ## Thanks! > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [October 3, 2014, 2:57pm UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064/4 "2014-10-03T14:57:48Z")
At the moment, there is no suspend/resume in JDBC river, but I will add this feature to the next version, which ETA is this month October. > > > The JDBC river should have commands where it can be stopped and started again. T…his is useful if the database is temporarily not available or for better manual control of indexing. Jörg On Fri, Oct 3, 2014 at 4:24 PM, sampson [brad@schulzfamily.org](mailto:brad@schulzfamily.org) wrote: > Thanks, David! For this application I am using the JDBC river...hopefully > there is a restart there that I'm just missing. > > Your library looks really good! > > On Friday, October 3, 2014 10:22:15 AM UTC-4, David Pilato wrote: > > > It depends on the river implementation. > > > > This is something I added in FSriver: [https://github.com/](https://github.com/) > > dadoonet/fsriver#suspend-or-restart-a-file-river > > > > [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river) > > N [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river)ot > > sure if Jörg implemented something similar in JDBC river. > > > > -- > > _David Pilato_ | Technical Advocate | _[elasticsearch.com](http://elasticsearch.com) > > [http://elasticsearch.com](http://elasticsearch.com)_ > > [david....@elasticsearch.com](mailto:david....@elasticsearch.com) > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr > > [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs > > [http://twitter.com/scrutmydocs](http://twitter.com/scrutmydocs) > > [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > > > Le 3 octobre 2014 à 16:18:50, sampson ([br...@schulzfamily.org](mailto:br...@schulzfamily.org)) a écrit: > > > > Maybe I'm overlooking it in the documentation, but when I create a river > > (jdbc/mysql in my case), the data import runs just fine. They seem to only > > run one at a time. However, without deleting and re-creating, how can I > > manually start a river that is already defined? In this case, I have a > > largely static data set. I don't need a scheduled job. Just need to kick > > off an import when I import new data. Ideally, I'd like to be able to > > restart the import job through something like [http://host:9200/\_river/my\_](http://host:9200/_river/my_) > > river/\_restart. > > > > Does something like this exist? > > > > ## Thanks! > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f% > > [40googlegroups.com](http://40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFeX2N\_%2BGv%3D6HQj2sBsiP%2BWoGcdMKbXpQ7g0PNj8Qcd1w%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFeX2N_%2BGv%3D6HQj2sBsiP%2BWoGcdMKbXpQ7g0PNj8Qcd1w%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![sampson](https://avatars.discourse-cdn.com/v4/letter/s/22d042/32.png) [@sampson](https://discuss.elastic.co/u/sampson)\ **Post date:** [October 3, 2014, 3:22pm UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064/5 "2014-10-03T15:22:47Z")
Thanks for the quick reply, Jörg! And thank you for your work on this project! On Friday, October 3, 2014 10:57:56 AM UTC-4, Jörg Prante wrote: > At the moment, there is no suspend/resume in JDBC river, but I will add > this feature to the next version, which ETA is this month October. > > [Add \_suspend / \_resume to JDBC river · Issue #347 · jprante/elasticsearch-jdbc · GitHub](https://github.com/jprante/elasticsearch-river-jdbc/issues/347) > > Jörg > > On Fri, Oct 3, 2014 at 4:24 PM, sampson \<[br...@schulzfamily.org](mailto:br...@schulzfamily.org) > \\> wrote: > > > Thanks, David! For this application I am using the JDBC > > river...hopefully there is a restart there that I'm just missing. > > > > Your library looks really good! > > > > On Friday, October 3, 2014 10:22:15 AM UTC-4, David Pilato wrote: > > > > > It depends on the river implementation. > > > > > > This is something I added in FSriver: [https://github.com/](https://github.com/) > > > dadoonet/fsriver#suspend-or-restart-a-file-river > > > > > > [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river) > > > N [https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river](https://github.com/dadoonet/fsriver#suspend-or-restart-a-file-river)ot > > > sure if Jörg implemented something similar in JDBC river. > > > > > > -- > > > _David Pilato_ | Technical Advocate | _[elasticsearch.com](http://elasticsearch.com) > > > [http://elasticsearch.com](http://elasticsearch.com)_ > > > [david....@elasticsearch.com](mailto:david....@elasticsearch.com) > > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr > > > [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs > > > [http://twitter.com/scrutmydocs](http://twitter.com/scrutmydocs) > > > [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > > > > > Le 3 octobre 2014 à 16:18:50, sampson ([br...@schulzfamily.org](mailto:br...@schulzfamily.org)) a écrit: > > > > > > Maybe I'm overlooking it in the documentation, but when I create a river > > > (jdbc/mysql in my case), the data import runs just fine. They seem to only > > > run one at a time. However, without deleting and re-creating, how can I > > > manually start a river that is already defined? In this case, I have a > > > largely static data set. I don't need a scheduled job. Just need to kick > > > off an import when I import new data. Ideally, I'd like to be able to > > > restart the import job through something like > > > [http://host:9200/\_river/my\_river/\_restart](http://host:9200/_river/my_river/_restart). > > > > > > Does something like this exist? > > > > > > ## Thanks! > > > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > > msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f% > > > [40googlegroups.com](http://40googlegroups.com) > > > [https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/832a42a3-d09f-4079-b3b1-94c7f4bc408f%40googlegroups.com?utm_medium=email&utm_source=footer) > > > . > > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com) > > > [https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/cab4d7a7-5783-4147-8cb4-0e827c7f6192%40googlegroups.com?utm_medium=email&utm_source=footer) > > > . > > > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/843da4e7-e1ef-43cd-9a50-71b3f7769d9d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/843da4e7-e1ef-43cd-9a50-71b3f7769d9d%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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, 12:58am UTC](https://discuss.elastic.co/t/manually-starting-rivers/20064/6 "2017-07-06T00:58:27Z")