Hello, I can't understand what does actually means "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.". Islam, How do you know that it finishes fetching the data? Are you sure that there was no any error or interrupt command which can cause the exception?
On Mon, Apr 3, 2017 at 6:55 PM, Islam Omar <islam.om...@gmail.com> wrote: > 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* > -- Sincerely yours Mikhail Khludnev
