[Geoserver-users] Can't get ImageMosaic JDBC extension working for PostGIS Raster data source

Stephen_Brooke · July 17, 2014, 11:01pm

Ok, I figured out my own problem for those interested in what was wrong.

My “mosaic” table “name” column needed to be populated with the coverage name which in my case is “browse”, not “raster_data”. This fixed the “no level available for browse” error.
The next error was “com.vividsolutions.jts.io.ParseException: Unknown WKB type 48” and after a bit of googling I found out that GeoServer has an old postgresql driver (8.4) in WEB-INF/lib so I upgraded this to version 9.3 and the error went away.

After making these adjustments I was able to create an Image Mosaic JDBC store from PostGIS Raster format, publish a layer using the store, and view in the OpenLayers layer preview in GeoServer.

For the record I am using:

GeoServer 2.5.1

Postgresql 9.3

PostGIS 2.1.3

ImageMosaicJDBC plugin 11.x

–Steve

···

From: Stephen Brooke
Sent: Thursday, July 17, 2014 2:17 PM
To: ‘geoserver-users@lists.sourceforge.net’
Subject: Can’t get ImageMosaic JDBC extension working for PostGIS Raster data source

I’ve loaded some raster data into PostGIS using the raster2pgsql utility and I can view my raster data from Postgresql/PostGIS via the DBManager plugin for QGIS.

The raster2pgsql command I used is:

raster2pgsql -r *.tif -d -s 4326 -t 256x256 -l 2,3,4,5,6,7,8,9,10,11,12,13 -C -I -F -M raster_data | psql -U geocenter --host=localhost --port=5433

However, when I try to create an “ImageMosaicJDBC” store in GeoServer using the “Image mosaicking/pyramidal jdbc plugin” I get the below stacktrace in the GeoServer log. I have searched for examples of other people having this problem and there don’t appear to be any solutions documented.

Here is my mapping XML file for the Image Mosaic JDBC plugin and I followed the tutorial recommended in the GeoServer docs:

http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

The name of my coverage is “browse” as is referenced in the stacktrace.

My “mosaic” table in Postgresql was constructed and populated as follows:

CREATE TABLE public.mosaic

(

name character varying(254) NOT NULL,

tile_table character varying(254) NOT NULL,

minx double precision,

miny double precision,

maxx double precision,

maxy double precision,

resx double precision,

resy double precision,

CONSTRAINT mosaic_pkey PRIMARY KEY (name, tile_table)

)

insert into mosaic(name,tile_table) values (‘raster_data’,‘raster_data’);

insert into mosaic(name,tile_table) values (‘o_2_raster_data’,‘o_2_raster_data’);

insert into mosaic(name,tile_table) values (‘o_3_raster_data’,‘o_3_raster_data’);

insert into mosaic(name,tile_table) values (‘o_4_raster_data’,‘o_4_raster_data’);

insert into mosaic(name,tile_table) values (‘o_5_raster_data’,‘o_5_raster_data’);

insert into mosaic(name,tile_table) values (‘o_6_raster_data’,‘o_6_raster_data’);

insert into mosaic(name,tile_table) values (‘o_7_raster_data’,‘o_7_raster_data’);

insert into mosaic(name,tile_table) values (‘o_8_raster_data’,‘o_8_raster_data’);

insert into mosaic(name,tile_table) values (‘o_9_raster_data’,‘o_9_raster_data’);

insert into mosaic(name,tile_table) values (‘o_10_raster_data’,‘o_10_raster_data’);

insert into mosaic(name,tile_table) values (‘o_11_raster_data’,‘o_11_raster_data’);

insert into mosaic(name,tile_table) values (‘o_12_raster_data’,‘o_12_raster_data’);

insert into mosaic(name,tile_table) values (‘o_13_raster_data’,‘o_13_raster_data’);

GeoServer stacktrace:

17 Jul 13:45:27 ERROR [jdbc.custom] - No level available for browse

17 Jul 13:45:27 ERROR [imagemosaic.jdbc] - No level available for browse

17 Jul 13:45:27 WARN [imagemosaic.jdbc] - java.io.IOException: No level available for browse

java.io.IOException: java.io.IOException: No level available for browse

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.(ImageMosaicJDBCReader.java:164)

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:210)

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:67)

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

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

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

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

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

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

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

at org.geoserver.web.wicket.GeoServerDataProvider.fullSize(GeoServerDataProvider.java:236)

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

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

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

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

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

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

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

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

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

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

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

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

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

at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119)

at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92)

at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250)

at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329)

at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436)

at org.apache.wicket.RequestCycle.request(RequestCycle.java:545)

at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484)

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

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

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

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

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

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

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

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

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

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

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

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

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

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

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

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

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)

at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)

at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)

at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)

at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)

at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)

at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

at org.mortbay.jetty.Server.handle(Server.java:324)

at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)

at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)

at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)

at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)

at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)

at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)

at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)

Caused by: java.io.IOException: No level available for browse

at org.geotools.gce.imagemosaic.jdbc.custom.JDBCAccessPGRaster.initialize(JDBCAccessPGRaster.java:147)

at org.geotools.gce.imagemosaic.jdbc.JDBCAccessFactory.getJDBCAcess(JDBCAccessFactory.java:91)

at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.(ImageMosaicJDBCReader.java:161)

… 118 more

17 Jul 13:45:27 INFO [geoserver.web] - Getting list of coverages for saved store file:coverages/browse.pgraster.xml

java.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/browse.pgraster.xml and hints null

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