Ciao Stephen, I might be wrong but this seems a problem with Postgresql: 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
Regards, Simone Giannecchini == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Simone Giannecchini @simogeo Founder/Director GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 333 8128928 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- On Wed, Sep 25, 2013 at 5:33 PM, Stephen Crawford <[email protected]> wrote: > ...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 >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- > Stephen Crawford > Center for Environmental Informatics > The Pennsylvania State University > [email protected] > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
