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
