RE: JdbcDataSource and threads

2011-09-24 Thread Vazquez, Maria (STM)
: solr-user@lucene.apache.org Sent: Sat, Sep 24, 2011 18:11:20 GMT+00:00 Subject: RE: JdbcDataSource and threads My guess on this is that you're making a LOT of database requests and have a million TIME-WAIT connections, and your port range for local ports is running out. You should first conf

RE: JdbcDataSource and threads

2011-09-24 Thread rkuris
d my load times from 20 hours to 20 minutes. Let me know if you're interested in that code. -- View this message in context: http://lucene.472066.n3.nabble.com/JdbcDataSource-and-threads-tp3359874p3364831.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: JdbcDataSource and threads

2011-09-23 Thread pulkitsinghal
24) >at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator. t>(JdbcDataSource.java:238) >... 17 more > > -Original Message- > From: Rahul Warawdekar [mailto:rahul.warawde...@gmail.com] > Sent: Friday, September 23, 2011 11:21 AM > To: solr

RE: JdbcDataSource and threads

2011-09-23 Thread Vazquez, Maria (STM)
... 17 more -Original Message- From: Rahul Warawdekar [mailto:rahul.warawde...@gmail.com] Sent: Friday, September 23, 2011 11:21 AM To: solr-user@lucene.apache.org Subject: Re: JdbcDataSource and threads I am using Solr 3.1. But you can surely try the patch with 3.3. On Fri, Sep 23,

Re: JdbcDataSource and threads

2011-09-23 Thread Rahul Warawdekar
Maria > > > -Original Message- > From: Rahul Warawdekar [mailto:rahul.warawde...@gmail.com] > Sent: Thursday, September 22, 2011 12:46 PM > To: solr-user@lucene.apache.org > Subject: Re: JdbcDataSource and threads > > Hi, > > Have you applied the pat

RE: JdbcDataSource and threads

2011-09-23 Thread Vazquez, Maria (STM)
t: Re: JdbcDataSource and threads Hi, Have you applied the patch that is provided with the Jira you mentioned ? https://issues.apache.org/jira/browse/SOLR-2233 Please apply the patch and check if you are getting the same exceptions. It has worked well for me till now. On Thu, Sep 22, 2011 at 3:17 PM, Va

Re: JdbcDataSource and threads

2011-09-22 Thread Rahul Warawdekar
Hi, Have you applied the patch that is provided with the Jira you mentioned ? https://issues.apache.org/jira/browse/SOLR-2233 Please apply the patch and check if you are getting the same exceptions. It has worked well for me till now. On Thu, Sep 22, 2011 at 3:17 PM, Vazquez, Maria (STM) < maria

JdbcDataSource and threads

2011-09-22 Thread Vazquez, Maria (STM)
Hi! So as of 3.4 JdbcDataSource doesn't work with threads, correct? https://issues.apache.org/jira/browse/SOLR-2233 I'm using Microsoft SQL Server, my data-config.xml has a lot of very complex SQL queries and it takes a long time to index. I'm migrating from Lucene to Solr and the Lucene