Elasticsearch 2.x plugin 问题汇总-优快云博客

本文解决Elasticsearch2.3.2版本中使用jdbc插件连接Oracle数据库时遇到的驱动问题，以及sql插件启动后未重启导致的错误。针对jdbc插件，通过下载ojdbc6.jar解决了驱动不兼容的问题；对于sql插件，则需要重启Elasticsearch来避免无效索引名称错误。

1、Elasticsearch 2.3.2 jdbc 插件，在执行oracle的脚本时，报错没有可用的驱动

[00:18:00,518][ERROR][importer.jdbc.source.standard][pool-3-thread-1] while opening read connection: jdbc:oracle:thin:@//10.10.100.42:1521/gjcrm No suitable driver found for jdbc:oracle:thin:@//10.10.100.42:1521/gjcrm
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//10.10.100.42:1521/gjcrm
        at java.sql.DriverManager.getConnection(DriverManager.java:689) ~[?:1.8.0_101]
        at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_101]

发现oracle自带的驱动无法使用,在官网上下载了ojdbc6.jar才行。

2、Elasticsearch 2.3.2 sql 插件

执行后报错：

Error: {"error":{"root_cause":[{"type":"invalid_index_name_exception","reason":"Invalid index name [_sql], must not start with '_'","index":"_sql"}],"type":"invalid_index_name_exception","reason":"Invalid index name [_sql], must not start with '_'","index":"_sql"},"status":400}