Hi all,
We are using Geoserver 2.6 with Postgres 9.2 on the same server and time to time Geoserver becomes unresponsive.
After checking the logs, it have a number of this error:
ERROR [geoserver.ows] -
java.lang.RuntimeException: Unable to obtain connection: Cannot get a connection, pool error Timeout waiting for idle object
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1820)
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:939)
at org.geotools.data.store.ContentDataStore.entry(ContentDataStore.java:567)
at org.geotools.data.store.ContentDataStore.ensureEntry(ContentDataStore.java:608)
at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:389)
at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:356)
Found only very similar issue solved in version 2.2: https://jira.codehaus.org/browse/GEOS-4857 which seems to be fixed now.
The problem seems to be between the communication between geoserver and postgis, but since they are on the same box, we should not have connectivity problems.
I also checked postgres and found nothing in the logs.
Geoserver recovers after 5-10 minutes from this problem, no restart required, but after a while locks up again. it starts to be quite annoying.
Any idea what could cause the problem?
Regards,
Attila