Re: [Geoserver-devel] Caused by: org.hsqldb.HsqlException: connection exception: closed

2016-10-12 Thread Stefan Tzeggai 
Hi Andrea

So, you say I do something strange/wrong... So, you are right ;-)

I developed this application with GeoServerRESTPublisher java client.
When I developed it, I had some troubles, and in trial-and-error I added 
a reload()-call after creating each layer.

The JavaDoc didn't sound too bad: "Reload the target geoserver 
configuration"

http://demo.geo-solutions.it/share/github/gsman/apidocs/it/geosolutions/geoserver/rest/GeoServerRESTPublisher.html#reload()

But.. as one can read more clearly here: 
http://docs.geoserver.org/stable/en/user/rest/api/reload.html
there should never be a need to call reload() unless you fiddle with the 
files - which I never do.

So.. when the production system grows towards 1000 layers, reload() 
seems to iterate over all of them. And if you issue 10 reload() commands 
in parallel as I did, things seem to break, as seen in my problem report.

I removed all calls to GeoServerRESTPublisher.reload() a few days ago 
and for now everything is running smooth and I guess that my problem is 
solved.

Maybe it would be an improvement to GS to synchronize the REST reload() 
calls.

Thanks a lot,
Steve


On 10/09/2016 08:33 PM, Andrea Aime wrote:
> Hi Stefan,
> it seems there is something uncommon in your environment... I know we
> are monitoring
> several systems in production, both linux and windows, and none of my
> colleagues have
> reported a similar issue.
>
> Btw, you might want to upgrade soon to a 2.9.2, stay tuned for the
> release announcement.
>
> Cheers
> Andrea
>
>
> On Sun, Oct 9, 2016 at 5:49 PM, Stefan Tzeggai  > wrote:
>
> Hi again
>
> I just wanted to report that I still get the error every few days with
> GeoServer 2.9.1. It seems to happen when there is a lot of parallel REST
> layer creation/reloading is going on.
>
> Because Geoserver does not recover from this error, I will for now start
> monitoring the logfile and redeploy Geoserver automatically.
>
> Just wanted to post the 2.9.1 stacktrace, maybe someone will be happy to
> find it:
>
> Greetings,
> Steve
>
> 06 Oct 10:42:33 WARN [org.geoserver] - Error decode epsg code:
> EPSG:31467
> org.opengis.referencing.FactoryException: Database failure while
> creating a 'CoordinateReferenceSystem' object for code "EPSG:31467".
>   at
> 
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(DirectEpsgFactory.java:3061)
>   at
> 
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2099)
>   at
> 
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
>   at
> 
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
>   at
> 
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
>   at
> 
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
>   at
> 
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:640)
>   at
> 
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:644)
>   at
> 
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
>   at
> 
> org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:731)
>   at
> 
> org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:179)
>   at org.geotools.referencing.CRS.decode(CRS.java:520)
>   at org.geotools.referencing.CRS.decode(CRS.java:448)
>   at
> 
> org.geoserver.config.util.XStreamPersister$SRSConverter.fromString(XStreamPersister.java:1221)
>   at
> 
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.fromString(SingleValueConverterWrapper.java:41)
>   at
> 
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.unmarshal(SingleValueConverterWrapper.java:49)
>   at
> 
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
>   at
> 
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
>   at
> 
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.java:474)
>   at
> 
> com.thoughtworks.xstream.converters.reflection.AbstractReflection

Re: [Geoserver-devel] Caused by: org.hsqldb.HsqlException: connection exception: closed

2016-10-09 Thread Andrea Aime 
Hi Stefan,
it seems there is something uncommon in your environment... I know we are
monitoring
several systems in production, both linux and windows, and none of my
colleagues have
reported a similar issue.

Btw, you might want to upgrade soon to a 2.9.2, stay tuned for the release
announcement.

Cheers
Andrea


On Sun, Oct 9, 2016 at 5:49 PM, Stefan Tzeggai 
wrote:

