# Log file Error in Elasticsearch jdbc importer **URL:** \ **Category:** Elasticsearch\ **Created:** [July 10, 2017, 7:54am UTC](https://discuss.elastic.co/t/log-file-error-in-elasticsearch-jdbc-importer/92421 "2017-07-10T07:54:20Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![saafianihan](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@saafianihan](https://discuss.elastic.co/u/saafianihan)\ **Post date:** [July 10, 2017, 7:54am UTC](https://discuss.elastic.co/t/log-file-error-in-elasticsearch-jdbc-importer/92421/1 "2017-07-10T07:54:20Z")
i am getting error while running mysql-simple-example.bat , [10:58:05,613][INFO][importer.jdbc][pool-2-thread-1] strategy standard: settings = {elasticsearch.cluster=elasticsearch, elasticsearch.host=localhost, elasticsearch.port=9300, index=testing, password=, sql=select \*, ID as \_id from company, treat\_binary\_as\_string=true, url=jdbc:mysql://localhost:3306/test, user=root}, context = org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext@52d16fbb [10:58:05,613][INFO][importer.jdbc.context.standard][pool-2-thread-1] found sink class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink@13cb8dbf [10:58:05,613][INFO][importer.jdbc.context.standard][pool-2-thread-1] found source class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource@5fb6e1e2 [10:58:05,644][INFO][org.xbib.elasticsearch.helper.client.BaseTransportClient][pool-2-thread-1] creating transport client on Windows 8.1 Java HotSpot(TM) 64-Bit Server VM Oracle Corporation 1.8.0\_20-b26 25.20-b23 with effective settings {autodiscover=false, client.transport.ignore\_cluster\_name=false, client.transport.nodes\_sampler\_interval=5s, client.transport.ping\_timeout=5s, cluster.name=elasticsearch, flush\_interval=5s, host.0=localhost, max\_actions\_per\_request=10000, max\_concurrent\_requests=8, max\_volume\_per\_request=10mb, name=importer, port=9300, sniff=false} [10:58:05,675][INFO][org.elasticsearch.plugins][pool-2-thread-1] [importer] modules [], plugins [helper], sites [] [10:58:13,337][INFO][org.xbib.elasticsearch.helper.client.BaseTransportClient][pool-2-thread-1] trying to connect to [localhost/127.0.0.1:9300] [10:58:13,415][INFO][org.elasticsearch.org.xbib.elasticsearch.helper.client.TransportClient][pool-2-thread-1] [importer] failed to get node info for {#transport#-1}{127.0.0.1}{localhost/127.0.0.1:9300}, disconnecting... org.elasticsearch.transport.NodeDisconnectedException: [][localhost/127.0.0.1:9300][cluster:monitor/nodes/liveness] disconnected [10:58:13,415][ERROR][importer.jdbc][pool-2-thread-1] error while processing request: no cluster nodes available, check settings {autodiscover=false, client.transport.ignore\_cluster\_name=false, client.transport.nodes\_sampler\_interval=5s, client.transport.ping\_timeout=5s, cluster.name=elasticsearch, flush\_interval=5s, host.0=localhost, max\_actions\_per\_request=10000, max\_concurrent\_requests=8, max\_volume\_per\_request=10mb, name=importer, port=9300, sniff=false} org.elasticsearch.client.transport.NoNodeAvailableException: no cluster nodes available, check settings {autodiscover=false, client.transport.ignore\_cluster\_name=false, client.transport.nodes\_sampler\_interval=5s, client.transport.ping\_timeout=5s, cluster.name=elasticsearch, flush\_interval=5s, host.0=localhost, max\_actions\_per\_request=10000, max\_concurrent\_requests=8, max\_volume\_per\_request=10mb, name=importer, port=9300, sniff=false} at org.xbib.elasticsearch.helper.client.BulkTransportClient.init(BulkTransportClient.java:164) ~[elasticsearch-helper-2.3.4.0.jar:?] at org.xbib.elasticsearch.helper.client.ClientBuilder.toBulkTransportClient(ClientBuilder.java:113) ~[elasticsearch-helper-2.3.4.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.createClient(StandardSink.java:348) ~[elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.beforeFetch(StandardSink.java:100) ~[elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.beforeFetch(StandardContext.java:183) ~[elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:164) ~[elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:203) ~[elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:189) [elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:53) [elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50) [elasticsearch-jdbc-2.3.4.1.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16) [elasticsearch-jdbc-2.3.4.1.jar:?] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0\_20] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0\_20] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0\_20] at java.lang.Thread.run(Thread.java:745) [?:1.8.0\_20] [11:08:59,215][INFO][importer.jdbc][pool-2-thread-1] strategy standard: settings = {elasticsearch.autodiscover=true, elasticsearch.cluster=elasticsearch, elasticsearch.host=localhost, elasticsearch.port=9300, index=testing, password=, sql=select \*, ID as \_id from compay, treat\_binary\_as\_string=true, url=jdbc:mysql://localhost:3306/mcements, user=root}, context = org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext@91bc26b [11:08:59,226][INFO][importer.jdbc.context.standard][pool-2-thread-1] found sink class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink@33790395 [11:08:59,231][INFO][importer.jdbc.context.standard][pool-2-thread-1] found source class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource@15345f27 [11:08:59,277][INFO][org.xbib.elasticsearch.helper.client.BaseTransportClient][pool-2-thread-1] creating transport client on Windows 8.1 Java HotSpot(TM) 64-Bit Server VM Oracle Corporation 1.8.0\_20-b26 25.20-b23 with effective settings {autodiscover=true, client.transport.ignore\_cluster\_name=false, client.transport.nodes\_sampler\_interval=5s, client.transport.ping\_timeout=5s, cluster.name=elasticsearch, flush\_interval=5s, host.0=localhost, max\_actions\_per\_request=10000, max\_concurrent\_requests=8, max\_volume\_per\_request=10mb, name=importer, port=9300, sniff=false} [11:08:59,307][INFO][org.elasticsearch.plugins][pool-2-thread-1] [importer] modules [], plugins [helper], sites [] [11:09:04,073][INFO][org.xbib.elasticsearch.helper.client.BaseTransportClient][pool-2-thread-1] trying to connect to [localhost/127.0.0.1:9300] This is my mysql-simple-example.bat file: @echo off set DIR=%~dp0 set LIB=%DIR%..\lib\* set BIN=%DIR%..\bin REM ??? echo {^ "type" : "jdbc",^ "jdbc" : {^ "url" : "jdbc:mysql://localhost:3306/test",^ "user" : "root",^ "password" : "",^ "sql" : "select \*, ID as \_id from company",^ "treat\_binary\_as\_string" : true,^ "elasticsearch" : {^ "cluster" : "elasticsearch",^ "host" : "localhost",^ "port" : 9300,^ "autodiscover" : true^ },^ "index" : "testing"^ }^ }^ | "%JAVA\_HOME%\bin\java" -cp "%LIB%" -Dlog4j.configurationFile="%BIN%\log4j2.xml" "org.xbib.tools.Runner" "org.xbib.tools.JDBCImporter" Please help me... ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 7, 2017, 7:54am UTC](https://discuss.elastic.co/t/log-file-error-in-elasticsearch-jdbc-importer/92421/2 "2017-08-07T07:54:30Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.