RE: DIH: Exception with "Too many connections"

[Fuad Efendi <fu...@efendi.ca>]

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

RE: DIH: Exception with "Too many connections"

[tiffany <ti...@future.co.jp>]

Stephan,

Your advice (check the process list) gave me an important clue for my
solution.
I changed my database connection to the slave instead of master, so that I
can use more threads.
Thank you very much!

*** 

François,

My setting is the default value:
max_connections = 151  
max_user_connections = 0 

I will think of changing the max_connections when I increase the number of
cores.
Thanks!

***

Fuad,

So far, I can handle DIH with my setting.
Thanks for letting me know!


Regards,
Tiffany


--
View this message in context: http://lucene.472066.n3.nabble.com/DIH-Exception-with-Too-many-connections-tp3005213p3009206.html
Sent from the Solr - User mailing list archive at Nabble.com.