Skip to content

ES 2.3.1 Import Error #976

New issue
New issue
Open
Open
ES 2.3.1 Import Error#976
@11996

Description

@11996
11996
opened on Aug 30, 2018

Please help me up, I have got the same issue. How did you fix?
Below are the details. I am also running on single node. Also I tried running on 9300 but nothing worked.

java version "9.0.1"
Java(TM) SE Runtime Environment (build 9.0.1+11)
Java HotSpot(TM) 64-Bit Server VM (build 9.0.1+11, mixed mode)


 {
  "name" : "LFD-node",
  "cluster_name" : "LFD-cluster",
  "version" : {
    "number" : "2.3.1",
    "build_hash" : "bd980929010aef404e7cb0843e61d0665269fc39",
    "build_timestamp" : "2016-04-04T12:25:05Z",
    "build_snapshot" : false,
    "lucene_version" : "5.5.0"
  },
  "tagline" : "You Know, for Search"
}

elasticsearch-jdbc-2.3.1.0

@mysql-jdbc.sh

bin=/etc/elasticsearch/elasticsearch-jdbc-2.3.1.0/bin
lib=/etc/elasticsearch/elasticsearch-jdbc-2.3.1.0/lib
echo '
{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:mysql://localhost:3306/ElasticSearchDatabase",
"user" : "",
"password" : "",
"sql" : "select * from test",
"treat_binary_as_string" : true,
"max_bulk_actions" : 20000,
"max_concurrent_bulk_requests" : 10,
"index" : "users"
"type":"users",
"autocommit":"true",
"metrics": {
            "enabled" : true
        },
        "elasticsearch" : {
             "cluster" : "LFD-cluster",
             "host" : "localhost",
             "port" : 9200 
        } 
}
}
' | java -cp "${lib}/*" "org.xbib.tools.Runner" "org.xbib.tools.JDBCImporter"

