#673: Undeployed GeoNetwork leaves locks on a PostGIS database
---------------------+------------------------------------------------------
Reporter: murrayh | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: Future release
Component: General | Version:
Keywords: |
---------------------+------------------------------------------------------
Version: !GeoNetwork 2.7 svn rev 8285
Tomcat: 5.5.23
PostgreSQL: 8.1.23
PostGIS: 1.3.2
Java: Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
When !GeoNetwork is undeployed the following tables remain locked in
PostgreSQL:
* metadatanotifiers
* spatialindex
Tomcat must be stopped for the locks to be removed.
We are connecting to the PostgreSQL database using the following config:
<user>redacted/user>
<password>redacted</password>
<driver>org.postgis.!DriverWrapper</driver>
<url>jdbc:postgresql_postGIS://redacted:5432/redacted</url>
<poolSize>10</poolSize>
<reconnectTime>3600</reconnectTime>
I suspect exceptions at the bottom of 'catalina.out' (which I will attach)
are of interest:
Exception in thread "Cached Search Session Expiry Thread"
java.lang.NullPointerException
at
org.jzkit.search.impl.LRUCache.expunge(LRUCache.java:94)
at org.jzkit.search.impl.LRUCache.run(LRUCache.java:83)
Exception in thread "Timer-2" java.lang.NullPointerException
at org.hsqldb.resources.BundleHandler.getString(Unknown
Source)
at org.hsqldb.Trace.getMessage(Unknown Source)
at org.hsqldb.Trace.getMessage(Unknown Source)
at org.hsqldb.Result.<init>(Unknown Source)
at org.hsqldb.DatabaseCommandInterpreter.execute(Unknown
Source)
at org.hsqldb.Session.sqlExecuteDirectNoPreChecks(Unknown
Source)
at org.hsqldb.Session.execute(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown
Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.isConnectionValid(DirectEpsgFactory.java:3116)
at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.getConnection(DirectEpsgFactory.java:3082)
at
org.geotools.referencing.factory.epsg.DirectEpsgFactory.dispose(DirectEpsgFactory.java:2994)
at
org.geotools.referencing.factory.DeferredAuthorityFactory$Disposer.run(DeferredAuthorityFactory.java:219)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/673>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.