Hi,
Change logging level into Geotools developer.
-Jukka Rahkonen-
________________________________
Lähettäjä: Christopher DeMars<mailto:[email protected]>
Lähetetty: 17.2.2017 6:26
Vastaanottaja:
[email protected]<mailto:[email protected]>
Aihe: [Geoserver-users] get raw SQL for parameterized SQL view
Is there a way to get the actual query that geoserver is sending to the SQL
server?
I have a moderately complex parameterized SQL view. When I run it via
geoserver, it pegs all my cores at 100% then fails after minute or so with the
following error posted to the log:
org.geoserver.platform.ServiceException: This request used more time than
allowed and has been forcefully stopped. Max rendering time is 60.0s
at
org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:571)
...
When I fill in the parameters with what is being sent by the client and run the
SQL directly on the DB, I get a full result in a second or so.
I'm at a loss on how to further debug this. I can't find anyplace where the
actual SQL sent to the DB is logged and can't find any documentation about the
problem. Following the guidelines in the manual, I tried wrapping the query
using "select * from (<the sql view>) [as] vtable" and running it on the DB and
it finished as quickly as if it were not wrapped.
Am I even looking in the right place or might this be a styling/rendering
problem? I've tried using both a generic polygon style and an attribute based
style to the same effect.
Thanks for any help or hints you can offer,
--Christopher
GeoServer Version
2.9.1
Git Revision
02d742eb7992fd70bc277cb873d7fbb2326a2eb0
Build Date
03-Aug-2016 23:34
GeoTools Version
15.1 (rev b9f0f6572d58d58374cad1c0161b424e2dd70a47)
GeoWebCache Version
1.9.1 (rev 1.9.x/02155f9a2b56230ebb01be2c987f0eaa3daf18a0)
PostgreSQL 9.4.10 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
4.8.2-19ubuntu1) 4.8.2, 64-bit
postgis_version
2.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
