# Jdbc river won't start **URL:** \ **Category:** Elasticsearch\ **Created:** [February 11, 2015, 1:38pm UTC](https://discuss.elastic.co/t/jdbc-river-wont-start/22093 "2015-02-11T13:38:41Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Abid\_Hussain](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abid\_Hussain](https://discuss.elastic.co/u/Abid_Hussain)\ **Post date:** [February 11, 2015, 1:38pm UTC](https://discuss.elastic.co/t/jdbc-river-wont-start/22093/1 "2015-02-11T13:38:41Z")
Hi, we are running ES on a single node cluster. I'm facing the issue that a river is not being started after being re-created. In detail, we first delete the index the river refers to, then delete the river and then create it again. _GET /\_river/my\_river/\_meta_ { "\_index": "\_river", "\_type": "my\_river", "\_id": "\_meta", "\_version": 12, "found": true, "\_source": { "type": "jdbc", "jdbc": { "driver": "com.mysql.jdbc.Driver", "url": "jdbc:mysql://localhost:3306/my\_db", "user": "user", "password": "\*\*\*", "index": "my\_index", "type": "my\_customer", "sql": "SELECT \* FROM my\_customer" } } } Unfortunately, the river is not being started after creating it. When I request the river state it tells me that it ran last time yesterday: { "state": [ { "name": "my\_river", "type": "jdbc", "started": "2015-02-10T01:00:06.997Z", "last\_active\_begin": "2015-02-10T01:00:07.030Z", "last\_active\_end": "2015-02-10T01:53:34.364Z", "map": { "lastExecutionStartDate": 1423530007825, "aborted": false, "lastEndDate": 1423533216703, "counter": 1, "lastExecutionEndDate": 1423533214363, "lastStartDate": 1423530007608, "suspended": false } } ] } The connection properties didn't change since last succesful run. In the logs is nothing said, except the message after deleting the index. Any idea what could be the problem? 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%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:** [February 11, 2015, 2:13pm UTC](https://discuss.elastic.co/t/jdbc-river-wont-start/22093/2 "2015-02-11T14:13:33Z")
You are sure you executed curl -XDELETE 'localhost:9200/\_river/my\_river/' before creating the new river with same name? I see there is '\_version: 12', this means, you did not stop the old river instance with DELETE. Jörg On Wed, Feb 11, 2015 at 2:38 PM, Abid Hussain [hussain@novacom.mygbiz.com](mailto:hussain@novacom.mygbiz.com) wrote: > Hi, > > we are running ES on a single node cluster. > > I'm facing the issue that a river is not being started after being > re-created. In detail, we first delete the index the river refers to, then > delete the river and then create it again. > > _GET /\_river/my\_river/\_meta_ > { > "\_index": "\_river", > "\_type": "my\_river", > "\_id": "\_meta", > "\_version": 12, > "found": true, > "\_source": { > "type": "jdbc", > "jdbc": { > "driver": "com.mysql.jdbc.Driver", > "url": "jdbc:mysql://localhost:3306/my\_db", > "user": "user", > "password": "\*\*\*", > "index": "my\_index", > "type": "my\_customer", > "sql": "SELECT \* FROM my\_customer" > } > } > } > > Unfortunately, the river is not being started after creating it. When I > request the river state it tells me that it ran last time yesterday: > { > "state": [ > { > "name": "my\_river", > "type": "jdbc", > "started": "2015-02-10T01:00:06.997Z", > "last\_active\_begin": "2015-02-10T01:00:07.030Z", > "last\_active\_end": "2015-02-10T01:53:34.364Z", > "map": { > "lastExecutionStartDate": 1423530007825, > "aborted": false, > "lastEndDate": 1423533216703, > "counter": 1, > "lastExecutionEndDate": 1423533214363, > "lastStartDate": 1423530007608, > "suspended": false > } > } > ] > } > > The connection properties didn't change since last succesful run. > > In the logs is nothing said, except the message after deleting the index. > > Any idea what could be the problem? > > 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%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/CAKdsXoFXKzzVP%3DP3Og4OpUCQDVa8MNg5%2BCPpCAo-S5upy\_VdSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFXKzzVP%3DP3Og4OpUCQDVa8MNg5%2BCPpCAo-S5upy_VdSg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Abid\_Hussain](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@Abid\_Hussain](https://discuss.elastic.co/u/Abid_Hussain)\ **Post date:** [February 11, 2015, 3:07pm UTC](https://discuss.elastic.co/t/jdbc-river-wont-start/22093/3 "2015-02-11T15:07:31Z")
That was it. I deleted the river using DELETE /\_river/my\_river/\_meta but that was wrong, I should have used: DELETE /\_river/my\_river/ Thanks! Am Mittwoch, 11. Februar 2015 15:13:47 UTC+1 schrieb Jörg Prante: > You are sure you executed > > curl -XDELETE 'localhost:9200/\_river/my\_river/' > > before creating the new river with same name? I see there is '\_version: > 12', this means, you did not stop the old river instance with DELETE. > > Jörg > > On Wed, Feb 11, 2015 at 2:38 PM, Abid Hussain \<[hus...@novacom.mygbiz.com](mailto:hus...@novacom.mygbiz.com) > \\> wrote: > > > Hi, > > > > we are running ES on a single node cluster. > > > > I'm facing the issue that a river is not being started after being > > re-created. In detail, we first delete the index the river refers to, then > > delete the river and then create it again. > > > > _GET /\_river/my\_river/\_meta_ > > { > > "\_index": "\_river", > > "\_type": "my\_river", > > "\_id": "\_meta", > > "\_version": 12, > > "found": true, > > "\_source": { > > "type": "jdbc", > > "jdbc": { > > "driver": "com.mysql.jdbc.Driver", > > "url": "jdbc:mysql://localhost:3306/my\_db", > > "user": "user", > > "password": "\*\*\*", > > "index": "my\_index", > > "type": "my\_customer", > > "sql": "SELECT \* FROM my\_customer" > > } > > } > > } > > > > Unfortunately, the river is not being started after creating it. When I > > request the river state it tells me that it ran last time yesterday: > > { > > "state": [ > > { > > "name": "my\_river", > > "type": "jdbc", > > "started": "2015-02-10T01:00:06.997Z", > > "last\_active\_begin": "2015-02-10T01:00:07.030Z", > > "last\_active\_end": "2015-02-10T01:53:34.364Z", > > "map": { > > "lastExecutionStartDate": 1423530007825, > > "aborted": false, > > "lastEndDate": 1423533216703, > > "counter": 1, > > "lastExecutionEndDate": 1423533214363, > > "lastStartDate": 1423530007608, > > "suspended": false > > } > > } > > ] > > } > > > > The connection properties didn't change since last succesful run. > > > > In the logs is nothing said, except the message after deleting the index. > > > > Any idea what could be the problem? > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/5e8ffbc7-c33f-4157-b8fe-a170d38fc1fc%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/2b5be310-90cb-474a-82fd-cd233573d78c%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2b5be310-90cb-474a-82fd-cd233573d78c%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:33am UTC](https://discuss.elastic.co/t/jdbc-river-wont-start/22093/4 "2017-07-06T00:33:28Z")