It has been working perfectly fine thus far.As far as i have analysed there have been no changes to the firewall or database settings.I will however try and implement your suggestion to setup a validation query.
On Tue, May 20, 2014 at 5:12 PM, Daniel Mikusa <dmik...@gopivotal.com>wrote: > 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 > >
