search

richardwilly98 / elasticsearch-river-mongodb

MongoDB River Plugin for ElasticSearch
1.12k stars 215 forks source link

no river _meta document found after 5 attempts - ojdbc - elasticsearch #523

Closed shashirsb closed 9 years ago

shashirsb commented 9 years ago

Hi All

My river configuraiton is not working.

/plugin/jdbc elasticsearch-river-jdbc-1.5.0.5.jar jdbc-driver-csv-1.0.0.jar ojdbc5.jar/ojdbc6.jar ( tried both)

Elasticsearch version : 1.5.1 Oracle database version 11.1.0.7

Configuration PUT /_river/product/_meta -d ' { "type" : "jdbc", "jdbc" : { "driver" : "oracle.jdbc.OracleDriver", "url" : "jdbc:oracle:thin:@localhost:1521:XXXXDEV2", "strategy" : "simple", "poll" : "5m", "user" : "MDS_USER", "password" : "xxxxxxxx", "sql" : "SELECT * from MY_LOG", "index": "example", "type": "product" } }

Getting below error:

[2015-04-23 17:01:43,578][WARN ][river.routing ] [Stacy X] no river _meta document found after 5 attempts

Please help me to fix it.

Thanks Shashi

shashirsb commented 9 years ago

[2015-04-23 16:55:01,297][INFO ][node ] [Stacy X] version[1.5.1], pid[5208], build[5e38401/2015-04-09T13:41:35Z] [2015-04-23 16:55:01,297][INFO ][node ] [Stacy X] initializing ... [2015-04-23 16:55:01,319][INFO ][plugins ] [Stacy X] loaded [jdbc-1.5.0.5-da4ba96], sites [head, HQ] [2015-04-23 16:55:04,905][INFO ][node ] [Stacy X] initialized [2015-04-23 16:55:04,973][INFO ][node ] [Stacy X] starting ... [2015-04-23 16:55:05,479][INFO ][transport ] [Stacy X] bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/10.38.9.223:9300]} [2015-04-23 16:55:05,758][INFO ][discovery ] [Stacy X] elasticsearch/vXKCxcFZT-e7Tn_f8ZXX9A [2015-04-23 16:55:09,535][INFO ][cluster.service ] [Stacy X] new_master [Stacy X][vXKCxcFZT-e7Tn_f8ZXX9A][LNLT914087][inet[/10.38.9.223:9300]], reason: zen-disco-join (elected_as_master) [2015-04-23 16:55:09,805][INFO ][http ] [Stacy X] bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/10.38.9.223:9200]} [2015-04-23 16:55:09,805][INFO ][node ] [Stacy X] started [2015-04-23 16:55:10,112][INFO ][gateway ] [Stacy X] recovered [3] indices into cluster_state [2015-04-23 16:55:14,557][WARN ][river.routing ] [Stacy X] no river _meta document found after 5 attempts

GET /_river/product/_search

Get below ouput { "took": 7, "timed_out": false, "_shards": { "total": 1, "successful": 1, "failed": 0 }, "hits": { "total": 1, "max_score": 1, "hits": [ { "_index": "_river", "_type": "product", "_id": "_meta -d '", "_score": 1, "_source": { "type": "jdbc", "jdbc": { "driver": "oracle.jdbc.OracleDriver", "url": "jdbc:oracle:thin:@localhost:1521:XXXXDEV2", "strategy": "simple", "poll": "5m", "user": "MDS_USER", "password": "xxxxxxxx", "sql": "SELECT * from MY_LOG", "index": "example", "type": "product" } } } ] } }

ewgRa commented 9 years ago

I think better to ask this question in jdbc river project: https://github.com/jprante/elasticsearch-jdbc

this is a mongodb river project.

shashirsb commented 9 years ago

Thank you