...and that is postgres 8.4 to 9.3... On 9/25/2013 12:29 PM, Stephen Crawford wrote: > All, > > I just recently upgraded my postgres from 9.4 to 9.3 and postgis from > 2.0 to 2.1. This morning I tried upgrading my Geoserver from 2.1 to > 2.4. I am on Linux, Tomcat 6 using the .war, with a remote geo_data > directory. All my coverages seemed to load OK, but when trying to load > features from postgis DBs I get errors....also the layer preview page > will not load. Logs below. > > Thanks, > Steve > > java.io.IOException: Error occurred building feature type > at > org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:348) > at > org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:792) > at > org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:387) > at > org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:352) > at > org.geotools.data.store.ContentDataStore.getSchema(ContentDataStore.java:336) > at > org.geotools.data.store.ContentDataStore.getSchema(ContentDataStore.java:678) > at > org.geotools.data.store.ContentDataStore.getSchema(ContentDataStore.java:104) > at > org.geoserver.catalog.ResourcePool.getFeatureType(ResourcePool.java:858) > at > org.geoserver.catalog.ResourcePool.getFeatureType(ResourcePool.java:814) > at > org.geoserver.catalog.ResourcePool.loadAttributes(ResourcePool.java:691) > at > org.geoserver.catalog.ResourcePool.getAttributes(ResourcePool.java:667) > at > org.geoserver.web.data.resource.FeatureResourceConfigurationPanel$AttributeListModel.load(FeatureResourceConfigurationPanel.java:171) > at > org.geoserver.web.data.resource.FeatureResourceConfigurationPanel$AttributeListModel.load(FeatureResourceConfigurationPanel.java:163) > at > org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:120) > at > org.apache.wicket.Component.getDefaultModelObject(Component.java:1720) > at > org.apache.wicket.markup.html.list.ListView.getViewSize(ListView.java:220) > at > org.apache.wicket.markup.html.list.ListView.onPopulate(ListView.java:511) > at > org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:131) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:151) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.extensions.markup.html.tabs.TabbedPanel.onBeforeRender(TabbedPanel.java:244) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at > org.apache.wicket.markup.html.form.Form.onBeforeRender(Form.java:2056) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1753) > at org.apache.wicket.Component.onBeforeRender(Component.java:3946) > at org.apache.wicket.Page.onBeforeRender(Page.java:1531) > at > org.apache.wicket.Component.internalBeforeRender(Component.java:1071) > at org.apache.wicket.Component.beforeRender(Component.java:1105) > at > org.apache.wicket.Component.prepareForRender(Component.java:2292) > at org.apache.wicket.Page.prepareForRender(Page.java:1521) > at > org.apache.wicket.Component.prepareForRender(Component.java:2329) > at org.apache.wicket.Page.renderPage(Page.java:892) > at > org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.respond(BookmarkablePageRequestTarget.java:261) > at > org.apache.wicket.request.AbstractRequestCycleProcessor.respond(AbstractRequestCycleProcessor.java:105) > at > org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1258) > 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.doGet(WicketServlet.java:138) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > 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.doGet(FrameworkServlet.java:778) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:27) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74) > at > org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > 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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:75) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > 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:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:47) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:43) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > at java.lang.Thread.run(Thread.java:662) > Caused by: org.postgresql.util.PSQLException: ERROR: could not load > library "/usr/pgsql-9.3/lib/postgis-2.1.so": > /usr/pgsql-9.3/lib/postgis-2.1.so: undefined symbol: pj_get_spheroid_defn > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252) > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at > org.geotools.data.postgis.PostGISDialect.lookupGeometryType(PostGISDialect.java:387) > at > org.geotools.data.postgis.PostGISDialect.getMapping(PostGISDialect.java:345) > at > org.geotools.jdbc.JDBCFeatureSource.getColumnMetadata(JDBCFeatureSource.java:720) > at > org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:204) > ... 152 more > > > > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users
-- Stephen Crawford Center for Environmental Informatics The Pennsylvania State University src...@psu.edu 814.865.9905 ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users