[daisy] connection pool exhausted

[Bruno Dumon]

On Tue, 2007-03-06 at 09:58 +0100, Tom Brusselle wrote:
> Hi,
> 
> We're running quite a big daisy (10920 documents and counting) and 
> recently we've started to get the following error: 
> "org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, 
> pool exhausted".  (full error below)
> 
> Once this happens nobody can login anymore and the only solution is 
> restarting the daisy merlin en wiki.
> 
> Is there a way to increase the number of available connections in the 
> pool?

Yes, this can be done in the myconfig.xml. The number of connections
doesn't need to be much higher than the number of concurrent users
though.

>    (or could it is possible that connections somehow don't get 
> released over time and that's wy we eventually run out?)

Seems like connections are leaking somewhere, it would be interesting to
know where. Is the Daisy repository server customized in some way? (such
as a custom authentication scheme).

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org