> Hi again
>
> I just wanted to report that I still get the error every few days with
> GeoServer 2.9.1. It seems to happen when there is a lot of parallel REST
> layer creation/reloading is going on.
>
> Because Geoserver does not recover from this error, I will for now start
> monitoring the logfile and redeploy Geoserver automatically.
>
> Just wanted to post the 2.9.1 stacktrace, maybe someone will be happy to
> find it:
>
> Greetings,
> Steve
>
> 06 Oct 10:42:33 WARN [org.geoserver] - Error decode epsg code: EPSG:31467
> org.opengis.referencing.FactoryException: Database failure while
> creating a 'CoordinateReferenceSystem' object for code "EPSG:31467".
>   at
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(
> DirectEpsgFactory.java:3061)
>   at
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.
> createCoordinateReferenceSystem(DirectEpsgFactory.java:2099)
>   at
> org.geotools.referencing.factory.BufferedAuthorityFactory.
> createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
>   at
> org.geotools.referencing.factory.AuthorityFactoryAdapter.
> createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
>   at
> org.geotools.referencing.factory.BufferedAuthorityFactory.
> createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
>   at
> org.geotools.referencing.factory.AuthorityFactoryAdapter.
> createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
>   at
> org.geotools.referencing.factory.FallbackAuthorityFactory.
> createCoordinateReferenceSystem(FallbackAuthorityFactory.java:640)
>   at
> org.geotools.referencing.factory.FallbackAuthorityFactory.
> createCoordinateReferenceSystem(FallbackAuthorityFactory.java:644)
>   at
> org.geotools.referencing.factory.AuthorityFactoryAdapter.
> createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
>   at
> org.geotools.referencing.factory.ThreadedAuthorityFactory.
> createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:731)
>   at
> org.geotools.referencing.DefaultAuthorityFactory.
> createCoordinateReferenceSystem(DefaultAuthorityFactory.java:179)
>   at org.geotools.referencing.CRS.decode(CRS.java:520)
>   at org.geotools.referencing.CRS.decode(CRS.java:448)
>   at
> org.geoserver.config.util.XStreamPersister$SRSConverter.
> fromString(XStreamPersister.java:1221)
>   at
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.
> fromString(SingleValueConverterWrapper.java:41)
>   at
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.unmarshal(
> SingleValueConverterWrapper.java:49)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(
> TreeUnmarshaller.java:72)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(
> TreeUnmarshaller.java:66)
>   at
> com.thoughtworks.xstream.converters.reflection.
> AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.
> java:474)
>   at
> com.thoughtworks.xstream.converters.reflection.
> AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.
> java:406)
>   at
> com.thoughtworks.xstream.converters.reflection.
> AbstractReflectionConverter.unmarshal(AbstractReflectionConverter.
> java:257)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(
> TreeUnmarshaller.java:72)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(
> TreeUnmarshaller.java:66)
>   at
> com.thoughtworks.xstream.converters.reflection.
> AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.
> java:474)
>   at
> com.thoughtworks.xstream.converters.reflection.
> AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.
> java:406)
>   at
> org.geoserver.config.util.XStreamPersister$ResourceInfoConverter.
> doUnmarshal(XStreamPersister.java:1729)
>   at
> com.thoughtworks.xstream.converters.reflection.
> AbstractReflectionConverter.unmarshal(AbstractReflectionConverter.
> java:257)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(
> TreeUnmarshaller.java:72)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(
> TreeUnmarshaller.java:66)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(
> TreeUnmarshaller.java:50)
>   at
> com.thoughtworks.xstream.core.TreeUnmarshaller.start(
> TreeUnmarshaller.java:134)
>   at
> com.thoughtworks.xstream.core.Abstra

Re: [Geoserver-devel] Caused by: org.hsqldb.HsqlException: connection exception: closed

2016-10-09 Thread Stefan Tzeggai 
Hi again

I just wanted to report that I still get the error every few days with 
GeoServer 2.9.1. It seems to happen when there is a lot of parallel REST 
layer creation/reloading is going on.

Because Geoserver does not recover from this error, I will for now start 
monitoring the logfile and redeploy Geoserver automatically.

Just wanted to post the 2.9.1 stacktrace, maybe someone will be happy to 
find it:

Greetings,
Steve

06 Oct 10:42:33 WARN [org.geoserver] - Error decode epsg code: EPSG:31467
org.opengis.referencing.FactoryException: Database failure while 
creating a 'CoordinateReferenceSystem' object for code "EPSG:31467".
  at 
org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(DirectEpsgFactory.java:3061)
  at 
org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2099)
  at 
org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
  at 
org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
  at 
org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
  at 
org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
  at 
org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:640)
  at 
org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:644)
  at 
org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:802)
  at 
org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:731)
  at 
org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:179)
  at org.geotools.referencing.CRS.decode(CRS.java:520)
  at org.geotools.referencing.CRS.decode(CRS.java:448)
  at 
org.geoserver.config.util.XStreamPersister$SRSConverter.fromString(XStreamPersister.java:1221)
  at 
