[Geoserver-users] Image Mosaic failing to create reader again

GeoServer GeoServer User
1

Hi,

I’m struggling with the same image mosaic error I had a while ago but in a different context.

I’m trying to create an image mosaic using a local PostGIS database (running on localhost to the GeoServer) but I’m getting:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com FORCE_AXIS_ORDER_HONORING = http STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null

The store I’m using to connect appears to work and I’ve even managed to create the whole database using the GeoServer; all looks fine. However when I go to create an image mosaic I get the error above and no table is created within the schema.

My question is simple enough, does anyone know if the error is really caused by issues connecting to the database or could it actually be caused by issues with the location of the image directory?

The system was working but I was trying to rebuild it from scratch on a later version of Windows Server (2016 I think) and the data directory is now on a network drive. Despite the number of times I’ve looked at this error message I still find it confusing to identify what the GeoServer is actually trying to do, is it trying to read the files, write to the database, create a table or index?

Alternatively are there preparedStatements missing on my version of PostGIS or something like that?

As usual I would be really grateful for any hints but of course I know everyone is very busy.

Best Regards,

Paul Wittle

GIS Developer

County Hall

Dorchester

Dorset. DT1 1XJ

Tel: 01305 228473

E mail: p.wittle@anonymised.com

2

Hi Paul,
do you have any chance to share the GeoServer logs right after you get that exception?
You may also consider raising the logging level to GEOTOOLS_DEVELOPER in case you don’t see anything special.

Please, let us know.
Regards,
Daniele

···

On Tue, May 29, 2018 at 11:39 AM, Paul Wittle via Geoserver-users <geoserver-users@lists.sourceforge.net> wrote:

Hi,

I’m struggling with the same image mosaic error I had a while ago but in a different context.

I’m trying to create an image mosaic using a local PostGIS database (running on localhost to the GeoServer) but I’m getting:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com.. System defaults: LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@3f4e036a FORCE_AXIS_ORDER_HONORING = http STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null

The store I’m using to connect appears to work and I’ve even managed to create the whole database using the GeoServer; all looks fine. However when I go to create an image mosaic I get the error above and no table is created within the schema.

My question is simple enough, does anyone know if the error is really caused by issues connecting to the database or could it actually be caused by issues with the location of the image directory?

The system was working but I was trying to rebuild it from scratch on a later version of Windows Server (2016 I think) and the data directory is now on a network drive. Despite the number of times I’ve looked at this error message I still find it confusing to identify what the GeoServer is actually trying to do, is it trying to read the files, write to the database, create a table or index?

Alternatively are there preparedStatements missing on my version of PostGIS or something like that?

As usual I would be really grateful for any hints but of course I know everyone is very busy.

Best Regards,

Paul Wittle

GIS Developer

County Hall

Dorchester

Dorset. DT1 1XJ

Tel: 01305 228473

E mail: p.wittle@anonymised.com

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Geoserver-users@anonymised.com.382…sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

Regards,
Daniele Romagnoli

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Ing. Daniele Romagnoli
Senior Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

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.

3

Hi Daniele,

Here is a full log:

2018-05-29 15:25:37,946 WARN [class org.geotools.gce.imagemosaic.Utils] - Unable to find sample image for path \hvgidevfs1\data_dir\Raster\Test2\sample_image

2018-05-29 15:25:37,949 WARN [org.geotools.gce.imagemosaic] - Unable to find sample image for path file:////hvgidevfs1/data_dir/Raster/Test2/datastore.properties

2018-05-29 15:25:37,951 DEBUG [org.geotools.jdbc] - CREATE CONNECTION

2018-05-29 15:25:37,954 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION

2018-05-29 15:25:37,955 INFO [org.geoserver.web] - Getting list of coverages for saved store file:Raster/Test2

java.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints:

REPOSITORY = org.geoserver.catalog.CatalogRepository@…8875…

EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@…8876…[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]

System defaults:

FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@…8877…

LENIENT_DATUM_SHIFT = true

FILTER_FACTORY = FilterFactoryImpl

FORCE_LONGITUDE_FIRST_AXIS_ORDER = true

FORCE_AXIS_ORDER_HONORING = http

GRID_COVERAGE_FACTORY = GridCoverageFactory

TILE_ENCODING = null

COMPARISON_TOLERANCE = 1.0E-8

STYLE_FACTORY = StyleFactoryImpl

at org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:174)

at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:61)

at org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:216)

at org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:189)

at org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:234)

at org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.updateMatched(GeoServerTablePanel.java:617)

at org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.(GeoServerTablePanel.java:610)

at org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:178)

at org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:99)

at org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:110)

at org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:110)

