On Sun, Jun 1, 2014 at 10:55 PM, Shawn Heisey <s...@elyograg.org> wrote:
> On 5/31/2014 1:54 PM, Aniket Bhoi wrote: > > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The result > >>> set is closed. > > I still think this is an indication of the source of the problem. > Something closed the connection to your SQL server before Solr was done > with it. That could have been JDBC itself, or it might have been > something else. I think I can safely say that it wasn't Solr. > > Your stacktrace indicates that Tomcat's database connection pooling is > active. Tomcat's connection pooling has a feature for dropping > abandoned connections. If you have enabled this feature, this could be > the problem. > > Abandoned connection dropping (when it is enabled) happens by default 60 > seconds after the connection is established. If you have database > connections that last longer than 60 seconds (which Solr's dataimport is > very likely to do), you need to increase removeAbandonedTimeout to > something larger than the longest time an import is likely to last -- or > disable removeAbandoned entirely. The latter is probably a better option. > > http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html > > Thanks, > Shawn > > I changed the value of removeAbandoned to false,this time the indexing failed due to a different exception: SEVERE: Exception while processing: srch_call document : null:org.apache.solr.handler.dataimport.DataImportHandlerException: Error reading data from database at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.getARow(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$600(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.next(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.next(Unknown Source) at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(Unknown Source) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(Unknown Source) at org.apache.solr.handler.dataimport.ThreadedEntityProcessorWrapper.nextRow(Unknown Source) at org.apache.solr.handler.dataimport.DocBuilder$EntityRunner.runAThread(Unknown Source) at org.apache.solr.handler.dataimport.DocBuilder$EntityRunner.access$000(Unknown Source) at org.apache.solr.handler.dataimport.DocBuilder$EntityRunner$1.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) *Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset* at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170) at com.microsoft.sqlserver.jdbc.SimpleInputStream.getBytes(SimpleInputStream.java:350) at com.microsoft.sqlserver.jdbc.DDC.convertStreamToObject(DDC.java:419) at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:2007) at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:175) at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:113) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1982) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1967) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(SQLServerResultSet.java:2256) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(SQLServerResultSet.java:2265) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:295) ... 13 more
