True, but the MVT code should work even in that case, and return either a 404 (if the client can detect the valid range somehow) or return an empty vector tile (the way I see it at least).
Cheers Andrea On Wed, May 22, 2019 at 4:01 PM Ian Turton <[email protected]> wrote: > 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 > _______________________________________________ > 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
