lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Islam Omar <islam.om...@gmail.com>
Subject Solr 6.4.1 Issue
Date Mon, 03 Apr 2017 15:55:44 GMT
Hi All ,

I have a trouble problem when doing *full import in solr 6.4.1 using MySQL
DB , the problem is : *

i need to create 1 core which will be around 9,500,000 documents , when i
do full import with *batchSize* *= -1* in datasource  , everything was ok
but when the solr finish fetching data from database it *can't stop* running
full import command and continue trying to fetch another data.

*the log throws this exception *

Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
java.sql.SQLException: Operation not allowed after ResultSet closed
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:61)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:464)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:377)
at
org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:133)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:75)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:244)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:475)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:414)
... 7 more
Caused by: java.sql.SQLException: Operation not allowed after ResultSet
closed
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:803)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6985)
at com.mysql.jdbc.StatementImpl.getMoreResults(StatementImpl.java:2232)
at com.mysql.jdbc.StatementImpl.getMoreResults(StatementImpl.java:2216)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:458)

*Best regards* ,
*Islam omar*
*Java developer*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message