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
