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] > <mailto:[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] > <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 > > <http://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 > > <http://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] > <mailto:[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] > <mailto:[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
