Christoph,
Are you using JNDI or just directly setting your database settings in the
datastore.properties file? I ask this because I was seeing what looked
like a connection starvation / connection leak issue harvesting image
mosaic granules without using JNDI. Your "too many clients already" error
makes me wonder if you are seeing a similar issue.
- Mike
On Tue, Apr 28, 2015 at 6:59 AM, Christoph Kleih <[email protected]> wrote:
> Dear all,
>
> I am running geoserver 2.7.0 on a Ubuntu 14.04.
>
> I am using the REST interface to append images to a mosaic time series.
> That works fine. But some things happen in the logfiles which I cannot
> explain.
>
> May be you can give me an advice, what I can improve, to solve some of the
> below mentioned log messages.
>
> Here are the excerpts from the logfiles:
>
> postgres logfile:
> 2015-04-28 12:28:56 CEST ERROR: stats for "my_layer.the_geom" do not exist
> 2015-04-28 12:28:56 CEST CONTEXT: SQL function "st_estimated_extent"
> statement 2
> 2015-04-28 12:28:56 CEST STATEMENT: select
> ST_AsText(ST_force_2d(ST_Envelope(ST_Estimated_Extent('public', 'my_layer',
> 'the_geom'))))
>
> geoserver logfile:
> 2015-04-28 10:29:48,857 WARN [geotools.jdbc] - Failed to use
> ST_Estimated_Extent, falling back on envelope aggregation
> org.postgresql.util.PSQLException: ERROR: stats for "my_layer.the_geom" do
> not exist
> Wobei: SQL function "st_estimated_extent" statement 2
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>
> description=Features from JDBCDataStore
> 2015-04-28 10:33:52,648 WARN [imagemosaic.catalog] - This granule catalog
> was not properly dispose as it still points to: ServiceInfo
> description=Features from JDBCDataStore
>
> Is that connected with this:
> http://docs.geoserver.org/stable/en/user/data/database/primarykey.html
>
> After many ingestions, I also get this message in the postgres log:
> 2015-04-27 18:48:04 CEST FATAL: sorry, too many clients already
>
> Thank you for any suggestions.
>
> Christoph
>
>
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
