Hi, I suggest to open a ticket at https://osgeo-org.atlassian.net/projects/GEOS/summary with a set of data and styles, and a request, that shows how to reproduce the issue. The simplest the example, the better
Cheers Andrea On Wed, May 22, 2019 at 4:10 PM Johannes Weskamm <[email protected]> wrote: > This is not a solution, as the client rendering the tiles does not know > what scaledenominators are set in the sld. > > The behaviour should be to not serve any features in the tiles for that > specific layer, but not responding with an code 400. > > As i am using a grouplayer, there is in fact a demand to render features > in that scalerange that are coming from other layers, that have a valid > salerange for that request. > > > Greetings, > > Johannes > Am 22.05.19 um 15:53 schrieb Ian Turton: > > The solution is to not request tiles outside the specified range. > > Ian > > On Wed, 22 May 2019 at 14:06, Johannes Weskamm <[email protected]> > wrote: > >> Hi, >> >> >> Thanks, but the problem is, i do not generate that query by myself, its >> seems to be the code (GeoServer / GeoWebCache / MVT Vectortiles >> Extension). >> >> The layer is published as simple table from the database (also checked >> if using an sql view differs, but its the same problem). >> >> So the question is, where does this query come from? >> >> It seems to be related to not matching any scaledenominators in the SLD >> somehow... >> >> >> >> Am 22.05.19 um 14:40 schrieb DEGRÈVE Benoît: >> > Johannes, >> > >> > There's indeed a syntax problem in your SQL just between the 1st >> SELECT and the 1st FROM : SQL expect a list of fields , or a " * "....You >> must select something... >> > >> > SELECT FROM (SELECT * FROM osm_waterareas >> > ) as "vtable" WHERE 0 = 1 >> > >> > Benoît DEGRÈVE >> > Risques sous-sols et cartographie >> > Bachelier en gestion de données et cartographie >> > >> > >> > -----Message d'origine----- >> > De : Johannes Weskamm [mailto:[email protected]] >> > Envoyé : mercredi 22 mai 2019 10:29 >> > À : GeoServer Users >> > Objet : [Geoserver-users] Request for mvt vectortiles leads to "Problem >> communicating with GeoServer" >> > >> > Hi all, >> > >> > >> > I have troubles getting Mapbox vectortiles from GeoServer in some >> > circumstances: >> > >> > I am using a grouplayer with several layers from a PostGIS DB (Postgres >> > 9.3 and PostGIS 2.1.2) in it. >> > >> > The layer themselves are working fine when previewed / used as WMS. >> > >> > But when i request the layer as vectortile, GeoWebCache answers >> > sometimes with "400: Problem communicating with GeoServer". >> > >> > I found out that the problem only occurs, when i use an SLD with Min and >> > MaxScaledenominator and when i request tiles outside that range. >> > >> > All tiles in that scalerange are delviered fine. >> > >> > The problem exists in three different GeoServer versions i have tested >> > (2.12.1, 2.14.3, 2.15.1). >> > >> > >> > The error that happens from GeoServer Log is at the end of this mail. >> > >> > The interesting part is, it think, "PSQLException: ERROR: syntax error >> > at or near "FROM" >> > >> > I had a look at the postgres log which gives a better idea: >> > >> > >> > 2019-05-22 10:26:48 CEST ERROR: syntax error at or near "FROM" at >> > character 8 >> > 2019-05-22 10:26:48 CEST STATEMENT: SELECT FROM (SELECT * FROM >> > osm_waterareas >> > ) as "vtable" WHERE 0 = 1 >> > >> > >> > This is indeed an invalid statement. Any ideas where this may come from? >> > >> > Thanks! >> > >> > >> > >> > >> http://136.243.46.241/geoserver/gwc/service/tms/1.0.0/osm:osm_vector@EPSG:3857@pbf/9/268/342.pbf >> > 2019-05-22 10:14:56,280 ERROR [geowebcache.GeoWebCacheDispatcher] - >> > Request failed >> > org.geowebcache.GeoWebCacheException: Problem communicating with >> GeoServer >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.getMetatilingReponse(GeoServerTileLayer.java:644) >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.getTile(GeoServerTileLayer.java:579) >> > at >> org.geowebcache.util.ResponseUtils.writeTile(ResponseUtils.java:102) >> > at >> > >> org.geowebcache.GeoWebCacheDispatcher.handleServiceRequest(GeoWebCacheDispatcher.java:422) >> > at >> > >> org.geowebcache.GeoWebCacheDispatcher.handleRequestInternal(GeoWebCacheDispatcher.java:275) >> > at >> > >> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177) >> > at >> > >> org.geoserver.gwc.dispatch.GwcServiceProxy.dispatch(GwcServiceProxy.java:82) >> > at sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source) >> > at >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> > at java.lang.reflect.Method.invoke(Method.java:498) >> > at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:877) >> > at >> > org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:264) >> > at >> > >> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177) >> > at >> > >> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:52) >> > at >> > >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) >> > at >> > >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) >> > at >> > >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) >> > at >> > >> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) >> > at >> > >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:26) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:69) >> > at >> > >> org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:73) >> > at >> > >> org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:66) >> > at >> > >> org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:41) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:37) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) >> > at >> > >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:51) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) >> > at >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:81) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) >> > at >> > >> org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:52) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) >> > at >> > >> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) >> > at >> > >> org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:142) >> > at >> > >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) >> > at >> > >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:90) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.XFrameOptionsFilter.doFilter(XFrameOptionsFilter.java:79) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:42) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) >> > at >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> > at >> > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> > at >> > >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) >> > at >> > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> > at >> > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) >> > at >> > >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> > at >> > >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> > at >> > >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) >> > at >> > >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) >> > at >> > >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) >> > at >> > org.apache.tomcat.util.net >> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313) >> > at >> > >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) >> > at >> > >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) >> > at java.lang.Thread.run(Thread.java:748) >> > Caused by: java.lang.IllegalStateException: Expected: RenderedImageMap, >> > got null >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.dispatchGetMap(GeoServerTileLayer.java:696) >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.getMetatilingReponse(GeoServerTileLayer.java:638) >> > ... 101 more >> > 2019-05-22 10:14:56,287 INFO [geoserver.wms] - >> > Request: getServiceInfo >> > 2019-05-22 10:14:56,300 ERROR [geoserver.ows] - >> > java.lang.RuntimeException: java.io.IOException >> > at >> > >> org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:165) >> > at >> > >> org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:52) >> > at >> > >> org.geoserver.wms.vector.VectorTileMapOutputFormat.run(VectorTileMapOutputFormat.java:196) >> > at >> > >> org.geoserver.wms.vector.VectorTileMapOutputFormat.produceMap(VectorTileMapOutputFormat.java:133) >> > at org.geoserver.wms.GetMap.executeInternal(GetMap.java:707) >> > at org.geoserver.wms.GetMap.run(GetMap.java:287) >> > at org.geoserver.wms.GetMap.run(GetMap.java:110) >> > at >> > >> org.geoserver.wms.DefaultWebMapService.getMap(DefaultWebMapService.java:251) >> > at sun.reflect.GeneratedMethodAccessor399.invoke(Unknown Source) >> > at >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> > at java.lang.reflect.Method.invoke(Method.java:498) >> > at >> > >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) >> > at >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) >> > at >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) >> > at >> > >> org.geoserver.kml.WebMapServiceKmlInterceptor.invoke(WebMapServiceKmlInterceptor.java:38) >> > at >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) >> > at >> > >> org.geoserver.gwc.wms.CacheSeedingWebMapService.invoke(CacheSeedingWebMapService.java:55) >> > at >> > >> org.geoserver.gwc.wms.CacheSeedingWebMapService.invoke(CacheSeedingWebMapService.java:31) >> > at >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) >> > at >> > >> org.geoserver.gwc.wms.CachingWebMapService.invoke(CachingWebMapService.java:72) >> > at >> > >> org.geoserver.gwc.wms.CachingWebMapService.invoke(CachingWebMapService.java:52) >> > at >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) >> > at >> > >> org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:50) >> > at >> > >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) >> > at >> > >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) >> > at com.sun.proxy.$Proxy101.getMap(Unknown Source) >> > at sun.reflect.GeneratedMethodAccessor299.invoke(Unknown Source) >> > at >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> > at java.lang.reflect.Method.invoke(Method.java:498) >> > at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:877) >> > at >> > org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:264) >> > at >> > >> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177) >> > at org.geoserver.gwc.GWC.dispatchOwsRequest(GWC.java:1376) >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.dispatchGetMap(GeoServerTileLayer.java:693) >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.getMetatilingReponse(GeoServerTileLayer.java:638) >> > at >> > >> org.geoserver.gwc.layer.GeoServerTileLayer.getTile(GeoServerTileLayer.java:579) >> > at >> org.geowebcache.util.ResponseUtils.writeTile(ResponseUtils.java:102) >> > at >> > >> org.geowebcache.GeoWebCacheDispatcher.handleServiceRequest(GeoWebCacheDispatcher.java:422) >> > at >> > >> org.geowebcache.GeoWebCacheDispatcher.handleRequestInternal(GeoWebCacheDispatcher.java:275) >> > at >> > >> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177) >> > at >> > >> org.geoserver.gwc.dispatch.GwcServiceProxy.dispatch(GwcServiceProxy.java:82) >> > at sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source) >> > at >> > >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> > at java.lang.reflect.Method.invoke(Method.java:498) >> > at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:877) >> > at >> > org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:264) >> > at >> > >> org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177) >> > at >> > >> org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:52) >> > at >> > >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) >> > at >> > >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) >> > at >> > >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998) >> > at >> > >> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:890) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) >> > at >> > >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875) >> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:26) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:69) >> > at >> > >> org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:73) >> > at >> > >> org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:66) >> > at >> > >> org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:41) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:37) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) >> > at >> > >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:51) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) >> > at >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.geoserver.security.filter.GeoServerBasicAuthenticationFilter.doFilter(GeoServerBasicAuthenticationFilter.java:81) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:70) >> > at >> > >> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) >> > at >> > >> org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:52) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:74) >> > at >> > >> org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91) >> > at >> > >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) >> > at >> > >> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) >> > at >> > >> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) >> > at >> > >> org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:142) >> > at >> > >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) >> > at >> > >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:90) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.XFrameOptionsFilter.doFilter(XFrameOptionsFilter.java:79) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:46) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:42) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) >> > at >> > >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> > at >> > >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> > at >> > >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> > at >> > >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> > at >> > >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) >> > at >> > >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) >> > at >> > >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) >> > at >> > >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> > at >> > >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> > at >> > >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) >> > at >> > >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) >> > at >> > >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) >> > at >> > org.apache.tomcat.util.net >> .JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313) >> > at >> > >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) >> > at >> > >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) >> > at java.lang.Thread.run(Thread.java:748) >> > Caused by: java.io.IOException >> > at >> > >> org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:625) >> > at >> > >> org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:609) >> > at >> > >> org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:163) >> > ... 135 more >> > Caused by: java.sql.SQLException: org.postgresql.util.PSQLException: >> > ERROR: syntax error at or near "FROM" >> > Position: 8 >> > at >> > org.geotools.jdbc.JDBCFeatureReader.runQuery(JDBCFeatureReader.java:257) >> > at >> > org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:142) >> > at >> > >> org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:595) >> > ... 137 more >> > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or >> > near "FROM" >> > Position: 8 >> > at >> > >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476) >> > at >> > >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189) >> > at >> > >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300) >> > at >> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428) >> > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354) >> > at >> > org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301) >> > at >> > org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287) >> > at >> > org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264) >> > at >> org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231) >> > at >> > >> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) >> > at >> > >> org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) >> > at >> > >> org.geotools.jdbc.JDBCFeatureReader.lambda$new$0(JDBCFeatureReader.java:142) >> > at >> > org.geotools.jdbc.JDBCFeatureReader.runQuery(JDBCFeatureReader.java:246) >> > ... 139 more >> > 2019-05-22 10:14:56,304 ERROR [geowebcache.GeoWebCacheDispatcher] - >> > Problem communicating with GeoServer >> > >> > >> > >> > >> > >> > _______________________________________________ >> > Geoserver-users mailing list >> > >> > Please make sure you read the following two resources before posting to >> this list: >> > - Earning your support instead of buying it, but Ian Turton: >> http://www.ianturton.com/talks/foss4g.html#/ >> > - The GeoServer user list posting guidelines: >> http://geoserver.org/comm/userlist-guidelines.html >> > >> > If you want to request a feature or an improvement, also see this: >> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer >> > >> > >> > [email protected] >> > https://lists.sourceforge.net/lists/listinfo/geoserver-users >> >> >> >> _______________________________________________ >> Geoserver-users mailing list >> >> Please make sure you read the following two resources before posting to >> this list: >> - Earning your support instead of buying it, but Ian Turton: >> http://www.ianturton.com/talks/foss4g.html#/ >> - The GeoServer user list posting guidelines: >> http://geoserver.org/comm/userlist-guidelines.html >> >> If you want to request a feature or an improvement, also see this: >> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer >> >> >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geoserver-users >> > > > -- > Ian Turton > > -- > Dipl.-Geogr. Johannes Weskamm > — Anwendungsentwickler — > > terrestris GmbH & Co. KG > Kölnstraße 99 > 53111 Bonn > > Tel: +49 (0)228 / 96 28 99 -555 > Fax: +49 (0)228 / 96 28 99 -57 > > Email: [email protected] > Web: https://www.terrestris.de > > Amtsgericht Bonn, HRA 6835 > Komplementärin: terrestris Verwaltungsgesellschaft mbH > vertreten durch: Torsten Brassat, Marc Jansen, > Hinrich Paulsen, Till Adams > > Informationen über Ihre gespeicherten Daten finden Sie auf > unserer Homepage unter folgendem Link: > https://www.terrestris.de/datenschutzerklaerung/ > > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- *Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.*
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
