[Geoserver-users] Operation on mixed SRID geometries

GeoServer GeoServer User
1

Hi,

rebooting the ubuntu server, geoserver is running again correctly.

The very strange thing that I observe is that the same postgis datastore
used with geoserver 2.3.2 run perfectly, and I’m able to get the table info
by clicking on an item of the feature, on the geoserver 2.1.2 I get the same error:

Internal error occurred java.io.IOException null ERROR: Operation on mixed SRID geometries

The layer in geoserver 2.3.2 recognize the native srs, in geoserver 2.1.2 no.
What do you suggest?

Kind regards

Eugenio

Message: 3
Date: Wed, 20 Nov 2013 17:24:22 +0100
From: Eugenio Trumpy frippe12573@anonymised.com
Subject: Re: [Geoserver-users] Operation on mixed SRID geometries
To: Stefano Iacovella <stefano.iacovella@anonymised.com…>
Cc: “geoserver-users@lists.sourceforge.net”
geoserver-users@lists.sourceforge.net
Message-ID: DUB127-W7754641E8CC74058654E39E5E60@anonymised.com
Content-Type: text/plain; charset=“iso-8859-1”

Hi again,
after my query that exclude the lines where the_geom is null, your check query give back only 4326!In the meanwhile I tried also the same datastore in another instance of geoserver, and it was working fine,so I guessed the problem was on the first geoserver

But I modify the query for producing the view excluding the rows where the_geom is empty, so I remove and re-publish that layerin geoserver but still doesn’t work.What I’m doing wrong?

If you run in postgis:

select distinct(ST_SRID(geom)) from <your_view>;

Does it return only 4326?

When you published again your view in GeoServer did it recognize the Native SRS?

Cheers,

Stefano

2

On Thu, Nov 21, 2013 at 9:36 AM, Eugenio Trumpy <frippe12573@anonymised.com>wrote:

Hi,

rebooting the ubuntu server, geoserver is running again correctly.

The very strange thing that I observe is that the same postgis datastore
used with geoserver 2.3.2 run perfectly, and I'm able to get the table info
by clicking on an item of the feature, on the geoserver 2.1.2 I get the
same error:

Internal error occurred java.io.IOException null ERROR: Operation on mixed
SRID geometries

The layer in geoserver 2.3.2 recognize the native srs, in geoserver 2.1.2
no.
What do you suggest?

Upgrading? :slight_smile:

On a more serious suggestion, have you fixed the srid in geometry_columns?

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

3

Hi,
yes I modify the query for producing that view (excluding the rows without coordinates),
but still doesn’t work.
In the preview I see the features but no info on items, with that error.

Regards

Eugenio

Date: Thu, 21 Nov 2013 09:44:24 +0100
Subject: Re: Operation on mixed SRID geometries
From: andrea.aime@anonymised.com
To: frippe12573@anonymised.com
CC: geoserver-users@anonymised.com.sourceforge.net; stefano.iacovella@anonymised.com

On Thu, Nov 21, 2013 at 9:36 AM, Eugenio Trumpy <frippe12573@anonymised.com> wrote:

Hi,

rebooting the ubuntu server, geoserver is running again correctly.

The very strange thing that I observe is that the same postgis datastore
used with geoserver 2.3.2 run perfectly, and I’m able to get the table info
by clicking on an item of the feature, on the geoserver 2.1.2 I get the same error:

Internal error occurred java.io.IOException null ERROR: Operation on mixed SRID geometries

The layer in geoserver 2.3.2 recognize the native srs, in geoserver 2.1.2 no.
What do you suggest?

Upgrading? :slight_smile:

On a more serious suggestion, have you fixed the srid in geometry_columns?

Cheers
Andrea

–

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

Ing. Andrea Aime

@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

4

On Thu, Nov 21, 2013 at 9:46 AM, Eugenio Trumpy <frippe12573@anonymised.com>wrote:

