2014-05-20 13:42 GMT+02:00 Daniel Mikusa <dmik...@gopivotal.com>: > 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.
My first search: http://stackoverflow.com/questions/16331959/java-sql-sqlexception-already-closed > > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org