Thanks Mikhail, data config is on the thread above. I’ll share again if you can’t find it
Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________ From: Mikhail Khludnev <m...@apache.org> Sent: Sunday, November 24, 2019 2:51:40 PM To: solr-user <solr-user@lucene.apache.org> Subject: Re: Solr 4 to Solr7 migration DIH behavior change Note - This message originated from outside Care.com - Please use caution before opening attachments, clicking on links or sharing information. Hello, Shashank. The error seems similar, but I didin't find an old issue with such error. I've found only one abandoned thread in the mailing list. ='17' seems suspicious to me, usually it should be done via prepared statement. Have no thoughts, maybe you can share you data config? On Sun, Nov 24, 2019 at 10:40 PM Shashank Bellary <sbell...@care.com> wrote: > Any thoughts guys? I tried with mysql driver v8 also, still no luck > > 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. > -- Sincerely yours Mikhail Khludnev 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.