at org.geoserver.web.data.store.CoverageStoreNewPage.onSuccessfulSave(CoverageStoreNewPage.java:86)

at org.geoserver.web.data.store.CoverageStoreNewPage.onSave(CoverageStoreNewPage.java:74)

at org.geoserver.web.data.store.AbstractCoverageStorePage$1.onSubmit(AbstractCoverageStorePage.java:122)

at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:111)

at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215)

at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1309)

at org.apache.wicket.markup.html.form.Form.process(Form.java:976)

at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:797)

at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:171)

at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:155)

at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:601)

at sun.reflect.GeneratedMethodAccessor462.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258)

at org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241)

at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:248)

at org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:234)

at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:895)

at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64)

at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:265)

at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:222)

at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:293)

at org.apache.wicket.protocol.http.WicketFilter.processRequestCycle(WicketFilter.java:261)

at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:203)

at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:159)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:157)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:174)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.filters.CorsFilter.handleSimpleCORS(CorsFilter.java:302)

at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:170)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:28)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:75)

at org.geoserver.wms.animate.AnimatorFilter.doFilter(AnimatorFilter.java:71)

at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)

at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:231)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)

at org.geoserver.monitor.MonitorFilter.doFilter(MonitorFilter.java:85)

at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)

at org.geoserver.flow.controller.IpBlacklistFilter.doFilter(IpBlacklistFilter.java:94)

at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:71)

at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:46)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:50)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)

at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)

at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:54)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)

at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)

at org.geoserver.security.filter.GeoServerUserNamePasswordAuthenticationFilter.doFilter(GeoServerUserNamePasswordAuthenticationFilter.java:116)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)

at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:157)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)

at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:69)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)

at org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:53)

at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:73)

at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:92)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)

at org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:152)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:88)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.XFrameOptionsFilter.doFilter(XFrameOptionsFilter.java:89)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:48)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:44)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)

at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:673)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:146)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:279)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: java.io.IOException: Failed to create reader from file:Raster/Test2 and hints Hints:

REPOSITORY = org.geoserver.catalog.CatalogRepository@…8875…

EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@…8876…[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]

System defaults:

FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@…8877…

LENIENT_DATUM_SHIFT = true

FILTER_FACTORY = FilterFactoryImpl

FORCE_LONGITUDE_FIRST_AXIS_ORDER = true

FORCE_AXIS_ORDER_HONORING = http

GRID_COVERAGE_FACTORY = GridCoverageFactory

TILE_ENCODING = null

COMPARISON_TOLERANCE = 1.0E-8

STYLE_FACTORY = StyleFactoryImpl

at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1508)

at org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1452)

at org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:59)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:147)

at com.sun.proxy.$Proxy32.getGridCoverageReader(Unknown Source)

at org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:95)

… 150 more

2018-05-29 15:25:45,974 WARN [org.geotools.gce.imagemosaic.catalog] - This granule catalog was not properly dispose as it still points to:ServiceInfo

description=Features from JDBCDataStore

2018-05-29 15:25:45,985 WARN [org.geotools.gce.imagemosaic.catalog] - This granule catalog was not properly dispose as it still points to:ServiceInfo

description=Features from JDBCDataStore

2018-05-29 15:25:46,009 WARN [org.geotools.gce.imagemosaic.catalog] - This granule catalog was not properly dispose as it still points to:ServiceInfo

description=Features from JDBCDataStore

Cheers,

Paul

···

Hi Paul,

do you have any chance to share the GeoServer logs right after you get that exception?

You may also consider raising the logging level to GEOTOOLS_DEVELOPER in case you don’t see anything special.

Please, let us know.

Regards,

Daniele

On Tue, May 29, 2018 at 11:39 AM, Paul Wittle via Geoserver-users <geoserver-users@lists.sourceforge.net> wrote:

Hi,

I’m struggling with the same image mosaic error I had a while ago but in a different context.

