Ok, troubleshooting jdbc connection pools can be tricky... Good catch Andrea..
V

Sent from my iPad

On Feb 4, 2013, at 9:22 AM, "Andrea Aime" 
<[email protected]<mailto:[email protected]>> wrote:

On Mon, Feb 4, 2013 at 3:16 PM, 
[email protected]<mailto:[email protected]> 
<[email protected]<mailto:[email protected]>> wrote:
I checked the sessions from v$session Oracle view. During the time geoserver 
was not working correctly I verified that the connections were opened and 
INACTIVE on Oracle DB.

Ah, ok. Looked at the stack trace again, the issue is actually lost connections,
connections that are not getting closed by some code in GeoServer.

We had this issue in GetFeatureInfo, and it got fixed some time ago:
http://jira.codehaus.org/browse/GEOS-4857

Not sure if the fix actually made it into 2.2.1, since the ticket was closed
the same day as the release, but it should be in 2.2.2 onwards

Cheers
Andrea

--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it 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

-------------------------------------------------------
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to