[Netarchivesuite-devel] About the DBConnect class, running out of connections

[Nicolas Giraud]

Hi Søren,

Problem is that our PostgreSQL DB is not configured to timeout connections,
or at least the timeout is pretty long, and I'm struggling to find a way to
configure such a timeout. My investigation so far shows that most
connections are opened by JSP containers, I have to go deeper with this.

Nicolas

2011/3/25 Søren Vejrup Carlsen <svc at kb.dk>

>  Hi Nicolas.
>
> You could be right about NAS never closing the database connections. But
> the connections to the database timeout automatically,
>
> don’t they?
>
>
>
> We’ve had similar problems with derby in our production environment running
> 3.14.1.
>
>
>
> But we didn’t see in our test-environment.
>
> Are you running the database on the same server as the processes running?
>
>
>
> Best Regards
>
> Søren
>
>
>
> *Fra:* netarchivesuite-devel-bounces at lists.gforge.statsbiblioteket.dk[mailto:
> netarchivesuite-devel-bounces at lists.gforge.statsbiblioteket.dk] *På vegne
> af *Nicolas Giraud
> *Sendt:* 25. marts 2011 14:57
> *Til:* netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
> *Emne:* [Netarchivesuite-devel] About the DBConnect class, running out of
> connections
>
>
>
> Hi,
>
> On our new production environment, we have run into a error where the DB
> has too many open connections. I've started investigating on this, by
> looking at the DBConnect class.
>
> First the "connection pool" in it seems bugged, as if any Thread in the
> WeakHashMap is garbage collected, the associated connection might still be
> open and is not closed. Also I don't see anywhere in all of the code a call
> to Connection#close(), except in DomainDBDao#close() which by the way is
> never called.
>
> Where are DB connections closed ? It seems they are never closed, unless I
> have completely misunderstood the code.
>
> Any help will be greatly appreciated.
>
> Cheers,
>
> --
> Nicolas Giraud
>
> ---------------------------------------------------------------------------------------------
> Développeur Archives du Web - Bibliothèque Nationale de France
> Web Archiving Developper - National Library of France
>
> ---------------------------------------------------------------------------------------------
>
> _______________________________________________
> Netarchivesuite-devel mailing list
> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
>
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>
>


-- 
Nicolas Giraud
---------------------------------------------------------------------------------------------
Développeur Archives du Web - Bibliothèque Nationale de France
Web Archiving Developper - National Library of France
---------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.sbforge.org/pipermail/netarchivesuite-devel/attachments/20110325/4e9f8e38/attachment-0002.html>