I've not upgraded mysql driver to latest, I can you explain whats the issue
here?
thanks
On 11/22/19, 4:40 PM, "Shashank Bellary" <sbell...@care.com> wrote:
Note - This message originated from outside Care.com - Please use caution
before opening attachments, clicking on links or sharing information.
Yes, I'm on java 8 and mysql driver 5.1.13
Thanks
On 11/22/19, 3:00 PM, "Jörn Franke" <jornfra...@gmail.com> wrote:
Note - This message originated from outside Care.com - Please use
caution before opening attachments, clicking on links or sharing information.
Did you update the java version to 8? Did you upgrade the MySQL driver
to the latest version?
> Am 22.11.2019 um 20:43 schrieb Shashank Bellary <sbell...@care.com>:
>
>
>
> Hi Folks
> I migrated from Solr 4 to 7.5 and I see an issue with the way DIH is
working. I use `JdbcDataSource` and here the config file is attached
> 1) I started seeing OutOfMemory issue since MySQL JDBC driver has
that issue of not respecting `batchSize` (though Solr4 didn't show this
behavior). So, I added `batchSize=-1` for that
> 2) After adding that I'm running into ResultSet closed exception as
shown below while fetching the child entity
>
> getNext() failed for query ' SELECT REVIEW AS REVIEWS FROM
SOLR_SITTER_SERVICE_PROFILE_REVIEWS WHERE SERVICE_PROFILE_ID = '17' ;
':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:267)
> at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:476)
> at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:517)
> at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:415)
> at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:33)
> at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:233)
> at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:424)
> at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
> at
org.apache.solr.handler.dataimport.DataImporter.lambda$runAsync$0(DataImporter.java:466)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: java.sql.SQLException: Operation not allowed after
ResultSet closed
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
> at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
> at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7145)
> at
com.mysql.jdbc.StatementImpl.getMoreResults(StatementImpl.java:2078)
> at
com.mysql.jdbc.StatementImpl.getMoreResults(StatementImpl.java:2062)
> at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:458)
> ... 13 more
>
> Is this a known issue? How do I fix this, any help is greatly
appreciated.
>
> Thanks
> Shashank
> This email is intended for the person(s) to whom it is addressed and
may contain information that is PRIVILEGED or CONFIDENTIAL. Any unauthorized
use, distribution, copying, or disclosure by any person other than the
addressee(s) is strictly prohibited. If you have received this email in error,
please notify the sender immediately by return email and delete the message and
any attachments from your system.
> <serviceprofile-data-import.xml>
This email is intended for the person(s) to whom it is addressed and may
contain information that is PRIVILEGED or CONFIDENTIAL. Any unauthorized use,
distribution, copying, or disclosure by any person other than the addressee(s)
is strictly prohibited. If you have received this email in error, please notify
the sender immediately by return email and delete the message and any
attachments from your system.
This email is intended for the person(s) to whom it is addressed and may
contain information that is PRIVILEGED or CONFIDENTIAL. Any unauthorized use,
distribution, copying, or disclosure by any person other than the addressee(s)
is strictly prohibited. If you have received this email in error, please notify
the sender immediately by return email and delete the message and any
attachments from your system.
