Home > Back-end >  Solr7.4.0 import data error, but can't see where is wrong
Solr7.4.0 import data error, but can't see where is wrong

Time:09-26

Exception while processing: dept document: SolrInputDocument (fields: []) : org. Apache. Solr. Handler. Dataimport. DataImportHandlerException: Unable to execute the query: SELECT * FROM dept processing document # 1
The at org. Apache. Solr. Handler. Dataimport. DataImportHandlerException. WrapAndThrow (DataImportHandlerException. Java: 69)
At org. Apache. Solr. Handler. Dataimport. JdbcDataSource $ResultSetIterator. (327) JdbcDataSource. Java:
The at org. Apache. Solr. Handler. Dataimport. JdbcDataSource. CreateResultSetIterator (JdbcDataSource. Java: 288)
The at org. Apache. Solr. Handler. Dataimport. JdbcDataSource. GetData (JdbcDataSource. Java: 283)
The at org. Apache. Solr. Handler. Dataimport. JdbcDataSource. GetData (JdbcDataSource. Java: 52)
The at org. Apache. Solr. Handler. Dataimport. SqlEntityProcessor. InitQuery (SqlEntityProcessor. Java: 59)
The at org. Apache. Solr. Handler. Dataimport. SqlEntityProcessor. NextRow (SqlEntityProcessor. Java: 73)
The at org. Apache. Solr. Handler. Dataimport. EntityProcessorWrapper. NextRow (EntityProcessorWrapper. Java: 267)
The at org. Apache. Solr. Handler. Dataimport. DocBuilder. BuildDocument (DocBuilder. Java: 476)
The at org. Apache. Solr. Handler. Dataimport. DocBuilder. BuildDocument (DocBuilder. Java: 415)
The at org. Apache. Solr. Handler. Dataimport. DocBuilder. DoFullDump (DocBuilder. Java: 330)
The at org. Apache. Solr. Handler. Dataimport. DocBuilder. Execute (DocBuilder. Java: 233)
The at org. Apache. Solr. Handler. Dataimport. DataImporter. DoFullImport (DataImporter. Java: 424)
The at org. Apache. Solr. Handler. Dataimport. DataImporter. RunCmd (DataImporter. Java: 483)
The at org. Apache. Solr. Handler. Dataimport. DataImporter. Lambda $runAsync $0 (DataImporter. Java: 466)
The at Java. Lang. Thread. The run (Thread. Java: 748)
Under Caused by: com.mysql.cj.jdbc.exceptions.Com municationsException: Communications link failure

The last packet sent successfully to The server was 0 milliseconds line. The driver has not received any packets from The server.
At com. Mysql. Cj. JDBC. Exceptions. SQLError. CreateCommunicationsException (SQLError. Java: 174)
At com. Mysql. Cj. JDBC. Exceptions. SQLExceptionsMapping. TranslateException (SQLExceptionsMapping. Java: 64)
At com. Mysql. Cj. JDBC. ConnectionImpl. CreateNewIO (ConnectionImpl. Java: 835)
At com. Mysql. Cj. JDBC. ConnectionImpl. (455) ConnectionImpl. Java:
At com. Mysql. Cj. JDBC. ConnectionImpl. GetInstance (ConnectionImpl. Java: 240)
At com. Mysql. Cj. JDBC. NonRegisteringDriver. Connect (NonRegisteringDriver. Java: 207)
The at org. Apache. Solr. Handler. Dataimport. JdbcDataSource $1. Call (192) JdbcDataSource. Java:
The at org. Apache. Solr. Handler. Dataimport. JdbcDataSource $1. Call (172) JdbcDataSource. Java:
The at org. Apache. Solr. Handler. Dataimport. JdbcDataSource. GetConnection (JdbcDataSource. Java: 528)
At org. Apache. Solr. Handler. Dataimport. JdbcDataSource $ResultSetIterator. (317) JdbcDataSource. Java:
. 14 more
Under Caused by: com. Mysql. Cj. Exceptions. CJCommunicationsException: Communications link failure

The last packet sent successfully to The server was 0 milliseconds line. The driver has not received any packets from The server.
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance0 (Native Method)
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance (NativeConstructorAccessorImpl. Java: 62)
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (DelegatingConstructorAccessorImpl. Java: 45)
The at Java. Lang. Reflect. Constructor. NewInstance (423) Constructor. Java:
At com. Mysql. Cj. Exceptions. ExceptionFactory. CreateException (ExceptionFactory. Java: 61)
At com. Mysql. Cj. Exceptions. ExceptionFactory. CreateException (ExceptionFactory. Java: 105)
At com. Mysql. Cj. Exceptions. ExceptionFactory. CreateException (ExceptionFactory. Java: 151)
At com. Mysql. Cj. Exceptions. ExceptionFactory. CreateCommunicationsException (ExceptionFactory. Java: 167)
At com. Mysql. Cj. Protocol. A.N ativeSocketConnection. Connect (NativeSocketConnection. Java: 91)
At com. Mysql. Cj. NativeSession. Connect (NativeSession. Java: 152)
At com. Mysql. Cj. JDBC. ConnectionImpl. ConnectOneTryOnly (ConnectionImpl. Java: 955)
At com. Mysql. Cj. JDBC. ConnectionImpl. CreateNewIO (ConnectionImpl. Java: 825)
. 21 more
Under Caused by: java.net.ConnectException: Connection refused (Connection refused)
The at java.net.PlainSocketImpl.socketConnect (Native Method)
At java.net.AbstractPlainSocketImpl.doConnect AbstractPlainSocketImpl. Java: (350)
At java.net.AbstractPlainSocketImpl.connectToAddress AbstractPlainSocketImpl. Java: (206)
At java.net.AbstractPlainSocketImpl.connect AbstractPlainSocketImpl. Java: (188)
At java.net.SocksSocketImpl.connect SocksSocketImpl. Java: (392)
At java.net.Socket.connect (589) Socket. Java:
At com. Mysql. Cj. Protocol. StandardSocketFactory. Connect (StandardSocketFactory. Java: 155)
At com. Mysql. Cj. Protocol. A.N ativeSocketConnection. Connect (NativeSocketConnection. Java: 65)
. 24 more
  • Related