Dear Mike,
thank you for your response.
I am setting the database information in the datastore.properties file.
Does it make sense to switch to JNDI?
Can I still activate that?
Thank you,
Christoph
Am 29.04.2015 15:04, schrieb Mike Grogan:
> 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]
> <mailto:[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]
> <mailto:[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
