Nahum,
seams that you are using a connection pool, could you post the configuration you are using for that store?
I think it could be a connection validation problem:
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getConnection(AbstractManageableDataSource.java:46)
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1652)
... 114 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
waiting for the store and connection pool configuration to understand.
Carlo
________________________________
Date: Mon, 12 Nov 2012 00:00:22 -0600
From: jira@anonymised.com
To: geoserver-devel@lists.sourceforge.net
Subject: [Geoserver-devel] [jira] (GEOS-5397) At some point geoserver
stops connecting with postgresql
[https://dub108.mail.live.com/Handlers/ImageProxy.mvc?bicild=&canary=nlqB354I3ITNcNeFte8yol2S0wExgpPfRCxOxZOTzZM%3D0&url=http%3A%2F%2Fwww.codehaus.org%2Fcodehaus-small.gif]
[https://jira.codehaus.org/secure/useravatar?avatarId=10232]
nahum
castro<https://jira.codehaus.org/secure/ViewProfile.jspa?name=ncastrog>
created [Bug] GEOS-5397<https://jira.codehaus.org/browse/GEOS-5397>
At some point geoserver stops connecting with
postgresql<https://jira.codehaus.org/browse/GEOS-5397>
Issue Type: [Bug] Bug
Affects Versions: 2.2
Assignee: Andrea
Aime<https://jira.codehaus.org/secure/ViewProfile.jspa?name=aaime>
Attachments: catalina.out.zip, jira.txt
Created: 11/Nov/12 11:58 PM
Description:
At some point geoserver begins to left connections open in postgresql
but can't get data, less than a minute before in postgres I get the
next error
ERROR: "unexpected EOF on client connection"
I restarted geoserver and then connects again, but only for 3 restarts,
now geoserver is dead.
Here is the message when I click on layer preview [jira.txt]
Also I include an extract from catalina.out text
I reproduced this behavior on geoserver 2.2, 2.2.1 from sourceforge and
the 2.2 SVN from opengeo.
To reproduce load any layer on postgres 9.2.1 with postgis 2.0.1, move
on the openlayers viewer for at least 50 times.
Thanks in advance
Environment: Linux CentOS 6.3 x86_64, Java 1.7 update 9, Tomcat
7.0.29, PostgreSQL 9.2.1, Postgis 2.0.1
Project: GeoServer<https://jira.codehaus.org/browse/GEOS>
Priority: [Major] Major
Reporter: nahum
castro<https://jira.codehaus.org/secure/ViewProfile.jspa?name=ncastrog>
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA
administrators<https://jira.codehaus.org/secure/ContactAdministrators!default.jspa>\.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
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_nov
_______________________________________________ Geoserver-devel mailing
list Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
Major