lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fuad Efendi" <f...@efendi.ca>
Subject RE: DIH: Exception with "Too many connections"
Date Tue, 31 May 2011 12:53:00 GMT
Hi,


There is existing bug in DataImportHandler described (and patched) at
https://issues.apache.org/jira/browse/SOLR-2233
It is not used in a thread safe manner, and it is not appropriately closed &
reopened (why?); and new connection is opened unpredictably. It may cause
"Too many connections" even for huge SQL-side max_connections.

If you are interested, I can continue work on SOLR-2233. CC: dev@lucene (is
anyone working on DIH improvements?)

Thanks,
Fuad Efendi
http://www.tokenizer.ca/


-----Original Message-----
From: Fran├žois Schiettecatte [mailto:fschiettecatte@gmail.com] 
Sent: May-31-11 7:44 AM
To: solr-user@lucene.apache.org
Subject: Re: DIH: Exception with "Too many connections"

Hi

You might also check the 'max_user_connections' settings too if you have
that set:

# Maximum number of connections, and per user
max_connections                   = 2048
max_user_connections              = 2048

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html

Cheers

Fran├žois



>> So, if the number of threads in the process list is larger than 
>> max_connections, I would get the "too many connections" error.  Am I 
>> thinking the right way?
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message