Errors I am recieveing after running above snippet.
[12:52:53,413][INFO ][importer.jdbc ][pool-3-thread-1] strategy standard: settings = {elasticsearch.host=172.17.0.1, elasticsearch.port=9200, index=users, password=111, sql=select * from ElasticSearchDatabase.test, type=publication, url=jdbc:mysql://localhost:3306/ElasticSearchDatabase, user=root}, context = org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext@29c17f98 [12:52:53,418][INFO ][importer.jdbc.context.standard][pool-3-thread-1] found sink class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink@5493938 [12:52:53,422][INFO ][importer.jdbc.context.standard][pool-3-thread-1] found source class org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource@3605bc43 [12:52:53,466][INFO ][org.xbib.elasticsearch.helper.client.BaseTransportClient][pool-3-thread-1] creating transport client on Linux Java HotSpot(TM) 64-Bit Server VM Oracle Corporation 9.0.1+11 9.0.1+11 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=172.17.0.1, max_actions_per_request=10000, max_concurrent_requests=8, max_volume_per_request=10mb, name=importer, port=9200, sniff=false} [12:52:53,487][INFO ][org.elasticsearch.plugins][pool-3-thread-1] [importer] modules [], plugins [helper], sites [] [12:52:53,823][ERROR][org.xbib.pipeline.AbstractPipeline][pool-3-thread-1] null java.lang.ExceptionInInitializerError at org.xbib.elasticsearch.common.GcMonitor$GcMonitorThread.<init>(GcMonitor.java:94) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.common.GcMonitor.<init>(GcMonitor.java:54) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BaseTransportClient.createClient(BaseTransportClient.java:71) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BaseMetricTransportClient.init(BaseMetricTransportClient.java:40) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BulkTransportClient.init(BulkTransportClient.java:96) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.ClientBuilder.toBulkTransportClient(ClientBuilder.java:112) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.createIngest(StandardSink.java:348) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.beforeFetch(StandardSink.java:100) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.beforeFetch(StandardContext.java:183) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:164) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:199) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:185) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:51) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50) [elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16) [elasticsearch-jdbc-2.3.1.0.jar:?] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) [?:?] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) [?:?] at java.base/java.lang.Thread.run(Thread.java:844) [?:?] Caused by: java.lang.UnsupportedOperationException: Boot class path mechanism is not supported at java.management/sun.management.RuntimeImpl.getBootClassPath(RuntimeImpl.java:99) ~[?:?] at org.xbib.elasticsearch.common.jvm.JvmInfo.<clinit>(JvmInfo.java:66) ~[elasticsearch-helper-2.3.1.0.jar:?] ... 19 more [12:52:53,825][ERROR][importer.jdbc ][main] java.lang.ExceptionInInitializerError java.util.concurrent.ExecutionException: java.lang.ExceptionInInitializerError at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:?] at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191) ~[?:?] at org.xbib.pipeline.SimplePipelineExecutor.waitFor(SimplePipelineExecutor.java:125) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.MetricSimplePipelineExecutor.waitFor(MetricSimplePipelineExecutor.java:59) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.execute(JDBCImporter.java:238) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.run(JDBCImporter.java:146) [elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.run(JDBCImporter.java:122) [elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.Runner.main(Runner.java:28) [elasticsearch-jdbc-2.3.1.0.jar:?] Caused by: java.lang.ExceptionInInitializerError at org.xbib.elasticsearch.common.GcMonitor$GcMonitorThread.<init>(GcMonitor.java:94) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.common.GcMonitor.<init>(GcMonitor.java:54) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BaseTransportClient.createClient(BaseTransportClient.java:71) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BaseMetricTransportClient.init(BaseMetricTransportClient.java:40) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BulkTransportClient.init(BulkTransportClient.java:96) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.ClientBuilder.toBulkTransportClient(ClientBuilder.java:112) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.createIngest(StandardSink.java:348) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.beforeFetch(StandardSink.java:100) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.beforeFetch(StandardContext.java:183) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:164) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:199) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:185) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:51) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) ~[?:?] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) ~[?:?] at java.base/java.lang.Thread.run(Thread.java:844) ~[?:?] Caused by: java.lang.UnsupportedOperationException: Boot class path mechanism is not supported at java.management/sun.management.RuntimeImpl.getBootClassPath(RuntimeImpl.java:99) ~[?:?] at org.xbib.elasticsearch.common.jvm.JvmInfo.<clinit>(JvmInfo.java:66) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.common.GcMonitor$GcMonitorThread.<init>(GcMonitor.java:94) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.common.GcMonitor.<init>(GcMonitor.java:54) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BaseTransportClient.createClient(BaseTransportClient.java:71) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BaseMetricTransportClient.init(BaseMetricTransportClient.java:40) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.BulkTransportClient.init(BulkTransportClient.java:96) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.helper.client.ClientBuilder.toBulkTransportClient(ClientBuilder.java:112) ~[elasticsearch-helper-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.createIngest(StandardSink.java:348) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSink.beforeFetch(StandardSink.java:100) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.beforeFetch(StandardContext.java:183) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:164) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:199) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:185) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:51) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16) ~[elasticsearch-jdbc-2.3.1.0.jar:?] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) ~[?:?] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) ~[?:?] at java.base/java.lang.Thread.run(Thread.java:844) ~[?:?]
When I am requesting [curl -XGET http://localhost:9200/users/_search/?pretty] I AM GETTING.

{
  "error" : {
    "root_cause" : [ {
      "type" : "index_not_found_exception",
      "reason" : "no such index",
      "resource.type" : "index_or_alias",
      "resource.id" : "users",
      "index" : "users"
    } ],
    "type" : "index_not_found_exception",
    "reason" : "no such index",
    "resource.type" : "index_or_alias",
    "resource.id" : "users",
    "index" : "users"
  },
  "status" : 404
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions