Peter Smythe (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5b3b4ba74e83c12dd31159d6
) *created* an issue
GeoServer (
https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMzJmOTdjMDg0NjQzNGQ1N2E4Mzk4OGQyNWNiZmU5N2QiLCJwIjoiaiJ9
) / Bug (
https://osgeo-org.atlassian.net/browse/GEOS-10322?atlOrigin=eyJpIjoiMzJmOTdjMDg0NjQzNGQ1N2E4Mzk4OGQyNWNiZmU5N2QiLCJwIjoiaiJ9
) GEOS-10322 (
https://osgeo-org.atlassian.net/browse/GEOS-10322?atlOrigin=eyJpIjoiMzJmOTdjMDg0NjQzNGQ1N2E4Mzk4OGQyNWNiZmU5N2QiLCJwIjoiaiJ9
) JDBCConfig community module does not deal with stale connections to the
database (
https://osgeo-org.atlassian.net/browse/GEOS-10322?atlOrigin=eyJpIjoiMzJmOTdjMDg0NjQzNGQ1N2E4Mzk4OGQyNWNiZmU5N2QiLCJwIjoiaiJ9
)
Issue Type: Bug Affects Versions: 2.20.1 Assignee: Unassigned Components:
JDBCConfig Created: 03/Dec/21 8:19 AM Priority: Medium Reporter: Peter Smythe (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=5b3b4ba74e83c12dd31159d6
)
In our use case, the GeoServer is infrequently used overnight and some system
(a firewall?) terminates the idle TCP connection between GeoServer and the JDBC
Config database after about 2 hours.
In the morning, when the GeoServer tries to read the catalog via
JDBCConfig/Store, it hangs, blocking any request, for about 15-16 minutes while
the stale connection is tried.
We will shortly submit a PR that adds a test while idle flag and timer to the
Apache Commons DBCP used by JDBCConfig. This solves our problem by periodically
testing all the connections in the pool and recreating them if they are stale.
(
https://osgeo-org.atlassian.net/browse/GEOS-10322#add-comment?atlOrigin=eyJpIjoiMzJmOTdjMDg0NjQzNGQ1N2E4Mzk4OGQyNWNiZmU5N2QiLCJwIjoiaiJ9
) Add Comment (
https://osgeo-org.atlassian.net/browse/GEOS-10322#add-comment?atlOrigin=eyJpIjoiMzJmOTdjMDg0NjQzNGQ1N2E4Mzk4OGQyNWNiZmU5N2QiLCJwIjoiaiJ9
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100183-
sha1:844c6ad )
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
