There's code using JDBC based datastore and not disposing them.
---------------------------------------------------------------
Key: GEOS-4349
URL: http://jira.codehaus.org/browse/GEOS-4349
Project: GeoServer
Issue Type: Bug
Components: PostGIS
Affects Versions: 2.1-RC1
Environment: windows although not sure it is relevant
Reporter: Charles Galpin
Assignee: Andrea Aime
I see these errors in my logs
ERROR [org.geotools.jdbc] - There's code using JDBC based datastore and not disposing them. This may lead to temporary loss of database connections. Please make sure all data access code calls DataStore.dispose() before freeing all references to it
I am not sure if it's related to these PSQLExceptions but have given a chunk of log from one of these exceptions down to the jdbc error. If I can provide more info please let me know what.
INFO | jvm 1 | 2011/02/01 14:58:05 | 01 Feb 14:58:05 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:58:05 | 01 Feb 14:58:05 WARN [org.geotools.jdbc] - Failed to use ST_Estimated_Extent, falling back on envelope aggregation
INFO | jvm 1 | 2011/02/01 14:58:05 | org.postgresql.util.PSQLException: ERROR: relation "public.links_shifted" does not exist
INFO | jvm 1 | 2011/02/01 14:58:05 | Where: SQL statement "SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = session_user), 'public.links_shifted', 'select')"
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.data.postgis.PostGISDialect.getOptimizedBounds(PostGISDialect.java:219)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1085)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:469)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:369)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.data.store.ContentFeatureCollection.getBounds(ContentFeatureCollection.java:273)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:498)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:714)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:484)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:296)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:129)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:108)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.wfs.xml.GML2OutputFormat.encode(GML2OutputFormat.java:275)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.wfs.xml.GML2OutputFormat.write(GML2OutputFormat.java:294)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:141)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.ows.Dispatcher.response(Dispatcher.java:751)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:233)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
INFO | jvm 1 | 2011/02/01 14:58:05 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
INFO | jvm 1 | 2011/02/01 14:58:05 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:23)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:68)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:192)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:192)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:99)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:99)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:99)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:192)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:64)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:39)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:48)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:71)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:41)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.Server.handle(Server.java:324)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
INFO | jvm 1 | 2011/02/01 14:58:05 | at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
INFO | jvm 1 | 2011/02/01 14:58:05 | 01 Feb 14:58:05 TRACE [org.geotools.core] - ENTRY 4
INFO | jvm 1 | 2011/02/01 14:58:05 | 01 Feb 14:58:05 DEBUG [org.geotools.filter] - exporting PropertyName
INFO | jvm 1 | 2011/02/01 14:58:05 | 01 Feb 14:58:05 DEBUG [org.geotools.filter] - exporting LiteralExpression
INFO | jvm 1 | 2011/02/01 14:58:05 | 01 Feb 14:58:05 DEBUG [org.geotools.jdbc] - Retriving bounding box: SELECT ST_AsText(ST_Force_2D(Envelope(ST_Extent("the_geom"::geometry))))FROM ( SELECT * FROM (SELECT gid, link_id, st_name, feat_id, ref_in_id, nref_in_id, func_class,
INFO | jvm 1 | 2011/02/01 14:58:05 | speed_cat, fr_spd_lim, to_spd_lim, to_lanes, from_lanes, dir_travel,
INFO | jvm 1 | 2011/02/01 14:58:05 | route_type, dironsign, source_zlevel, target_zlevel, source,
INFO | jvm 1 | 2011/02/01 14:58:05 | target, length, x1, y1, x2, y2, normalized, st_name_added, dironsign_added,
INFO | jvm 1 | 2011/02/01 14:58:05 | ramp,ar_trucks,frontage,bridge,tunnel,tollway,
INFO | jvm 1 | 2011/02/01 14:58:05 | CASE WHEN link_id > 1000000000 THEN
INFO | jvm 1 | 2011/02/01 14:58:05 | upgis_lineshift(the_geom, 0.00007)
INFO | jvm 1 | 2011/02/01 14:58:05 | ELSE
INFO | jvm 1 | 2011/02/01 14:58:05 | the_geom
INFO | jvm 1 | 2011/02/01 14:58:05 | END as the_geom
INFO | jvm 1 | 2011/02/01 14:58:05 | FROM links) as "vtable" WHERE "the_geom" && ST_GeomFromText('POLYGON ((-74.41322612491446 40.157375586747975, -74.41322612491446 40.15741658569541, -74.41317248073449 40.15741658569541, -74.41317248073449 40.157375586747975, -74.41322612491446 40.157375586747975))', 4326) LIMIT 10) as "GT2_BOUNDS_"
INFO | jvm 1 | 2011/02/01 14:58:06 | 01 Feb 14:58:06 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
INFO | jvm 1 | 2011/02/01 14:58:06 | 01 Feb 14:58:06 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:58:06 | 01 Feb 14:58:06 TRACE [org.geotools.core] - ENTRY 4
INFO | jvm 1 | 2011/02/01 14:58:06 | 01 Feb 14:58:06 DEBUG [org.geotools.filter] - exporting PropertyName
INFO | jvm 1 | 2011/02/01 14:58:06 | 01 Feb 14:58:06 DEBUG [org.geotools.filter] - exporting LiteralExpression
INFO | jvm 1 | 2011/02/01 14:58:06 | 01 Feb 14:58:06 DEBUG [org.geotools.jdbc] - SELECT "gid","link_id","st_name","feat_id","ref_in_id","nref_in_id","func_class","speed_cat","fr_spd_lim","to_spd_lim","to_lanes","from_lanes","dir_travel","route_type","dironsign","source_zlevel","target_zlevel","source","target","length","x1","y1","x2","y2","normalized","st_name_added","dironsign_added","ramp","ar_trucks","frontage","bridge","tunnel","tollway",encode(ST_AsBinary(ST_Force_2D("the_geom")),'base64') as "the_geom" FROM (SELECT gid, link_id, st_name, feat_id, ref_in_id, nref_in_id, func_class,
INFO | jvm 1 | 2011/02/01 14:58:06 | speed_cat, fr_spd_lim, to_spd_lim, to_lanes, from_lanes, dir_travel,
INFO | jvm 1 | 2011/02/01 14:58:06 | route_type, dironsign, source_zlevel, target_zlevel, source,
INFO | jvm 1 | 2011/02/01 14:58:06 | target, length, x1, y1, x2, y2, normalized, st_name_added, dironsign_added,
INFO | jvm 1 | 2011/02/01 14:58:06 | ramp,ar_trucks,frontage,bridge,tunnel,tollway,
INFO | jvm 1 | 2011/02/01 14:58:06 | CASE WHEN link_id > 1000000000 THEN
INFO | jvm 1 | 2011/02/01 14:58:06 | upgis_lineshift(the_geom, 0.00007)
INFO | jvm 1 | 2011/02/01 14:58:06 | ELSE
INFO | jvm 1 | 2011/02/01 14:58:06 | the_geom
INFO | jvm 1 | 2011/02/01 14:58:06 | END as the_geom
INFO | jvm 1 | 2011/02/01 14:58:06 | FROM links) as "vtable" WHERE "the_geom" && ST_GeomFromText('POLYGON ((-74.41322612491446 40.157375586747975, -74.41322612491446 40.15741658569541, -74.41317248073449 40.15741658569541, -74.41317248073449 40.157375586747975, -74.41322612491446 40.157375586747975))', 4326) LIMIT 10
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 2 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 0 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 0 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 0 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 TRACE [org.geotools.gml.producer] - ENTRY LINESTRING (-74.41929 40.1587, -74.41838 40.15847, -74.41723 40.15819, -74.41612 40.15791, -74.4149 40.15761, -74.413 40.15735, -74.41128 40.15727, -74.40994 40.15729, -74.40887 40.15737, -74.40801 40.15748, -74.40703 40.15764, -74.40597 40.15788, -74.40498 40.15816, -74.40303 40.15871, -74.39889 40.15989, -74.39494 40.16102, -74.3941 40.16122, -74.39327 40.16136, -74.39244 40.16144, -74.39142 40.16152, -74.39061 40.1615, -74.38975 40.16144, -74.38897 40.16135, -74.38817 40.1612, -74.38745 40.16103, -74.38659 40.16077, -74.38598 40.16058, -74.38428 40.1598, -74.38227 40.15889, -74.37927 40.15753)
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 TRACE [org.geotools.gml.producer] - RETURN {0}
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 2 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 0 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 0 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - 0 is not of type java.lang.Short, attempting conversion
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 TRACE [org.geotools.gml.producer] - ENTRY LINESTRING (-74.41929 40.1587, -74.41838 40.15847, -74.41723 40.15819, -74.41612 40.15791, -74.4149 40.15761, -74.413 40.15735, -74.41128 40.15727, -74.40994 40.15729, -74.40887 40.15737, -74.40801 40.15748, -74.40703 40.15764, -74.40597 40.15788, -74.40498 40.15816, -74.40303 40.15871, -74.39889 40.15989, -74.39494 40.16102, -74.3941 40.16122, -74.39327 40.16136, -74.39244 40.16144, -74.39142 40.16152, -74.39061 40.1615, -74.38975 40.16144, -74.38897 40.16135, -74.38817 40.1612, -74.38745 40.16103, -74.38659 40.16077, -74.38598 40.16058, -74.38428 40.1598, -74.38227 40.15889, -74.37927 40.15753)
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 TRACE [org.geotools.gml.producer] - RETURN {0}
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.gml] - closing reader org.geotools.data.store.ContentFeatureCollection$WrappingFeatureIterator@anonymised.com
INFO | jvm 1 | 2011/02/01 14:58:07 | 01 Feb 14:58:07 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
INFO | jvm 1 | 2011/02/01 14:58:42 | 01 Feb 14:58:42 TRACE [org.geotools.resources] - Loaded resources for English from bundle "org.geotools.resources.i18n".
INFO | jvm 1 | 2011/02/01 14:58:42 | 01 Feb 14:58:42 DEBUG [org.geotools.referencing.factory] - Closed the EPSG database connection.
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 ERROR [org.geotools.jdbc] - There's code using JDBC based datastore and not disposing them. This may lead to temporary loss of database connections. Please make sure all data access code calls DataStore.dispose() before freeing all references to it
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 ERROR [org.geotools.jdbc] - There's code using JDBC based datastore and not disposing them. This may lead to temporary loss of database connections. Please make sure all data access code calls DataStore.dispose() before freeing all references to it
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 ERROR [org.geotools.jdbc] - There's code using JDBC based datastore and not disposing them. This may lead to temporary loss of database connections. Please make sure all data access code calls DataStore.dispose() before freeing all references to it
INFO | jvm 1 | 2011/02/01 14:59:08 | 01 Feb 14:59:08 ERROR [org.geotools.jdbc] - There's code using JDBC based datastore and not disposing them. This may lead to temporary loss of database connections. Please make sure all data access code calls DataStore.dispose() before freeing all references to it
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira