ik mysql热加载分词_修改IK 6.2.2分词器源码来基于mysql热更新词库,出现链接不上数据库...-CSDN博客

本文链接：https://blog.csdn.net/weixin_31613423/article/details/113330604

在尝试使用Elasticsearch 6.2.2版本的IK 6.2.2分词器并配置为基于MySQL热更新词库时，遇到数据库连接失败的问题。尽管相同配置在Elasticsearch 5.2.0及IK 5.2.0上工作正常，但在6.2.2版本中出现了Communications link failure错误。日志显示了数据库连接的相关配置，包括URL、SQL查询等，但最终无法建立连接。

摘要由CSDN通过智能技术生成

我在用elasticsearch6.2.2安装IK6.2.2分词器的时候，一切正常，当使用IK 6.2.2分词器基于mysql热更新词库的时候链接不上数据库，用elasticsearch-5.2.0安装IK5.2.0基于mysql热更新词库一切正常，请问大家遇到过吗？

[2018-05-08T22:14:06,241][INFO ][o.w.a.d.Monitor ] [==========]jdbc-reload.properties

[2018-05-08T22:14:06,246][INFO ][o.w.a.d.Monitor ] [==========]jdbc.url=jdbc:mysql://localhost:3306/ik_dict?serverTimezone=GMT

[2018-05-08T22:14:06,250][INFO ][o.w.a.d.Monitor ] [==========]jdbc.reload.sql=select word from hot_words

[2018-05-08T22:14:06,255][INFO ][o.w.a.d.Monitor ] [==========]jdbc.reload.interval=1000

[2018-05-08T22:14:06,260][INFO ][o.w.a.d.Monitor ] [==========]jdbc.reload.stopword.sql=select stopword as word from hot_stopwords

[2018-05-08T22:14:06,264][INFO ][o.w.a.d.Monitor ] [==========]jdbc.user=root

[2018-05-08T22:14:06,268][INFO ][o.w.a.d.Monitor ] [==========]jdbc.password=123456

[2018-05-08T22:14:06,273][INFO ][o.w.a.d.Monitor ] [==========]query hot stopword dict from mysql, select stopword as word from hot_stopwords......

[2018-05-08T22:14:06,282][ERROR][o.w.a.d.Monitor ] erorr

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at sun.reflect.GeneratedConstructorAccessor28.newInstance(Unknown Source) ~[?:?]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]

at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0_45]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.9.jar:?]

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) ~[mysql-connector-java-5.1.9.jar:?]

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2209) ~[mysql-connector-java-5.1.9.jar:?]

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.9.jar:?]

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46) ~[mysql-connector-java-5.1.9.jar:?]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]

at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0_45]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.9.jar:?]

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) ~[mysql-connector-java-5.1.9.jar:?]

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284) ~[mysql-connector-java-5.1.9.jar:?]