com.thoughtworks.xstream.converters.SingleValueConverterWrapper.fromString(SingleValueConverterWrapper.java:41)
  at 
com.thoughtworks.xstream.converters.SingleValueConverterWrapper.unmarshal(SingleValueConverterWrapper.java:49)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
  at 
com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.java:474)
  at 
com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.java:406)
  at 
com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshal(AbstractReflectionConverter.java:257)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
  at 
com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.java:474)
  at 
com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.java:406)
  at 
org.geoserver.config.util.XStreamPersister$ResourceInfoConverter.doUnmarshal(XStreamPersister.java:1729)
  at 
com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshal(AbstractReflectionConverter.java:257)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:50)
  at 
com.thoughtworks.xstream.core.TreeUnmarshaller.start(TreeUnmarshaller.java:134)
  at 
com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.unmarshal(AbstractTreeMarshallingStrategy.java:32)
  at com.thoughtworks.xstream.XStream.unmarshal(XStream.java:1185)
  at com.thoughtworks.xstream.XStream.unmarshal(XStream.java:1169)
  at com.thoughtworks.xstream.XStream.fromXML(XStream.java:1049)
  at 
org.geoserver.config.util.XStreamPersister.load(XStreamPersister.java:597)
  at 
org.geoserver.config.GeoServerLoader.depersist(GeoServerLoader.java:764)
  at 
org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:374)
  at 
org.geoserver.con

Re: [Geoserver-devel] Caused by: org.hsqldb.HsqlException: connection exception: closed

2016-06-10 Thread Andrea Aime 
Hi Stefan,
in that case... I have no idea sorry :-(

Cheers
Andrea


On Fri, Jun 10, 2016 at 10:35 AM, Stefan Tzeggai 
wrote:

> Hi Andrea
>
> I am pretty sure they were not deleted because the hsql db files have a
> creation date from May 21st, the date of the last reboot (/tmp is wiped
> on reboot)
>
> /tmp/tomcat7-tomcat7-tmp/Geotools/Databases/HSQL/v8.6.0.0 # ll
> -rw-r--r-- 1 tomcat7 tomcat70 May 21 21:00 EPSG_creation_marker.txt
> -rw-r--r-- 1 tomcat7 tomcat7 16777216 May 21 21:00 EPSG.data
> -rw-r--r-- 1 tomcat7 tomcat7  114 May 21 21:00 EPSG.properties
> -rw-r--r-- 1 tomcat7 tomcat718320 May 21 21:00 EPSG.script
>
> Many greetings,
> Steve
>
>
> On 06/09/2016 07:50 PM, Andrea Aime wrote:
> > Ciao Stefan,
> > long time no see!
> >
> > Hum... we haven't seen this issue pop up in a while... just to verify,
> > are you sure nothing wiped out the hsql db file from the file system?
> > It would be found in the java temp directory, under Geotools and then
> > some other dirs with the espg name and version (don't have a sample
> > handy right here, right now)
> >
> > Cheers
> > Andrea
> >
> >
> > On Wed, Jun 8, 2016 at 1:09 PM, Stefan Tzeggai  > > wrote:
> >
> > Hi everybody,
> >
> > I run Geoserver 2.8.3 on Oracle Java 1.8.0_91 on Ubuntu Server 14.04
> >
> > It happens every few days/weeks that Geoserver stops working
> correctly!
> > The webinterface is still working, but creating layers with REST and
> > requesting WMS failes.
> >
> > Redeploying just geoserver.war (by removing and reinserting it into
> > /var/lib/tomcat7/webapps) makes everything work again.
> >
> > Below is the full stacktrace.
> >
> > I found these two links that might be related:
> >
> >
> http://stackoverflow.com/questions/11967361/executequery-in-multiple-threads-closes-hsqldb-database-connection
> >
> > https://sourceforge.net/p/geoserver/mailman/message/35051494/
> >
> > I observed this on a production system running for 17 days with more
> > than 3000 layers created via REST. From the logfile I can see that
> once
> > the problem occurs, all following WMS requests fail, also on layers
> > created earlier.
> >
> > How can I help to solve this?
> >
> > Greetings from Bolsena
> > Steve
> >
> >
> > [GC pause (G1 Evacuation Pause) (young) 18G->10G(25G), 0.1781596
> secs]
> > 07 Jun 15:55:02 WARN [org.geoserver] - Error decode epsg code:
> > EPSG:31467
> > org.opengis.referencing.FactoryException: Database failure while
> > creating a 'CoordinateReferenceSystem' object for code "EPSG:31467".
> >  at
> >
>  
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(DirectEpsgFactory.java:3061)
> >  at
> >
>  
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2099)
> >  at
> >
>  
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
> >  at
> >
>  
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
> >  at
> >
>  
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
> >  at
> >
>  
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
> >  at
> >
>  
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:640)
> >  at
> >
>  
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:644)
> >  at
> >
>  
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
> >  at
> >
>  
> org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:731)
> >  at
> >
>  
> org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:179)
> >  at org.geotools.referencing.CRS.decode(CRS.java:520)
> >  at org.geotools.referencing.CRS.decode(CRS.java:448)
> >  at
> >
>  
> org.geoserver.config.util.XStreamPersister$SRSConverter.fromString(XStreamPersister.java:1217)
> >  at
> >
>  
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.fromString(SingleValueConverterWrapper.java:41)
> >  at
> >
>  
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.unmarshal(SingleValueConverterWrapper.java:49)
> >  at
> >
>  
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
> >  at
> >
>  
> com.though

