[Deploying Sakai] database connections disappearing

[David Horwitz]

Hi Chuck,

Have you tried upgrading commons-pool? We've upgraded commons-pool in
the 1.1 kernel to 1.5.2 (we should go to 1.5.3) without any noticeable
problems. OOTB the 1.0 kernels are using commons-pool 1.3

D

Charles Hedrick wrote:
> Since we moved from 2.5 to 2.6 I've been seeing databaSe connections
> disappear. We start out with 300. We have set up dbcp to keep a
> constant 300. However over time we start building up connections that
> dbcp thinks are in use, but never get returned. The rate is about 3
> per day. The obvious suspicion would be that Sakai is getting a
> connection from the pool and not returning it. However doing "netstat"
> it's clear that the TCP connections are no longer open. I doubt that
> the server is closing them. It didn't in the past, and with a nearly
> idle front end we don't lose any. The amount we lose seems to be
> connected to activity. There's no way Sakai itself could be closing
> the TCP connection, since we don't set the option that lets the
> program access the underlying connection, and of course closing a
> pooled connection simply returns it to the pool. it looks to me like a
> malfunction in dbcp or pool. However it doesn't appear that dbcp has
> changed since 2.5.
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20091101/dd77e1b2/attachment.html