Hello,

The issue comes probably from the open connections to your database. 
If you have a standard postgres/postgis installation the number of simultanous 
connection has limits.
You can augment this limit but, if the flow introduces always new coverages 
then soon or later this will happen again.

The best solution is to work with a jndi datasource defined in your 
tomcat/jetty container and use this connection in
the geoserver definition.

Best regards,

Eric Smets

-- 
Eric Smets                                    [email protected] 
<mailto:[email protected]> 
FKS bvba - Formal and Knowledge Systems       http://www.fks.be 
<http://www.fks.be/> /
Schampbergstraat 32                           Tel:  ++32-(0)11-21 49 11
B-3511 Hasselt                                Fax:  ++32-(0)11-22 04 19

-----Oorspronkelijk bericht-----
Afzender: Sabine Ohlendorf <[email protected]>
Verstuurd: Maandag 1 Juni 2015 12:26
Aan: Geoserver Mailinglist <[email protected]>
Onderwerp: [Geoserver-users] Problems with REST on some coveragestores

Hi,
 I have a geoserver version 2.7.0 running on Ubuntu 14.4. and I am using the 
REST interface to create new coveragestores and layers or to add further data 
to an existing coveragestore. In general this is working quite good.
I have some python scripts sending the REST requests to the server, via python 
package 'requests'. But since a few days I have problems ingesting new data to 
some of my coveragestores. For other coveragestores everything is still working 
without problems. I am always using the same requests.
POST-Reqeust to the URL:
http://ipaddress/geoserver/rest/workspaces/my-workspace/coveragestores/my-coveragestore/file.imagemosaic
A zip file with one tif image is sent.
I also tried the corresponding request via curl:
curl -v -u username:password -XPOST -H "Content-type:application/zip" 
--data-binary @path-to-zip 
http://ipaddress/geoserver/rest/workspaces/my-workspace/coveragestores/my-coveragestore/file.imagemosaic
 The result is the same. The data is not included into the coveragestore. But I 
don't get any error message. The HTTP return code is '202 - Accepted' and the 
tif file is copied to the geoserver to the correct data directory of the 
coveragestore but it is not included into the coveragestore. We are using a 
database with the following database.properties file for the coveragestores:
# JNDI specific #
SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
jndiReferenceName=jdbc/postgres
Loose\ bbox=true
preparedStatements=false
 Looking through the log files of geoserver and postgresql I could not find any 
error message.
/var/lib/tomcat/geoserver_master/logs/catalina.out
/var/lib/tomcat/geoserver_master/logs/localhost_access_log.2015-06-01.txt
/var/log/postgresql/postgresql-9.3-main.log
Everything looks normal. But the image is not ingested to the coveragestore. 
The strange thing is that for some coveragestores it is still working and for 
others I have these problem which just occured from one day to the other.
Does anyone has an idea? Are the maybe some more logfiles I could check?
 Thanks.
Sabine

 

------------------------------------------------------------------------------




_______________________________________________

Geoserver-users mailing list

[email protected]

https://lists.sourceforge.net/lists/listinfo/geoserver-users



------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to