Hi,
yes I modify the query for producing that view (excluding the rows without
coordinates),
but still doesn't work.
In the preview I see the features but no info on items, with that error.

Enable "geotools developer logging" and hunt in the logs the query being
used.
Make sure you don't have "prepared statements" enabled.

What query is being used?

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

5

Hi again,

here the log output relate to the query:

2013-11-21 10:01:07,906 DEBUG [org.geotools.jdbc] - SELECT count(*) AS gt_result_ FROM (SELECT * FROM “public”.“pozzi_decodificati_vigor” WHERE (“the_geom” && ST_GeomFromText(‘POLYGON ((18.71948828125 40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))’, 0) AND ST_Intersects(“the_geom”, ST_GeomFromText(‘POLYGON ((18.71948828125 40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))’, 0)) AND (‘ALL_LABEL_CLASSES_ENABLED’ = ‘ALL_LABEL_CLASSES_ENABLED’ AND 1 = 1)) LIMIT 50) gt_limited_
2013-11-21 10:01:07,925 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2013-11-21 10:01:07,925 ERROR [org.geoserver.ows] -
org.geoserver.platform.ServiceException: Internal error occurred
at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:177)
at org.geoserver.wms.GetFeatureInfo.run(GetFeatureInfo.java:122)
at org.geoserver.wms.DefaultWebMapService.getFeatureInfo(DefaultWebMapService.java:371)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy28.getFeatureInfo(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:630)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
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:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
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:23)
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.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
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:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
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:41)
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:46)
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:859)
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: java.lang.RuntimeException: java.io.IOException
at org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:354)
at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.size(ForceCoordinateSystemFeatureResults.java:105)
at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:278)
at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:173)
… 84 more
Caused by: java.io.IOException
at org.geotools.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1289)
at org.geotools.jdbc.JDBCDataStore.getCount(JDBCDataStore.java:1219)
at org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:409)
at org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:413)
at org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:327)
… 87 more
Caused by: org.postgresql.util.PSQLException: ERROR: Operation on mixed SRID geometries
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.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1269)
… 91 more

I tried also to delete the layer and re-publish it.
I checked the srid with:
select distinct(SRID(the_geom)) as srid, count(*) from pozzi_decodificati_vigor group by srid
and I get only one record: 4326

of course an upgrade could be a good and quick solution, but also understand why it happens is curios!

regards

Eugenio

Date: Thu, 21 Nov 2013 09:48:42 +0100
Subject: Re: Operation on mixed SRID geometries
From: andrea.aime@anonymised.com
To: frippe12573@anonymised.com
CC: geoserver-users@lists.sourceforge.net

On Thu, Nov 21, 2013 at 9:46 AM, Eugenio Trumpy <frippe12573@anonymised.com> wrote:

Hi,
yes I modify the query for producing that view (excluding the rows without coordinates),

but still doesn’t work.

In the preview I see the features but no info on items, with that error.

Enable “geotools developer logging” and hunt in the logs the query being used.
Make sure you don’t have “prepared statements” enabled.

What query is being used?

Cheers
Andrea

6

On Thu, Nov 21, 2013 at 10:06 AM, Eugenio Trumpy <frippe12573@anonymised.com>wrote:

Hi again,

here the log output relate to the query:
2013-11-21 10:01:07,906 DEBUG [org.geotools.jdbc] - SELECT count(*) AS
gt_result_ FROM (SELECT * FROM "public"."pozzi_decodificati_vigor" WHERE
("the_geom" && ST_GeomFromText('POLYGON ((18.71948828125 40.28446472745902,
19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869,
18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))', 0)
AND ST_Intersects("the_geom", ST_GeomFromText('POLYGON ((18.71948828125
40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002
39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125
40.28446472745902))', 0)) AND ('ALL_LABEL_CLASSES_ENABLED' =
'ALL_LABEL_CLASSES_ENABLED' AND 1 = 1)) LIMIT 50) gt_limited_

