On Mon, Apr 28, 2014 at 4:31 PM, Justin Deoliveira <
jdeol...@boundlessgeo.com> wrote:
> I'll take the conservative approach of "if it ain't broke don't fix it".
> With the java7 upgrade still ongoing we already have enough moving parts so
> perhaps we should put this one off for now since it doesn't actually fix a
> known issue. But no strong opinion, just my $0.02
>
Hi all,
in the last few days I stumbled into not one, but two separate cases in
which "it is broken".
In both cases there is a overzealous network apparatus between the
connection pool and the database that,
for security reasons, automatically closes the TCP connections that have
been idle for too long time.
However, it does that in a very nasty way, when the JDBC driver tries to
use the connection the query
gets sent over, goes nowhere, the driver does not notice though, and it
eventually times out after
around 10 minutes wait.
This is... really really nasty, if you stumble into one such connections
the response won't come
back in ages, and during that time, the connection will keep on using a
slot in the pool, reducing
its capacity.
Turns out there is nothing we can do at the DCBP 1.4 level, but both DBCP
2.0 and Tomcat pool
have a configuration to just drop connections that have been idle for too
long.
I'm leaning towards an upgrade to DBCP 2.0, mostly because I'm nervous
about Tomcat deploys
where having tomcat-pool both in the webapp and in the tomcat shared libs,
possibly with different
versions of the library, may result nasty issues (ever tried having a jdbc
driver both
in the app and in the shared libs? it does not work).
Cheers
Andrea
--
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