Re: [Geoserver-devel] Caused by: org.hsqldb.HsqlException: connection exception: closed

2016-06-10 Thread Stefan Tzeggai 
Hi Andrea

I am pretty sure they were not deleted because the hsql db files have a 
creation date from May 21st, the date of the last reboot (/tmp is wiped 
on reboot)

/tmp/tomcat7-tomcat7-tmp/Geotools/Databases/HSQL/v8.6.0.0 # ll
-rw-r--r-- 1 tomcat7 tomcat70 May 21 21:00 EPSG_creation_marker.txt
-rw-r--r-- 1 tomcat7 tomcat7 16777216 May 21 21:00 EPSG.data
-rw-r--r-- 1 tomcat7 tomcat7  114 May 21 21:00 EPSG.properties
-rw-r--r-- 1 tomcat7 tomcat718320 May 21 21:00 EPSG.script

Many greetings,
Steve


On 06/09/2016 07:50 PM, Andrea Aime wrote:
> Ciao Stefan,
> long time no see!
>
> Hum... we haven't seen this issue pop up in a while... just to verify,
> are you sure nothing wiped out the hsql db file from the file system?
> It would be found in the java temp directory, under Geotools and then
> some other dirs with the espg name and version (don't have a sample
> handy right here, right now)
>
> Cheers
> Andrea
>
>
> On Wed, Jun 8, 2016 at 1:09 PM, Stefan Tzeggai  > wrote:
>
> Hi everybody,
>
> I run Geoserver 2.8.3 on Oracle Java 1.8.0_91 on Ubuntu Server 14.04
>
> It happens every few days/weeks that Geoserver stops working correctly!
> The webinterface is still working, but creating layers with REST and
> requesting WMS failes.
>
> Redeploying just geoserver.war (by removing and reinserting it into
> /var/lib/tomcat7/webapps) makes everything work again.
>
> Below is the full stacktrace.
>
> I found these two links that might be related:
>
> 
> http://stackoverflow.com/questions/11967361/executequery-in-multiple-threads-closes-hsqldb-database-connection
>
> https://sourceforge.net/p/geoserver/mailman/message/35051494/
>
> I observed this on a production system running for 17 days with more
> than 3000 layers created via REST. From the logfile I can see that once
> the problem occurs, all following WMS requests fail, also on layers
> created earlier.
>
> How can I help to solve this?
>
> Greetings from Bolsena
> Steve
>
>
> [GC pause (G1 Evacuation Pause) (young) 18G->10G(25G), 0.1781596 secs]
> 07 Jun 15:55:02 WARN [org.geoserver] - Error decode epsg code:
> EPSG:31467
> org.opengis.referencing.FactoryException: Database failure while
> creating a 'CoordinateReferenceSystem' object for code "EPSG:31467".
>  at
> 
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(DirectEpsgFactory.java:3061)
>  at
> 
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2099)
>  at
> 
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
>  at
> 
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
>  at
> 
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
>  at
> 
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
>  at
> 
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:640)
>  at
> 
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:644)
>  at
> 
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
>  at
> 
> org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:731)
>  at
> 
> org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:179)
>  at org.geotools.referencing.CRS.decode(CRS.java:520)
>  at org.geotools.referencing.CRS.decode(CRS.java:448)
>  at
> 
> org.geoserver.config.util.XStreamPersister$SRSConverter.fromString(XStreamPersister.java:1217)
>  at
> 
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.fromString(SingleValueConverterWrapper.java:41)
>  at
> 
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.unmarshal(SingleValueConverterWrapper.java:49)
>  at
> 
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
>  at
> 
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
>  at
> 
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.java:474)
>  at
> 
> com.thoughtworks.xstream.converters.reflection.A

