{"action":"created","issue":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/699","labels_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/699/labels{/name}","comments_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/699/comments","events_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/699/events","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/699","id":117755465,"number":699,"title":"ES 2.0.0 Import Error","user":{"login":"TruyenNT","id":14885376,"avatar_url":"https://avatars.githubusercontent.com/u/14885376?v=3","gravatar_id":"","url":"https://api.github.com/users/TruyenNT","html_url":"https://github.com/TruyenNT","followers_url":"https://api.github.com/users/TruyenNT/followers","following_url":"https://api.github.com/users/TruyenNT/following{/other_user}","gists_url":"https://api.github.com/users/TruyenNT/gists{/gist_id}","starred_url":"https://api.github.com/users/TruyenNT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TruyenNT/subscriptions","organizations_url":"https://api.github.com/users/TruyenNT/orgs","repos_url":"https://api.github.com/users/TruyenNT/repos","events_url":"https://api.github.com/users/TruyenNT/events{/privacy}","received_events_url":"https://api.github.com/users/TruyenNT/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-11-19T07:08:14Z","updated_at":"2015-11-21T17:25:18Z","closed_at":null,"body":"Dear Jprante,\r\n   I use ES 2.0.0, Java 8.\r\n   When i import data from mysql, the Index has been created, but the importing data was failed.\r\nbelow are the logs:\r\n\r\n[13:39:23,501][INFO ][importer.jdbc            ][main] index name = customers, concrete index name = customers\r\n[13:39:23,530][INFO ][importer.jdbc            ][pool-3-thread-1] strategy standard: settings = {index=customers, max_bulk_actions=20000, max_concurrent_bulk_requests=10, password=123456, sql=select * from Customers, treat_binary_as_string=true, url=jdbc:mysql://192.168.179.140:3306/northwind, user=es}, context = org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext@139e5d8e\r\n[13:39:23,535][INFO ][importer.jdbc.context.standard][pool-3-thread-1] found sink class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink@6e9ed9d0\r\n[13:39:23,542][INFO ][importer.jdbc.context.standard][pool-3-thread-1] found source class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource@7e30c562\r\n[13:39:23,574][INFO ][org.xbib.elasticsearch.support.client.BaseTransportClient][pool-3-thread-1] creating transport client on Linux Java HotSpot(TM) 64-Bit Server VM Oracle Corporation 1.8.0_65-b17 25.65-b01 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, name=importer, port=9300, sniff=false}\r\n[13:39:23,601][INFO ][org.elasticsearch.plugins][pool-3-thread-1] [importer] loaded [], sites []\r\n\r\n[13:39:57,566][INFO ][org.xbib.elasticsearch.support.client.BaseTransportClient][pool-3-thread-1] trying to connect to [localhost/127.0.0.1:9300]\r\n[13:39:57,763][INFO ][org.xbib.elasticsearch.support.client.BaseTransportClient][pool-3-thread-1] connected to [{Doorman}{lDVOIh_VSbW0TAHeIwIUUw}{192.168.179.140}{localhost/127.0.0.1:9300}]\r\n[13:39:57,768][INFO ][importer.jdbc.sink.standard][pool-3-thread-1] creating index customers with settings =  and mappings =\r\n[13:39:57,856][INFO ][org.xbib.elasticsearch.support.client.BaseIngestTransportClient][pool-3-thread-1] index customers created\r\n[13:40:03,740][WARN ][org.xbib.elasticsearch.support.client.transport.BulkTransportClient][Thread-1] no client\r\n\r\n\r\nCan you show me how to solve this ?\r\n\r\nThis is my code:\r\n\r\nbin=/opt/elasticsearch-jdbc-2.0.0.0/bin\r\nlib=/opt/elasticsearch-jdbc-2.0.0.0/lib\r\n\r\necho '\r\n{\r\n    \"type\" : \"jdbc\",\r\n    \"jdbc\" : {\r\n        \"url\" : \"jdbc:mysql://192.168.179.140:3306/northwind\",\r\n        \"user\" : \"es\",\r\n        \"password\" : \"123456\",\r\n        \"sql\" :  \"select * from Customers\",\r\n        \"treat_binary_as_string\" : true,\r\n        \"max_bulk_actions\" : 20000,\r\n        \"max_concurrent_bulk_requests\" : 10,\r\n        \"index\" : \"customers\"\r\n      }\r\n}\r\n' | java \\\r\n    -cp \"${lib}/*\" \\\r\n    -Dlog4j.configurationFile=${bin}/log4j2.xml \\\r\n    org.xbib.tools.Runner \\\r\n    org.xbib.tools.JDBCImporter\r\n\r\n\r\nAnd this is my java:\r\n\r\njava -version\r\njava version \"1.8.0_65\"\r\nJava(TM) SE Runtime Environment (build 1.8.0_65-b17)\r\nJava HotSpot(TM) 64-Bit Server VM (build 25.65-b01, mixed mode)\r\n\r\ni'm waiting for your feedback asap :( \r\n"},"comment":{"url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/comments/158663404","html_url":"https://github.com/jprante/elasticsearch-jdbc/issues/699#issuecomment-158663404","issue_url":"https://api.github.com/repos/jprante/elasticsearch-jdbc/issues/699","id":158663404,"user":{"login":"jprante","id":635745,"avatar_url":"https://avatars.githubusercontent.com/u/635745?v=3","gravatar_id":"","url":"https://api.github.com/users/jprante","html_url":"https://github.com/jprante","followers_url":"https://api.github.com/users/jprante/followers","following_url":"https://api.github.com/users/jprante/following{/other_user}","gists_url":"https://api.github.com/users/jprante/gists{/gist_id}","starred_url":"https://api.github.com/users/jprante/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jprante/subscriptions","organizations_url":"https://api.github.com/users/jprante/orgs","repos_url":"https://api.github.com/users/jprante/repos","events_url":"https://api.github.com/users/jprante/events{/privacy}","received_events_url":"https://api.github.com/users/jprante/received_events","type":"User","site_admin":false},"created_at":"2015-11-21T17:25:18Z","updated_at":"2015-11-21T17:25:18Z","body":"Please enable DEBUG level in the logs, then you can see what is happening. JDBC importer disconnects after 5 seconds, this is the node fault detection time period, so there is something with the cluster."}}