On May 20, 2014, at 7:35 AM, Aniket Bhoi <aniket.b...@gmail.com> wrote:
> I have Apache Solr,hosted on my apache Tomcat Server > > Details: > > Tomcat version: > Apache Tomcat/6.0.18 This is really, really old. You should upgrade. > > 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. Hard to say why this is happening (database server setting, firewall, bad code, etc.) but something is closing the connection and not telling the pool. You can work around this by setting a validation query on your connection pool and enabling “testOnBorrow”. That will instruct the pool to check connections before they are given out. Bad connections will be closed and replaced, if needed. Dan > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