I’m trying to create an image mosaic using a local PostGIS database (running on localhost to the GeoServer) but I’m getting:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints: EXECUTOR_SERVICE = [java.util.concurrent.ThreadPoolExecutor@…8868…Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@…8869… System defaults: LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@…8870… FORCE_AXIS_ORDER_HONORING = http STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null

The store I’m using to connect appears to work and I’ve even managed to create the whole database using the GeoServer; all looks fine. However when I go to create an image mosaic I get the error above and no table is created within the schema.

My question is simple enough, does anyone know if the error is really caused by issues connecting to the database or could it actually be caused by issues with the location of the image directory?

The system was working but I was trying to rebuild it from scratch on a later version of Windows Server (2016 I think) and the data directory is now on a network drive. Despite the number of times I’ve looked at this error message I still find it confusing to identify what the GeoServer is actually trying to do, is it trying to read the files, write to the database, create a table or index?

Alternatively are there preparedStatements missing on my version of PostGIS or something like that?

As usual I would be really grateful for any hints but of course I know everyone is very busy.

Best Regards,

Paul Wittle

GIS Developer

County Hall

Dorchester

Dorset. DT1 1XJ

Tel: 01305 228473

E mail: p.wittle@…7193…

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

Regards,

Daniele Romagnoli

==

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

==

Ing. Daniele Romagnoli

Senior Software Engineer

GeoSolutions S.A.S.

Via di Montramito 3/A

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

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.

4

Hi Paul,
rasters failing to load do not report any error to GeoServer, just a null. This is a 10+ years old design mistake that’s expensive to fix today (idea, add a flag to make them throw an exception, retrofit each and every one of them to do so).

As Daniele suggested, currently the way is to switch to gt Dev logging and hunt into the many messages (some of which are red herrings).

The mosaic is especially hard because during init it creates tables, config files and the like, won’t revert them on failure, and won’t proceed further in the next setup if it finds them… So you have to know what to look for and delete manually.

I hope one day we can setup a code Sprint with a few devs, for a few days, to actually start returning meaningful info out if failures.

Cheers
Andrea

Il mar 29 mag 2018, 14:21 Paul Wittle via Geoserver-users <geoserver-users@anonymised.comrge.net> ha scritto:

Hi,

I’m struggling with the same image mosaic error I had a while ago but in a different context.

I’m trying to create an image mosaic using a local PostGIS database (running on localhost to the GeoServer) but I’m getting:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints: EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com[Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@anonymised.com System defaults: LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com FORCE_AXIS_ORDER_HONORING = http STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null

The store I’m using to connect appears to work and I’ve even managed to create the whole database using the GeoServer; all looks fine. However when I go to create an image mosaic I get the error above and no table is created within the schema.

My question is simple enough, does anyone know if the error is really caused by issues connecting to the database or could it actually be caused by issues with the location of the image directory?

The system was working but I was trying to rebuild it from scratch on a later version of Windows Server (2016 I think) and the data directory is now on a network drive. Despite the number of times I’ve looked at this error message I still find it confusing to identify what the GeoServer is actually trying to do, is it trying to read the files, write to the database, create a table or index?

Alternatively are there preparedStatements missing on my version of PostGIS or something like that?

As usual I would be really grateful for any hints but of course I know everyone is very busy.

Best Regards,

Paul Wittle

GIS Developer

County Hall

Dorchester

Dorset. DT1 1XJ

Tel: 01305 228473

E mail: p.wittle@anonymised.com

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

5

Hi Andrea,

Thanks for the reply, is there a good place for me to start looking i.e. a part of the source code which defines the process of setting up the table etc?

I don’t know why but I still can’t quite get my head round where the source code for plugins is actually stored?

I’m still no help at all when it comes to development work as I still keep meaning to come along to an event or code sprint of some sort to get my head around the processes. Sorry about that, the kids are still very young and so there is very little time outside of work to learn new scripting languages.

Cheers,

Paul

···

Hi Paul,

rasters failing to load do not report any error to GeoServer, just a null. This is a 10+ years old design mistake that’s expensive to fix today (idea, add a flag to make them throw an exception, retrofit each and every one of them to do so).

As Daniele suggested, currently the way is to switch to gt Dev logging and hunt into the many messages (some of which are red herrings).

The mosaic is especially hard because during init it creates tables, config files and the like, won’t revert them on failure, and won’t proceed further in the next setup if it finds them… So you have to know what to look for and delete manually.

I hope one day we can setup a code Sprint with a few devs, for a few days, to actually start returning meaningful info out if failures.

Cheers

Andrea

Il mar 29 mag 2018, 14:21 Paul Wittle via Geoserver-users <geoserver-users@lists.sourceforge.net> ha scritto:

Hi,

I’m struggling with the same image mosaic error I had a while ago but in a different context.

I’m trying to create an image mosaic using a local PostGIS database (running on localhost to the GeoServer) but I’m getting:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints: EXECUTOR_SERVICE = [java.util.concurrent.ThreadPoolExecutor@…8868…Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@…8869… System defaults: LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@…8870… FORCE_AXIS_ORDER_HONORING = http STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null

The store I’m using to connect appears to work and I’ve even managed to create the whole database using the GeoServer; all looks fine. However when I go to create an image mosaic I get the error above and no table is created within the schema.

My question is simple enough, does anyone know if the error is really caused by issues connecting to the database or could it actually be caused by issues with the location of the image directory?

The system was working but I was trying to rebuild it from scratch on a later version of Windows Server (2016 I think) and the data directory is now on a network drive. Despite the number of times I’ve looked at this error message I still find it confusing to identify what the GeoServer is actually trying to do, is it trying to read the files, write to the database, create a table or index?

Alternatively are there preparedStatements missing on my version of PostGIS or something like that?

As usual I would be really grateful for any hints but of course I know everyone is very busy.

Best Regards,

Paul Wittle

GIS Developer

County Hall

Dorchester

Dorset. DT1 1XJ

Tel: 01305 228473

E mail: p.wittle@…7193…

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

6

Hi,

I think it might have been more to do with the database tables again as I was trying to use a custom schema rather than public.

I’ve now reconfigured my store to use the public schema and renamed my stores / tables to be lower case names. This means the error has gone away but I still have not been able to get GeoServer to create and populate a new layer.

On the plus side, my layers are now working again now but I’m unsure if that is from the GWC or the GeoServer really; I think it is working though.

I’m still a little confused as to whether it tries to generate a schema per layer or a table but that might just be due to the wording of an error message.

Thanks,

Paul

···

From: Paul Wittle
Sent: 30 May 2018 09:56
To: ‘Andrea Aime’ <andrea.aime@…1107…>
Cc: ‘GeoServer Mailing List List’ geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] Image Mosaic failing to create reader again

Hi Andrea,

Thanks for the reply, is there a good place for me to start looking i.e. a part of the source code which defines the process of setting up the table etc?

I don’t know why but I still can’t quite get my head round where the source code for plugins is actually stored?

I’m still no help at all when it comes to development work as I still keep meaning to come along to an event or code sprint of some sort to get my head around the processes. Sorry about that, the kids are still very young and so there is very little time outside of work to learn new scripting languages.

Cheers,

Paul

From: Andrea Aime [mailto:andrea.aime@…1107…]
Sent: 29 May 2018 16:09
To: Paul Wittle <P.Wittle@…7193…>
Cc: GeoServer Mailing List List <geoserver-users@lists.sourceforge.net>
Subject: Re: [Geoserver-users] Image Mosaic failing to create reader again

Hi Paul,

rasters failing to load do not report any error to GeoServer, just a null. This is a 10+ years old design mistake that’s expensive to fix today (idea, add a flag to make them throw an exception, retrofit each and every one of them to do so).

As Daniele suggested, currently the way is to switch to gt Dev logging and hunt into the many messages (some of which are red herrings).

The mosaic is especially hard because during init it creates tables, config files and the like, won’t revert them on failure, and won’t proceed further in the next setup if it finds them… So you have to know what to look for and delete manually.

I hope one day we can setup a code Sprint with a few devs, for a few days, to actually start returning meaningful info out if failures.

Cheers

Andrea

Il mar 29 mag 2018, 14:21 Paul Wittle via Geoserver-users <geoserver-users@lists.sourceforge.net> ha scritto:

Hi,

I’m struggling with the same image mosaic error I had a while ago but in a different context.

I’m trying to create an image mosaic using a local PostGIS database (running on localhost to the GeoServer) but I’m getting:

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:Raster/Test2 and hints Hints: EXECUTOR_SERVICE = [java.util.concurrent.ThreadPoolExecutor@…8868…Running, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY = org.geoserver.catalog.CatalogRepository@…8869… System defaults: LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl FEATURE_FACTORY = org.geotools.feature.LenientFeatureFactoryImpl@…8870… FORCE_AXIS_ORDER_HONORING = http STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory TILE_ENCODING = null

The store I’m using to connect appears to work and I’ve even managed to create the whole database using the GeoServer; all looks fine. However when I go to create an image mosaic I get the error above and no table is created within the schema.

My question is simple enough, does anyone know if the error is really caused by issues connecting to the database or could it actually be caused by issues with the location of the image directory?

The system was working but I was trying to rebuild it from scratch on a later version of Windows Server (2016 I think) and the data directory is now on a network drive. Despite the number of times I’ve looked at this error message I still find it confusing to identify what the GeoServer is actually trying to do, is it trying to read the files, write to the database, create a table or index?

Alternatively are there preparedStatements missing on my version of PostGIS or something like that?

As usual I would be really grateful for any hints but of course I know everyone is very busy.

Best Regards,

Paul Wittle

GIS Developer

County Hall

Dorchester

Dorset. DT1 1XJ

Tel: 01305 228473

E mail: p.wittle@…7193…

“This e-mail is intended for the named addressee(s) only and may contain information about individuals or other sensitive information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this email in error, kindly disregard the content of the message and notify the sender immediately. Please be aware that all email may be subject to recording and/or monitoring in accordance with relevant legislation.”

Check out the vibrant tech community on one of the world’s most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users