Re: [Geoserver-devel] Caused by: org.hsqldb.HsqlException: connection exception: closed

2016-06-09 Thread Andrea Aime 
Ciao Stefan,
long time no see!

Hum... we haven't seen this issue pop up in a while... just to verify,
are you sure nothing wiped out the hsql db file from the file system?
It would be found in the java temp directory, under Geotools and then
some other dirs with the espg name and version (don't have a sample
handy right here, right now)

Cheers
Andrea


On Wed, Jun 8, 2016 at 1:09 PM, Stefan Tzeggai 
wrote:

> Hi everybody,
>
> I run Geoserver 2.8.3 on Oracle Java 1.8.0_91 on Ubuntu Server 14.04
>
> It happens every few days/weeks that Geoserver stops working correctly!
> The webinterface is still working, but creating layers with REST and
> requesting WMS failes.
>
> Redeploying just geoserver.war (by removing and reinserting it into
> /var/lib/tomcat7/webapps) makes everything work again.
>
> Below is the full stacktrace.
>
> I found these two links that might be related:
>
>
> http://stackoverflow.com/questions/11967361/executequery-in-multiple-threads-closes-hsqldb-database-connection
>
> https://sourceforge.net/p/geoserver/mailman/message/35051494/
>
> I observed this on a production system running for 17 days with more
> than 3000 layers created via REST. From the logfile I can see that once
> the problem occurs, all following WMS requests fail, also on layers
> created earlier.
>
> How can I help to solve this?
>
> Greetings from Bolsena
> Steve
>
>
> [GC pause (G1 Evacuation Pause) (young) 18G->10G(25G), 0.1781596 secs]
> 07 Jun 15:55:02 WARN [org.geoserver] - Error decode epsg code: EPSG:31467
> org.opengis.referencing.FactoryException: Database failure while
> creating a 'CoordinateReferenceSystem' object for code "EPSG:31467".
> at
>
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.databaseFailure(DirectEpsgFactory.java:3061)
> at
>
> org.geotools.referencing.factory.epsg.DirectEpsgFactory.createCoordinateReferenceSystem(DirectEpsgFactory.java:2099)
> at
>
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
> at
>
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
> at
>
> org.geotools.referencing.factory.BufferedAuthorityFactory.createCoordinateReferenceSystem(BufferedAuthorityFactory.java:783)
> at
>
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
> at
>
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:640)
> at
>
> org.geotools.referencing.factory.FallbackAuthorityFactory.createCoordinateReferenceSystem(FallbackAuthorityFactory.java:644)
> at
>
> org.geotools.referencing.factory.AuthorityFactoryAdapter.createCoordinateReferenceSystem(AuthorityFactoryAdapter.java:801)
> at
>
> org.geotools.referencing.factory.ThreadedAuthorityFactory.createCoordinateReferenceSystem(ThreadedAuthorityFactory.java:731)
> at
>
> org.geotools.referencing.DefaultAuthorityFactory.createCoordinateReferenceSystem(DefaultAuthorityFactory.java:179)
> at org.geotools.referencing.CRS.decode(CRS.java:520)
> at org.geotools.referencing.CRS.decode(CRS.java:448)
> at
>
> org.geoserver.config.util.XStreamPersister$SRSConverter.fromString(XStreamPersister.java:1217)
> at
>
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.fromString(SingleValueConverterWrapper.java:41)
> at
>
> com.thoughtworks.xstream.converters.SingleValueConverterWrapper.unmarshal(SingleValueConverterWrapper.java:49)
> at
>
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
> at
>
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
> at
>
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.java:474)
> at
>
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.java:406)
> at
>
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshal(AbstractReflectionConverter.java:257)
> at
>
> com.thoughtworks.xstream.core.TreeUnmarshaller.convert(TreeUnmarshaller.java:72)
> at
>
> com.thoughtworks.xstream.core.TreeUnmarshaller.convertAnother(TreeUnmarshaller.java:66)
> at
>
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.unmarshallField(AbstractReflectionConverter.java:474)
> at
>
> com.thoughtworks.xstream.converters.reflection.AbstractReflectionConverter.doUnmarshal(AbstractReflectionConverter.java:406)
> at
>
> org.geoserver.config.util.XStreamPersister$ResourceInfoConverter.doUnmarshal(XStreamPersister.java:1725)
> at
>
> com.thoughtworks.xstream.converters.reflection.AbstractReflect