Ok, so this GeoServer still thinks the srid is 0.
The srid is read the first time GeoServer tries to access that view
(normally, during startup when checking if the feature type can be computed)
and from there on, it won't consult the geometry_columns anymore.
Well, unless you force it to, by using the "reset" button in the status
page, or by restarting GeoServer fully

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

7

ST_GeomFromText(‘POLYGON ((18.71948828125 40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))’, 0)

The query create a geometry object with SRID = 0 while your view contains records with SRID = 4326

Stefano

···

41.95581N 12.52854E

http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas

2013/11/21 Eugenio Trumpy <frippe12573@anonymised.com>

Hi again,

here the log output relate to the query:

2013-11-21 10:01:07,906 DEBUG [org.geotools.jdbc] - SELECT count(*) AS gt_result_ FROM (SELECT * FROM “public”.“pozzi_decodificati_vigor” WHERE (“the_geom” && ST_GeomFromText(‘POLYGON ((18.71948828125 40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))’, 0) AND ST_Intersects(“the_geom”, ST_GeomFromText(‘POLYGON ((18.71948828125 40.28446472745902, 19.074246093750002 40.28446472745902, 19.074246093750002 39.92970692827869, 18.71948828125 39.92970692827869, 18.71948828125 40.28446472745902))’, 0)) AND (‘ALL_LABEL_CLASSES_ENABLED’ = ‘ALL_LABEL_CLASSES_ENABLED’ AND 1 = 1)) LIMIT 50) gt_limited_
2013-11-21 10:01:07,925 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2013-11-21 10:01:07,925 ERROR [org.geoserver.ows] -
org.geoserver.platform.ServiceException: Internal error occurred
at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:177)
at org.geoserver.wms.GetFeatureInfo.run(GetFeatureInfo.java:122)
at org.geoserver.wms.DefaultWebMapService.getFeatureInfo(DefaultWebMapService.java:371)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.RequestObjectLogger.invoke(RequestObjectLogger.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy28.getFeatureInfo(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:630)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:234)
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:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
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:23)
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.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
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:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:183)
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:41)
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:46)
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:859)
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: java.lang.RuntimeException: java.io.IOException
at org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:354)
at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.size(ForceCoordinateSystemFeatureResults.java:105)
at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:278)
at org.geoserver.wms.GetFeatureInfo.execute(GetFeatureInfo.java:173)
… 84 more
Caused by: java.io.IOException
at org.geotools.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1289)
at org.geotools.jdbc.JDBCDataStore.getCount(JDBCDataStore.java:1219)
at org.geotools.jdbc.JDBCFeatureSource.getCountInternal(JDBCFeatureSource.java:409)
at org.geotools.data.store.ContentFeatureSource.getCount(ContentFeatureSource.java:413)
at org.geotools.data.store.ContentFeatureCollection.size(ContentFeatureCollection.java:327)
… 87 more
Caused by: org.postgresql.util.PSQLException: ERROR: Operation on mixed SRID geometries
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.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1269)
… 91 more

I tried also to delete the layer and re-publish it.
I checked the srid with:
select distinct(SRID(the_geom)) as srid, count(*) from pozzi_decodificati_vigor group by srid
and I get only one record: 4326

of course an upgrade could be a good and quick solution, but also understand why it happens is curios!

regards

Eugenio

Date: Thu, 21 Nov 2013 09:48:42 +0100
Subject: Re: Operation on mixed SRID geometries
From: andrea.aime@anonymised.com
To: frippe12573@anonymised.com…95…
CC: geoserver-users@lists.sourceforge.net

On Thu, Nov 21, 2013 at 9:46 AM, Eugenio Trumpy <frippe12573@anonymised.com> wrote:

Hi,
yes I modify the query for producing that view (excluding the rows without coordinates),

but still doesn’t work.

In the preview I see the features but no info on items, with that error.

Enable “geotools developer logging” and hunt in the logs the query being used.
Make sure you don’t have “prepared statements” enabled.

What query is being used?

Cheers
Andrea

Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users