Open eyjolfur12 opened 9 years ago
You are running a JDBC river 1.3.x against Elasticsearch 1.4.x, this is incompatible.
Thank you Jörge, for taking the time to look at this. I appreciate it.
I had at least convinced myself, that I had started out by installing version 1.4 of river-jdbc and then downgraded to 1.3.4.3, but I must have been mistaken and maybe started out with 1.3.4.4. At least it is seems to be running fine now with 1.4.0.3.Beta1. Sorry for wasting your time.
I have also an issue after upgrading as well. Elasticsearch doesn't seem to find the mysql driver. I have copied the driver in the plugins/river-jdbc directory and also in lib. I've restarted elasticsearch and I still get this error
[2014-12-09 17:41:39,910][ERROR][river.jdbc.SimpleRiverSource] while opening read connection: jdbc:mysql://localhost:3306/products_fr No suitable driver found for jdbc:mysql://localhost:3306/products_fr
java.sql.SQLException: No suitable driver found for jdbc:mysql://[myhost]:3306/products_fr
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:217)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:376)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:209)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:139)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
Where should I put the jdbc driver jar?
Thanks in advance! :)
@eliasah Hopefully someone finds your question here. Since it is not directly related to the original issue here, you might consider creating your own issue. I did not do an upgrade, but the jdbc plugin installed for me to 'plugins/jdbc' rather than 'plugins/river-jbdc' placing my driver in the jdbc folder worked for me.
If the original issue is reported reported enough, you might consider changing the main page to make more explicit the need to pay attention to version.
I am setting up a new box and encountered this because I just blindly followed the Installation command and then the error brought me here.
Any plan to release a final version compatible with ES 1.4 ?
There is version 1.4.0.3, this is compatible with ES 1.4
@jprante,thanks ,it solved my problem
Hi Jörge.
And thanks for this great software!
I have been running an elasticsearch server for some time, using version 1.1.1 with river-jdbc 1.1.0.0.
Now I am setting up another one, with elasticsearch 1.4.0 and the newest version of river-jdbc, but when I have installed the plugin, elastisearch will not load with the error:
Some googling indicated that this was related to conflicting class definitions in different jar's and suggested setting up "correct" classpath. I am not en experienced java programmer, but tried set the classpath so:
But that did not change anything. I also, per your suggestion in another issue here, changed the owner of the plugin folder to elasticsearch, and I notice that in the init.d script that I use to start the service the $ES_USER is made the owner of the working, data and log dirs.
I also tried downgrading to river-jdbc 1.3.4.3 and postgres-9-3-1101.jdbc41, but got the same error.
I would greatly appreciate any help on this
Eyjólfur Kristjánsson
Below are some possibly relevant info:
Java:
Plugin dir:
Full trace: