I have Apache Solr,hosted on my apache Tomcat Server Details:
Tomcat version: Apache Tomcat/6.0.18 OS details SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 1 While running indexing on this server,It failed. Log excerpt: SEVERE: Can not close connection java.sql.SQLException: Already closed. at org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:189) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.closeResources(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.access$500(Unknown Source) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(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) I suspect this to be an issue with the tomcat connection thread to the database being terminated/timed out. Need help as to why this is happening!. Regards Aniket